I need an array with the boolean values, but instead, it gives me the variable name. Here is a simplistic example: I declare variable to check for match to other data, gives boolean results. var usatest = new RegExp("USA").test(continent); //this…
I want to exactly match the key from an Object to an element in an array and replace the match in the array with the key value. I have Arr = [ 'Saturday', 'niCCCght', 'plans,', 'CCC' ] Obj = {…
It was working fine up until yesterday, its a script to take in one number and see how many combinations another set of numbers will add up to that one number. It is producing a blank field in column J,…
when I save each google form entry in my linkde google sheet, it adds a column with the response's timestamp. What I see in that cell is something like this "17/01/2024 20:55:23". When I print the content of this cell…
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…