What I would like to do is to create a script or with a function that will add automatically the day, the month and the year per row for 4 years for example in order to make a calendar of shooting, pre production and post prod per film. It would be so long to do it manually and add each
Tag: google-apps-script
How to make adjacent col’s input field mandatory based on a selection in another column/same row HTML Table?
There’s quite a few examples around, but I couldn’t find one covering a table. The intent is to have the Comments column’s input field shown as mandatory, if value Rejected or Discuss is selected in an adjacent column. Here’s a Fiddle I’ve seen that there should be an onchange added to each row of the table, which would call a
How to get these 2D array elements summed if there are duplicates?
I have seen a couple of examples, but handling arrays with 2 elements in it and I was wondering what changes would have to be made so that this one gets summed by comparing the first element and calculating the 4th elements Expected Result Appreciate your help! Thanks! Answer Just update the array indices of the required elements In my
How to fix Google Apps Script Function Running in random sequence
I have a project that will generate a dynamic Listbox from GSheet and it will update the customized form i’ve created in Google Apps Script. The code will get the input from the URL when it is loaded and generate 2 ListBox first before getting the input data to pre-fill the form. So the Sequence should be Generate the Selection
Wrapper around importdata() in Google Sheets
I am trying to write a wrapper around Google Sheets’ importdata() in code.gs: The idea is to call the function from any sheet in the spreadsheet to get the price of any crypto currency token: I get an error though when I try this: #ERROR Exception: You do not have permission to perform that action. (line 102). Why is this
Modify Google Forms confirmation page to display the time stamp using App Script .gs
I watched this youtube [1] which is in Hindi. I don’t understand what he says but see what he does and that it works. So I tried to replicate to get the same result: for the Confirmation Page of a Google Form to display the date and time. I actually prefer to get the submission time stamp, but perhaps it
How to display values from google script object in html ?
HTML code I want to display object values in this form in <p or easier solutions GOOGLE SCRIPT code function findId returns row number by typed id Answer In your situation, how about the following modification? HTML & Javascript side: From To: Google Apps Script side: From To: Note: From <p id=”serial”>result</p>, I guessed that you might have wanted to
App Script new Google Sheet creation issue
I am trying to write an App Script that takes string data from multiple different spreadsheets (completely separate documents) and puts them all in a new spreadsheet. When I run the logger, it shows me all the data I want. I want each piece of data to show up in Column A, but when I run my script, it only
Parsing JSON into Google spreadsheet (Apps Script)
I have a download in JSON format that I get through the API. Example: An example of what should happen: enter image description here The ratio of the JSON list of employees with columns in the table: How can I convert JSON to a Google spreadsheet for 300+ rows? At the moment I only have a request to the API.
Certain number question being missed in regex
I have the following if statement that removes the first instances of a number followed by the period. However, I am noticing it is missing to catch some of them (ex. “16.”, “23.”, “24.”, etc.) and not sure why. Here is the function: The following for loop extracts the question from the google form: The following example is the type