google-apps-script tag

111 questions


1 answers
40 views
0
Google Apps Script try catch Handling

We are creating a GAS that transfers the parameters entered from the Google form to the specified spreadsheet.The spreadsheet provides edit protection to allow only certain user privileges to be writt...

2 years ago

1 answers
40 views
0
Extraction of rows containing specific strings in Google Apps Script (GAS)

I'm creating a code that only takes out certain strings in the first column of the spreadsheet, but it doesn't work.I would appreciate it if you could point it out.function myFunction(){ const sheet =...

2 years ago

1 answers
45 views
0
The recipient is not configured.suddenly received an error message.

Is there a chance that something that has been functioning normally suddenly becomes an error?I reply automatically with the following settings.But Failed to send mail: No recipient specified (line 69...

2 years ago

1 answers
41 views
0
Google Apps Script Run Environment Determination

Attempting to run the V8 engine in Google Apps Script I have a question.I think the GAS engines are V8 or Rhino, but how should I judge these two?Also, how can I determine if a code is working in a no...

2 years ago

1 answers
39 views
0
GAS cannot add more than one member when creating a new Trello card

GAS is creating a new Trello card from Google Spreadsheet.The Trello specification should allow you to assign more than one member to the card, but if you try to do so with GAS, you get an error.Pleas...

2 years ago

1 answers
105 views
0
I want to get the appropriate number of emails that can be sent under the Gsuite contract.

This is my first time to use it.I look forward to your kind cooperation.Currently, the number of remaining Gmail emails that can be sent from the spreadsheet script is MailApp.getRemainingDailyQuota()...


1 answers
42 views
0
I want to get the last line with GAS data

I'd like to use GAS to get the last row or last column with spreadsheet data.Previously, the data up to the last line with the spreadsheet data was obtained with the following code, but the number of ...


1 answers
99 views
0
Google App Script htmlservice Dialog Process Does Not Work with Firefox

I wrote the following code because I wanted to display the dialog on the spreadsheet in GAS.I tried running this on a spreadsheet, but it works with Google Chrome, but it doesn't work with Firefox.(Di...


1 answers
41 views
0
Obtaining the Email Address of a Login User in a Different Domain

Published as a web applicationRun the application as: Who is accessing the web application?Users with access to the application: All If you are configuring and scriptsSession.getActiveUser().getEmail(...

2 years ago

1 answers
41 views
0
I would like to send an email when I add it from the form to the Google spreadsheet.

We put Contact Form 7 and CF7 Google Sheet Connector in WordPress, and add input from Contact Form 7 to the bottom of Sheet 1 of the Google spreadsheet.Now, please enter your province in the pref sect...

2 years ago
« - 8 - »

© 2024 OneMinuteCode. All rights reserved.