55,620 questions
0
votes
0
answers
25
views
Data and Answer Sync Issues When Generating Quizzes from Sheets to Forms
I created a Physics quiz using Google Forms, with the question content preloaded in a Google Sheet named "test".
In the "test" sheet, there are 2 columns:
Column B contains the ...
0
votes
0
answers
55
views
Menu not showing after install; issues with onOpen() and AuthMode.NONE
I'm working on a Google Workspace Add-on (a Mail Merge tool), and I keep getting rejected by the GWM review team with this feedback:
*
Menu - Menu options not shown after App is installed. Please ...
-4
votes
0
answers
72
views
How to improve handwriting recognition in an image [closed]
I'm trying to develop a system to read the handwriting in a chart within a written page, using a multimodal LLM. I'm using Google apps script So far I've experimented:
function openRouterApiRequest() {...
- 36.6k
-5
votes
0
answers
42
views
Creating a conditional function in Apps Script (Sheets) that auto-populates a new entry [closed]
I'm in the very early stages of building out this script, so any guidance is appreciated.
I have a Sheets document that inventories devices such as laptops. Each entry has a variety of columns ...
1
vote
0
answers
64
views
Change title of table depends on the title in the sheet using data array [closed]
Is there a formula using the data array that, when I change the value in the sheet, also changes the title in the data array and refelect it in the table?
Here a example when i change the April 1, ...
- 27
0
votes
1
answer
62
views
getStartTime/getEndTime
Im currently working on a simple internal add-on for google calendar. When we click a event we will choose a option from a dropdown and click a button. When that happens, take the selected item with ...
- 11
0
votes
1
answer
75
views
How to troubleshooting a Google Script on a sheet to auto-send Emails [duplicate]
I have been trying to make this code work to send an email when I edit my sheet. It's just not working, can someone give me guidence?
photo of the sheet
photo of code in editor
function onEdit(e) {
...
0
votes
3
answers
117
views
Sort Sheet Range in Natural Order
Using Google Apps Script (not using functions), in Google Sheets, how can I sort a range in natural order (so that "4. This thing" comes before "10. That Thing"). Here is what I've ...
- 2,663
1
vote
0
answers
53
views
TypeError: dataTable.addRows is undefined in Charts.newDataTable() [closed]
I'm encountering a very strange issue in Google Apps Script and I'm hoping someone can shed some light on it. I'm getting a TypeError: dataTable.addRows is not a function when trying to build a ...
-1
votes
1
answer
82
views
Exception: The parameters (String,String,null,(class)) don't match the method signature for CalendarApp.Calendar.createEvent
I am trying to create a google sheet that I can use to schedule a workshop servicing calendar.
I have followed the below tutorial but am getting something wrong, hoping someone can easily identify the ...
0
votes
2
answers
62
views
How can I prevent my Apps Script code from timing out?
I have the following code:
function onOpen() {
const ss = SpreadsheetApp.getActive();
ss.getSheets().forEach((sheet, index) => {
if (index < 9) {
const lastRow = sheet.getLastRow();...
- 53
2
votes
1
answer
60
views
forEach is showing red bracket, but the script seems to be working
I am sure this is an error on my part, but since the script works, not sure if this is a problem waiting to show up at some point. I have 11 tabs, and the script will run through the first 9 tabs and ...
- 53
0
votes
0
answers
68
views
Posting to Google Sheets via Google Apps Script - "Unexpected token '<', "<!DOCTYPE "... is not valid JSON" Error [closed]
I'm a beginner web developer building an online RSVP form that should save data to a Google Sheet via a Heroku proxy and Google Apps Script. While fetching data works, submitting form data via a POST ...
1
vote
0
answers
55
views
The ESP32-S3 resets the count and starts from 0 again [closed]
I have been trying to program my ESP32-S3 in such a manner that when it is reconnected, it starts the count from where it left off.
For eg: If in the google sheet the count was 10 before disconnecting ...
- 65
-6
votes
0
answers
41
views
In google sheets if a cell colour changes to yellow perform a vlookup in that cell [closed]
In google sheets is there an app script where if the cell colour changes to e.g. yellow, then within the same cell it performs a vlookup against a table. The value returned then needs to multiply by ...
- 11