Questions tagged [Google Apps Script] (52)

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...

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...

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...

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?

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...

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,...

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...

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...

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

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...