google-apps-script tag

111 questions

1 answers
56 views
0

How to Display Thumbnails in Spreadsheet Cells

The code below will complete successfully, but the thumbnails will not be displayed. What's the problem?function dispThumbnail(){ varsheet=SpreadsheetApp.getActiveSheet(); varfile=DriveApp.getFilesByN...

google-apps-script

2 years ago

1 answers
53 views
0

How to Display Thumbnails in Spreadsheet Cells

google-apps-script

2 years ago

1 answers
101 views
0

Trigger fails when connecting to BigQuery and retrieving data from spreadsheet

I wrote the process of retrieving the data aggregated by BigQuery in GAS and outputting it to a spreadsheet.The following are the queries to retrieve:select * from(SELECT appid, count (userno) as cnt ...

google-apps-script google-bigquery

2 years ago

1 answers
118 views
0

Automatically enter a spreadsheet quote into another spreadsheet sales file with links, amounts, subject lines, etc.

This is my first time posting.I'd like to create a file for an E-quote with a spreadsheet and automatically enter the value of a particular cell in the file into a separate spreadsheet sales file.I wo...

google-apps-script google-spreadsheet

2 years ago

3 answers
152 views
0

Which GUI application is best suited for Google Cloud SQL?

Google Cloud Platform > Cloud SQL > MySQL 2nd Generation Instancehas been created.The DB in this instance has my Mac and Microsoft Access (no MacOS version) or LibreOffice Base (There is a Mac v...

mysql google-apps-script google-cloud google-app-engine libreoffice

2 years ago

1 answers
113 views
0

I want to fill the background color and character color separately in the conditional format of Google spreadsheet.

I would like to fill the background color and character color separately in the conditional format of the Google spreadsheet.Specifically, the settings like the attached image are

google-apps-script google-spreadsheet

2 years ago

1 answers
46 views
0

I'd like to sort emails that come to gmail into specific groups in the chat work according to the keywords in the body.

I wanted to distribute the email that came to gmail to the specified group of chat work according to the keywords in the body, so I created it as follows, but it will not be forwarded to chat work eve...

google-apps-script

2 years ago

1 answers
53 views
0

How do I view images in HTMLservice?

I wrote the following code, but I can't see the image. Why?The image is in Google Photo under My Drive.Code .gs side function getPic(idStr){ varfile=DriveApp.getFileById(idStr); varimTag='; imgTag+='...

google-apps-script

2 years ago

2 answers
63 views
0

I have implemented GAS in my Google document, but I cannot replace regular expressions.

The script below does not work as intended.I'm going to search for the sentence that starts with ★ and display it as it is, but I can't do this, so could you please let me know?For example, I would li...

regular-expression google-apps-script

2 years ago

1 answers
56 views
0

Learn how to read the Google form question choices from a spreadsheet (if you have separate sections)

I want to read the Google form question choices (pull-down expressions) from the spreadsheet, so I create them in the script editor as follows:The second question can be reflected, but the third quest...

google-apps-script

2 years ago

- 5 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656