I have two sheets, both have a column that use data validation in Column G/#7, starting from row #8 and all the way down. I have to edit the data validation every once in a while and match the lists for both sheets. This can be annoying since it starts from row 8 down to row 1000+ and needs to
Tag: google-apps-script
google script sheet, merging rows duplicate in array [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question lets say i have a 3D array data with something like this (dynamically duplicates, sometimes 2…
Nothing being Outputted after first Function Call – Javascript
I’m working on a javascript project that will list everything from user name, email, phone number, and notes from AD into into a spreadsheet, so far i have two functions. however anything i put after getExternalID(users[i].externalIds ||[] does not output any information. here’s a snippet of what …
BigQuery can’t find job when using pagination
I’ve been using this AppScript function that I took from here with slight modifications and it seemed to work fine, it just takes in a query and returns a 2D array. However, if the query is big and comes back with more totalRows than rows and therefore requires pagination, the job doesn’t seem to …
How do I change my formula syntax to use variables
I’m trying to use set formula but it keeps saying I’m having an issue with my syntax but I’m not exactly sure how to fix it. I’m trying to use declared variables as the inputs to the formula. The bold line below is where I’m having the problem. Answer Use the concatenate operator…
Issue in creating script that copy the sheet and update it based on form response
I am trying to make a copy of Template in same folder when user submits the form and than update the fields in new copied sheet based on what user has submitted in the form response. New sheet is creating successfully but response I am getting in the form is not updating in the new sheet. Need help in finding
Bitly API V4 in Google Apps Script: getting errors when trying to call clicks summary
I am fairly new to Apps Script and this is my first custom function using an API. Thankyou in advance for your advice. I have been following this code to integrate Bitly into Google Sheets. https://gist.github.com/misterhay/38a500545ce7abc75b875f33f01c9f51 The code they provide for ShortenBitly works perfectl…
How to use apps script to count cells number and change the context in other column based on it?
Currently, I have three columns in my google sheets, column 1 is the company name, column 2 is industries name and column 3 is turnover (but the data is repeated). And I want to count the same company name and divide the turnover based on that number use apps script. Here are the example and result I want. Th…
Adding Variables to getRange()
Having a hard time with the below Google Scripts JS code. Here’s what it’s supposed to do. Copy and paste info from active sheet from column M to column AA Go to sheet 2, get the last cell with data and add one row before pasting the new information. If nothing is there then paste to the top of th…
Update Salesforce field with Google App Script
I can get a case like this: This returns I would like to update Document_No__c to myString I was expecting to be able to change this to a patch and add the payload like this: However this is returning the error: Answer I needed to point to the right end point, as well as use @Tanaike’s change to the pay…