google-apps-script tag

111 questions


1 answers
402 views
0
Search Twitter v2 Quote Retweet

Purpose: I'd like to get all the quotes/retweets on my tweets and the identity of the tweets from which they were quoted after the specified date and time within one week on Twitter V2.Do not specify ...


1 answers
484 views
0
How GAS Determines if a Hyperlink is Configured for a Specific Cell Value in a Spreadsheet

For example, there is data that contains a string in column A.If the link is set halfway as shown in the image, I would like to set up a script to set up hyperlinks only for strings with no links.I've...


1 answers
312 views
0
I would like to replace the GAS code with the SpreadSheet cell formula IMPORTRANGE and paste it as a value.

As stated in the title, if the data is not very wide, the code below will work.If the A1 cell contains an IMPORTRANGE formula, By taking the value of all cells from there and setting it to A1 cells be...


1 answers
459 views
0
Want to Automate Chat Log Collection

Chat log collection is performed with administrator authority, exported, and reported to senior managers.I would like to automate this and report it regularly.Is there any way?Workspace's standard fun...

1 years ago

1 answers
418 views
0
Want to Automate Chat Log Collection

Chat log collection is performed with administrator authority, exported, and reported to senior managers.I would like to automate this and report it regularly.Is there any way?Workspace's standard fun...

1 years ago

0 answers
433 views
0
Unknown cause error "Exception: Form data could not be retrieved during Google form submission.Please try again in a few moments."

We are currently using Google form submission as a trigger to run a function of gas.I usually use it without any problems, but recently there have been about three triggers, and I don't know the cause...

1 years ago

1 answers
455 views
0
Processing of for statements in a program that converts a one-dimensional array into a two-dimensional array

I found an example of a program online that stores array_1 one-dimensional arrays as two-dimensional arrays in array_2.Source: Convert a one-dimensional array to a two-dimensional arrayRegarding the f...


1 answers
318 views
0
Browse spreadsheets in the GAS and retrieve specific lines

GAS is trying to retrieve a specific column of the spreadsheet.A particular column is the data in the row where num is the maximum value in the table below.From this table, what code should I write to...

1 years ago

1 answers
308 views
0
How to Pass a Two-Dimensional Array to Vue3

I am creating a test app with Vue3 in Google Apps Script.I've tried many things with client-side Javascript, but I can't turn it around with v-for, whether the two-dimensional array is Object type?How...


1 answers
424 views
0
I want to automatically assign the username of the executor in GAS

I would like you to automatically enter the person who executed this script in the vertxt='; section. What should I do from here?We have removed some of the var url parts for confidentiality.function ...

1 years ago
- 1 - »

© 2024 OneMinuteCode. All rights reserved.