I am trying to display an HTML page with values from the spreadsheet. I click on my Generate HTML page link and it redirects to the HTML page I created. It displays correctly except that the script always gets values from the first row. I am under the impression that the doGet() function does not accept rows?…
Tag: google-apps-script
reference does not exist with custom function – google script
I’m trying to call this API response using a custom function where I can change the parameters. This is my code: This is what I’m typing in the spreadsheet: But when I do it I get a “reference does not exist” error. Thank you. Answer Please modify as follows and test it again. Modified…
Google Script required to copy and save data from one tab to another, then clear original tab cells – Google Sheets [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 2 years ago. Improve this question I have next to no code experience and have been set this task – any help would be much…
The Java Script Results not showing in HTML
I wrote a GAS code to check if the employee is In or Not in (extracting data from Google sheets). The console log give me the right answer but When I click on the button the answer doesn’t appear at the front end. Can you help me to troubleshoot on where I went wrong? Answer Google provides a very good
Replace multiple occurrences in String on Google Spreadsheet
So I have a spreadsheet up for the purpose of documenting descriptions of functions found in some python files. TLDR these descriptions are hard to read due to the clutter left over from the files. So my solution to solve this was: But it only works on the first occurrence when I need it to happen multiple ti…
Cross reference names on spreadsheets to get specific data points (looping through an array)
I have two sheets. Test Data has 3-4k entries of many columns of data and Order Changes has no data at all. I would like to search two specific columns on Test Data, a column of names and a column of yes or no. If column two of Test Data contains a ‘yes’ in the cell then the name of
Populating and formatting JSON into a Google Sheet
Thank you in advance to anyone that is able to help me on this. I have been trying for days to make this work, and just don’t know enough about this to figure it out using examples. I have developed an Android app that places orders in a Realtime Database. Each order has its own ID that is generated by
How get the Employee Title from Admin Directory?
I’m expecting to get the job title of the user via using google app script, but I’m getting the log print as follows The below is my code What I’m trying to do is get only the title of the employee. I’ve tried adding [1] or [2] or [3] after the .orgainizations object but it doesn’…
Authorization error still persists when calling getDataSourceFormula() even after allowing script to acces Google Sheets
I am trying to get the content of a cell’s formula from a custom function that I wrote. I’m just trying to get the formula stored in B2. In Google Sheets. I am getting “Exception: Authorization is required to perform that action. (line 5).”. I tried revoking the authorization, adding t…
Send full response back along with modified key-value pairs to other API after getting data from one API
I’m getting this as the response from an internal API of my company: Sample: I’m modifying the values of these keys and just sending them to the update api using post request payload: Problem : When I am sending only those updated values to the API, all other values of other keys except name are b…