• <button id="n9woc"><object id="n9woc"></object></button>

    1. <tbody id="n9woc"></tbody>
    2. <button id="n9woc"><object id="n9woc"></object></button>

      <em id="n9woc"></em>

      Questions tagged [google-apps-script]

      Use for questions about Google Apps Script, Google's JavaScript-based cloud scripting platform for automating tasks across Google products and third-party services. Use in addition to relevant product-specific (e.g. [google-sheets], [google-docs]) or API-specific (e.g. [google-drive-api]) tags where applicable

      Filter by
      Sorted by
      Tagged with
      0
      votes
      0answers
      11 views

      How can I switch from legacy editor to new editor in google app script?

      I just did the wrong operation that make the legacy editor as the default editor. Does anyone knows how to set new editor as default? THX Di
      0
      votes
      2answers
      19 views

      How do I replace a value in one cell based on value in another cell?

      function CopyinData_AM_A() { /* Edit the vars below this line for your needs */ var sourceSheet = "Students AM" ; // Enter the name of the sheet with the source data var sourceRange = &...
      0
      votes
      1answer
      33 views

      How can I leave a blank space/column inside an appended row?

      Im trying to leave a blank column in between data of an appended row, so that i can add a VLOOKUP funtion, functionally I don't need to do this (i could just add the VLOOKUP to the end of the row), ...
      0
      votes
      0answers
      12 views

      Request too large Google Drive Api Drive.Files.Insert. Transform a Large Excel File to Google Sheets

      I have a script with google apps script that transform a excel file to google sheets and later load the data on a different google sheet. Now, the excel file its become larger and i have had problems ...
      0
      votes
      0answers
      11 views

      Run Google Sheets Plugin as different user

      I have two sheets as "Enquiry" and "Master" with owner as "Admin". In enquiry sheet, I protected few columns and shared across users. Users enter data in enquiry sheet ...
      0
      votes
      1answer
      16 views

      Opening a spreadsheet via google App Script

      I have been trying to open a existing spreadsheet by following code and it does not give any error but not open the spreadsheet as well. can someone please help in this regards. function ...
      1
      vote
      0answers
      25 views

      Trouble in Multiple If Statement Return in Google App Script

      I'm using GAS to deploy google web app. What I'm trying to do is, I want to show respective website address/message to individuals based on the user names in Google workspace AdminDirectory. I'm ...
      0
      votes
      0answers
      22 views

      Download files from the google shared drive

      I wanted to download files - Sarcasm_Headlines_Dataset.json and glove.6B.300d.txt from https://drive.google.com/drive/folders/1s37-DVvRWfOcv59ojc6DnwHzPFkA6e8M into my drive so that I can read in ...
      0
      votes
      2answers
      20 views

      Change Header and Footer margin with Google Apps Script

      I looked here: https://developers.google.com/apps-script/reference/document/footer-section and here: https://developers.google.com/apps-script/reference/document/attribute I want to be able to change ...
      0
      votes
      1answer
      22 views

      How to pass range object in Custom 'whenFormulaSatisfued' function in Google Script?

      I am creating a custom function that will highlight a cell if its length is greater than 850. I have written the below code: colIndex = getColByName('Response'); var range = sheet.getRange(1, colIndex,...
      0
      votes
      1answer
      26 views

      Using batch request when insert columns in google spreadsheet

      I'm trying to insert a large number of columns into a table, I need to insert through 2 columns, now my code looks like this sheet.insertColumnAfter(16),sheet.insertColumnAfter(18),sheet....
      1
      vote
      0answers
      10 views

      Issue matching argument in google script [duplicate]

      I am new to scripting, and have been trying to get a script to place a date in an adjacent cell when a checkbox is checked. This is a minor part of the whole script I am trying to get working. I am ...
      0
      votes
      1answer
      20 views

      Validate google spreadsheet ID in appscript

      I would like to know if there is a way to check if a string, is a google spreadsheet ID or not in Appscript For eg, if I have a text box in which, users can enter spreadsheet ID. EG: ...
      0
      votes
      0answers
      13 views

      How to create zoom in/out in google visualization / apps?

      I have written a code in google web app that draw a timeline for me and it is working perfect. The problem is that I have to many data in the spreadsheet so I would like to zoom in out the chart. I ...
      1
      vote
      1answer
      28 views

      highlighting maximum values in a specific column using Google App Script

      I`m trying to write a script that can find the maximum value in a specific column (proportion column in the given dataset) and highlight the cell accordingly. Below is where I am at so far function ...

      15 30 50 per page
      1
      2 3 4 5
      2522
      欧美日韩国产在线一区二区_午夜短视频在线观看_亚洲国产欧美日本视频_亚洲精品高清视频在线观看