google-apps-script
Duplicate Google Spreadsheet on Demand
I\'ve created a pretty complex G开发者_Go百科oogle spreadsheet.I would like a user to be able to click a button or follow a link, and get a copy of this spreadsheet where they can fill in data.I would[详细]
2023-01-05 18:09 分类:问答Is it possible to automate Google Spreadsheets Scripts (e.g. without an event to trigger them)?
Does anyone know if it\'s possible to use Google Apps Scripts to run without needed a manual event? Meaning - I would like to set up a spreadsheet to send a form every day at a specified time. I have[详细]
2023-01-03 14:39 分类:问答Display HTML-formated message box in Google Apps Script?
The Browser.msgBox(\"hello\")开发者_如何学JAVA method lets me display the text \"hello\" to the user in a message box, but if I put any HTML in there, for example \"Hi there\", the user just sees the[详细]
2022-12-28 21:04 分类:问答Reference Error for property of Javascript Object
I have built an object in Javascript on the Google Apps Script engine and every time I run my script I get a reference error saying uName is not defined.[详细]
2022-12-27 20:03 分类:问答Import JSON data into Google Sheets
I am pulling data from a web service and it开发者_开发问答 is formatted as JSON. I am writing a Google Apps Script for Google Sheets that will populate the data for me. My problem is, I can\'t seem to[详细]
2022-12-27 11:22 分类:问答How can developers edit a Google Doc programmatically? Is there a Docs API?
There doesn\'t seem to be (to my knowledge) an API to edit Google Docs (not spreadsheets, their HTML based documents). Has anyone done something like the? Maybe by downloading the HTML version, editin[详细]
2022-12-23 06:51 分类:问答VBA to Javascript [duplicate]
This question already has answers here: 开发者_如何学C How to convert VBA script to Google Apps Script automatically?[详细]
2022-12-20 18:11 分类:问答GAS files: how to free global space from polution?
How do I clean up my global space without having to create +1000 lines .gs files Here follows two photos of some of my files/folders. Mind how low the scroll bar can slide (30+ GAS files) ↓[详细]
2022-12-07 22:40 分类:问答How to prevent UrlFetchApp.fetch from going on forever? [duplicate]
This question already has answers here: Lower the timeout for urlFetchApp.fetch function (1 answer) Timeout Error - DHL API to Google Sheets - UrlFetchApp[详细]
2022-12-07 22:39 分类:问答Convert Google Sheet to CSV then attach it to an email
I have a simple Apps Script need, but can\'t find a near enough sample from the community. I need to convert 2 sheets from a Google Spreadsheet, individually, as CSV files then attach them in an email[详细]
2022-12-07 22:25 分类:问答