Hello I have an app where you can book a ticket for an event. The app has about 20-30 events per year. For each event you can register and then receive an SMS confirmation. Each event has its own sheet. With App Script a function is created per sheet. A trigger that checks if there is a new entry t…

Is 2-SMS-Vorlage an exact match for the name of the sheet, including case and whitespace? Just as an aside, I would move this line… var ss = SpreadsheetApp.getActiveSpreadsheet(); …outside the forEach() loop. ie. move it up to line 6. It should still work the way you have it, but creating a new s…

How to call multiple sheets with the same script? (Apps Script)

Ask for Help

Tim July 14, 2022, 8:36am 13

Hey Uzo

That was my basis:

var sheet = ss.getSheetByName(name); refers to row 7 this calls the array above.

Topic		Replies	Views
SMS script no longer works after Rhino migrated to V8 runtime… (Apps Script) Ask for Help custom-code	2	111	May 3, 2024
Script experts? Ask for Help	5	393	June 12, 2022
Searching for rows in sheet Ask for Help	22	1851	February 17, 2020
How to use Webhook to run Google sheets App Script Functions Ask for Help	4	1003	September 26, 2023
Duplicating data on a form response based on a value entered Ask for Help	8	209	June 10, 2023

How to call multiple sheets with the same script? (Apps Script)

Related topics