Questions tagged [Google Apps Script] (52)

1
answer

How to compare dates in different cells using a script?

The following is a working piece of script: while (i<=1500&&s.getRange(i, col1).setNumberFormat("0.000").getValue()===s.getRange(i+1, col1).setNumberFormat("0.000").getValue()&& s.getRange(i+1, col1).isBlank()===false) { s.getRange(i, col1).setNumberFormat("dd.mm.yyyy"); i++; count++; } Its task is to...
birdie.Schaden asked April 18th 20 at 12:33
2
answers

How to make autocomplete script?

There is a table consisting of a fixed number of columns, number of rows is constantly changing (say columns A,B,C,D). If in column a I manually add information to a new line (thereby expand the table), columns B and D in the same row should be filled in by the script (these columns are formulas, so they need to convey exac...
jarrod56 asked April 16th 20 at 11:18
2
answers

Why can't I log-in script editor in Google Sheets in Chrome?

For several months I can't log in script editor in any table to a Google Spreadsheet from your Chrome browser. All extensions are disabled in the browser, the latest version, the browser repeatedly perestanavlivaya. At the entrance there is always this message : In another browser (Yandex or Edge all opens and works). W...
Vicent asked April 16th 20 at 10:38
1
answer

How to edit multiple sheets?

There is a book, it has 10 sheets. Overall these sheets - design of the month (dates, weekend working), the rest of the data is different. I would like to understand how, when you edit the first sheet, the design is automatically changed in the other? Can it be done using Google Apps Script?
kaycee asked April 9th 20 at 10:32
1
answer

Are there any tools to create the items in the list in the drop-down list in Google sheets?

The challenge is to tie to an existing table something like the reservation system with feedback. In the screenshot, the structure of an existing table. The problem is that in cell D3, different users need to put their armor, and the number of pieces in this position. In cell E3 is the checkbox that people working with ord...
vincent asked April 9th 20 at 10:05
1
answer

How to query multiple Gmail accounts mail from one GAS script?

Good time of day. The task is to collect data from emails from multiple mailboxes in a single Google spreadsheet. I see two options: 1) For each account with a mail script with the start trigger, which parses the mailbox, and writes in a common table (access the link on the edit). 2) the Correct script in the General table,...
keely.Collins asked April 8th 20 at 17:36
1
answer

Google Apps Script Jdbc.getConnection how to connect to MySQL?

Good day, need advice from a practitioner who really works with the connection string. function Test(){ var connectionName = 'remotemysql.com'; var user = 'xaqfnhqzgE'; var userPwd = 'o8uJU5UeIH'; var db = 'xaqfnhqzgE'; var dbUrl = 'jdbc:mysql://'+connectionName+'/'+db; var conn = Jdbc.getConnection(dbUrl, user, userP...
madelynn55 asked April 8th 20 at 02:47
1
answer

How to pass arguments to the function called from the menu?

Good afternoon. There is a task to make menu items which are loaded from the table. When a static menu do this: function onOpen() { //Executed when the opening SpreadsheetApp .getUi() .createMenu('Menu') .addItem('FUNCTION1','function1') .addItem('function2 are','function2') .addToUi(); }; How can I pass a function any pa...
eda_Hauck asked April 8th 20 at 02:41
1
answer

Is it possible to catch the event send a Google form in an iframe on the client?

The form is embedded on a website via iframe, you need to show a custom status of success after sending. And is it possible to get the user's email filled in the form, to send to the backend? Provided that the option is "collect email address" enabled
barbara.Berge66 asked April 8th 20 at 02:25
0
answer

How to send a letter on the condition of the cells of a particular column?

Hello tell me, but Tokaj in General really do? There is a column "M:M" in each cell, the formula does the calculation, and when any cell is "Sending", then you need to copy the cell "S" and send for one and the same mail with the subject "employee". For example in cell "M1201" formula calculated "Send", it should copy the c...
Zaria.Deckow35 asked April 8th 20 at 02:10