Convert list of lists to JSON
I have some data in a Google sheet that I want to convert to a .json file using Google Apps Script, however I am struggling to figure out the best way to approach it. I have an implementation already that…
Javascript – How can I remove the empty rows before saving the data?
I have a code and the link google sheet the problem is when I fill in the data and then click on the button Submit at PrintForm sheet the data will be saved to PrintLog sheet but it includes the…
Javascript – Adding a cell value to another cell then deleting the original cell value
I have sheet that i'm using to track servicings on a machine. I want to have a cell that I can put in hours the machine was used for. That value would then be added to another cell tracking total…
HTML form POST to Google Sheet when two forms are present instead of one
Below I have my HTML code that includes two forms, they are both the same except for the name field that only does what it is intended to do when a form is before it (doesn't matter if it's displayable…
Javascript – Email only sends if a cc is set
I'm trying to make my script send an email. The email has mail to and cc but the email wont send if the cc is missing. Not all my rows have a cc email. I want to send the email…
Convert content to text parsing JSON URL response
I've got a url where the result is shown as below "playerInfo": { "059gh": { "eligiblePos": "Flx3,G,Flx,Flx2,PG", "status": "FA" }, "04mr6": { "eligiblePos": "Flx3,G,Flx,Flx2,PG", "status": "FA" }, "059fz": { "eligiblePos": "Flx3,G,Flx,Flx2,PG", "status": "FA" }, "059fw": { "eligiblePos": "Flx3,G,Flx,Flx2,PG", "status": "FA"…
Javascript – Need to return a dynamic set of columns from 2d array
I need to return several columns from an array pulled out of Google Sheets. Currently my code is let out = data.map(function (row, index) { return [row[1], row[0], row[36], row[6], row[45], row[46], row[47], row[7]]}); This code works well. But the…
Javascript – Function button not working, only works manual input
Can you please help me why its not working everytime i click on button its not updating. I want to get the old value of column J and column K and set it to column L and M everytime it…
Javascript – Can I reference the sheet tab before the active sheet tab without using it's name?
It it possible to reference a cell in the sheet tab before the active sheet tab? For instance, my active sheet is 'Sheet 2' but I want to reference 'A1' in 'Sheet 1'. However I don't want to use the…
Javascript – Convert languages excel to google sheets
Apologies if this thread have already been listed or if I am doing something wrong for what ever reason, I don't know forums that well. I have a piece of code that I am struggling with. I started using google…