My project is on Google Apps Script. I've been working on writing an html dialogue for a dropdown menu. I was having issues with getting my secondary function to run, and I've whittled down the issue with google.script.run. When I…
I am new to JavaScript and I need help with App Script, please. I have a Google Sheet with three columns: Date (Data type 'Date'), Greeting and Message (both Data Type 'String'). I would like to loop through the sheet…
I'm building a web app to take files from a web form and put them in a Google Drive folder. Upon submitting the form, I want to run a cloud function with google.script.run while passing through the form object as…
I am currently working a small Google Apps Script that will get Data from a from and proceed to paste some of this data in a table where it finds matching ID / invoice number. However, when these two for…
Sorry but I don't understand much about programming. I'm trying to merge two codes and make them autonomous in functioning when a new response arrives from the google form. Everything works except this part: function onEdit1(e) in this case the…
I have a form submit trigger configured from apps script like this: The onSubmit function is this: function onSubmit(e) { console.log("Form submitted", JSON.stringify(e.namedValues)); console.log("Form submitted", JSON.stringify(e)); } But whenever I submit the form, the trigger does get fired and function…
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…
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…
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…
I have three drop down fields, one is pulling list of accounts and another drop down field is pulling the list of properties associated with that account. Once the property is selected, the third drop down is populated. The second…