google-apps-script tag

111 questions


1 answers
53 views
0
I want to change the format according to the day of the week.

This is my first time posting.A spreadsheet is creating a calendar with the following format:In line 3.4.5, we put together the functions so that changing the date of A4 changes.In the third line, the...

2 years ago

1 answers
63 views
0
How do I dial only colored cells in GAS?

There is a behavior that I used to do in Excel's VBA, but the spreadsheet has been changed and it has stopped working.I've never used GAS, and I don't know how to reproduce what I've done so far...It ...

2 years ago

2 answers
62 views
0
Obtain links from buttons on GAS spreadsheet

Would it be possible to get the link by creating a spreadsheet and pressing the Completion Button in it?I just started and there were many things I didn't understand, so I asked you a question.Sorry f...


1 answers
50 views
0
How to use Google Apps Script to display the number of files in a Google drive

was insufficient.As shown in the image above, I would like to use GAS to reflect the number of files in Google Drive corresponding to each item in the spreadsheet in the Number of Cases column. How ca...

2 years ago

1 answers
52 views
0
Non-Google accounts are no longer able to execute scripts

I tried to protect cells in the spreadsheet with Google apps Script, and when I ran the script below, it didn't enter my Google account, and when I ran the script, I got the following error.Script XXX...

2 years ago

2 answers
52 views
0
I want to get Amazon reviews on GAS

Both JS and GAS are super beginners.I would like to realize the function of getting the number of Amazon product reviews on a regular basis and sending emails if there is a change in the number of rev...

2 years ago

1 answers
59 views
0
GAS Execution API Error ScScript function not found: test 」

Google Apps Script Execution API allows JavaScript to call GAS functions.Authentication is complete, but when I try to do it, I get an error message ScScript function not found: test とThere is a funct...


1 answers
77 views
0
How to put values in html into variables with code .gs

I created a select box in index.html that I created in Google Apps Script.When I select a county name, I want to put that value in a variable in code .gs, but I don't know how to get it and how to use...


1 answers
77 views
0
GoogleAppsScript cannot be placed as an admin in a spreadsheet

[Current situation] If you select GoogleAppsScript as Published -- > Place as Admin -- > Update Webstore Item Draft, you will also receive an error.It should be set up as shown in the attachment...


1 answers
57 views
0
Read data from spreadsheet

I want to utilize the spreadsheet as a DB.I would like to search by putting a value in index.html's [selectindex] and display the results in [text1], [text2], but it doesn't work as well as I want.I w...

« - 4 - »

© 2024 OneMinuteCode. All rights reserved.