I’m new to coding and i’m having issues with a code where i keep getting “Error Syntaxis: Missing ) after argument This is my current code: This is my second script, the first one i built it to create PDF for each new google form entry and in column 19 the PDF link is written. The idea is th…
Tag: google-sheets
Convert timestamp from API to date app script
Running in App script, google sheet. I get timestamp from API and return this result: Now I want to convert this timestamp to date to be like that: 10/28/2021 10:30 I try this code: var convertDate = Utilities.formatDate(timestamp, “GMT”, “MM-dd-yyyy HH:mm:ss”); but not working any sug…
I want to apply script to multiple subsheet in one Sheet
I followed youtube instruction and copied this script I want to apply this script to all subsheet in the file. so I tried to add more sheet name like or and they didn’ work. I don’t have any, even rudimentary knowledge to this area, could you teach me how can I apply this script on whole subsheet,…
How do I create an export to Google Sheet button on a web page?
Say I have a page like this: I want the user to click the button “Open in Google Sheet” and open the csv as a spreadsheet. I saw that Google Analytics and some other Google products have this button. But I didn’t find 3rdparty webapps have this. Is that possible for me to use it? Answer I be…
Make API request to google analytics from Google Sheets using Google Apps Script
I have a workflow that adds a new row to a google sheet every time the lifecycle property changes in the CRM. The output includes the Google CID, Persona, Hubspot Customer Id and new Lifecycle into a google sheet. It looks like this – CRM 2 Google Analytics Google Sheet There is a settings sheet that co…
Moving file appscript -> Hyperlink move to another folder – Google App Script
I am trying with all my energy to create a code where I get a hyperlink of a file (uploaded to folder in drive) and move this file depending on a conditionn (switch case statement). When I dissect the code and create subparts every subpart works. Am Stuck. Answer You can’t do it with onEdit() trigger. S…
Running an onEdit Script on selected sheets only
I am new to coding Scripts but have managed to copy and edit (bodge…) a script that will onEdit, put a custom timestamp into the cell next to the cell where the edit took place. The script targets x2 onEdit columns (3,6), timestamping the cell offset(-1). The workbook has developed to include multiple s…
Google Appscript transpose dynamic data group from one column
I’ve been jogging my brain trying to figure out how to write this script to transpose data from one sheet to another from a pretty dirty sheet. There are other questions like this but none seem to be like my particular use case. This is how the sheet is currently structured (somewhat): The biggest issue…
Var not being used in object.var
What should I be doing differently? At the end, it logs {name={rows=[0.0, 1.0, 2.0, …]}} instead of having an object for each name…? In the sheet there’s just a first name and last name on columns A and B, for around 80 rows. Answer Use the bracket syntax if you want to use dynamic names for…
GAS, Bootstrap Web form Searches and Shows Data in a table, BUT it does NOT show links or hyperlinks to click on them (from spreadsheet)
Here is the web app https://script.google.com/macros/s/AKfycbyEHj5qtIeCZh4rR6FutBLQ3N9NihreaTv7BFj4_saOfNWJUG0Tn2OtvzQs4zASYHnNiA/exec Any idea on how could I make it show up the links or hyperlinks some cells have? I have made this web form mainly following a tutorial so I’m somewhat new, I try to unde…