Z
Z
ztsush2020-04-27 21:36:19
Google Apps Script
ztsush, 2020-04-27 21:36:19

One google apps script for 2+ tables?

I want one script to be executed in several tables (ctrl+c, ctrl+v - already in use)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2020-04-28
@ProgrammerForever

Instead of the usual

var ss = SpreadsheetApp.getActiveSpreadsheet();  //Текущая таблица

use one of the options
var ss = SpreadsheetApp.openById(id); //открытие сторонней таблицы по id
//или
var ss = SpreadsheetApp.openByUrl(url);//открытие сторонней таблицы по url

And then work with ss as with a regular table

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question