A
A
Andrey Brand2015-02-13 14:13:17
Google Sheets
Andrey Brand, 2015-02-13 14:13:17

Is it possible to do in google spreadsheet db? Is there an importrange replacement?

Hello!
Tell me how to automate data entry in one table with intelligent output in another.
Example (folder) https://drive.google.com/folderview?id=0BztQoL_Dxw...
There are two files DB1 and Project1
Task: It is
necessary that when entering numbers, for example, in DB1 D2, they are automatically reflected in the file Project1 d2
B In the future, when entering data in the lower table of DB1 d9, they were displayed in Project1 d3
Manual control of the Importrange formula is not entirely suitable.
I will be glad to receive your answers.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2022-04-07
@andreybausov

This can only be done programmatically using the Google Sheets API.

A
Ayan Bai, 2015-02-27
@wolf47

I didn’t understand what you want, but if you want to have 1 source and make different tables (projects) based on it, then you just need to access the source from the script by id and arrange them in the desired form.
I can throw off an example, I do it myself and it's fine.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question