Timeline for Sync Google Sheet to multiple other sheets
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 2, 2022 at 11:11 | comment | added | Tedinoz | FWIW, one thing that you will have to do is loop through your list of data sheets and do stuff in each of them. So, you might start your own code development with how to "get" that list of sheet names from the "Dates" sheet; how to use the list to progressively work through each sheet ("loop through the sheets");do something in each sheet (such as, say, get the value in Cell "A1" and display the result to screen). | |
| Jul 2, 2022 at 11:07 | comment | added | Tedinoz | Very sensible. Bear in mind, volunteers don't know the structure of your template or data sheets, nor the nature of any template changes and the effect on existing sheets; and, presumably, it would be unacceptable to over-write any existing data. Having said that, how's this for a what-if idea: take an existing data sheet, copy the data on the sheet, "copy/paste" the revised template to the sheet, copy existing data back into the sheet. If you could do that manually, then it could be done by a script. | |
| Jul 1, 2022 at 14:21 | comment | added | DennisAlexander | Hey Tedinoz, Thank your for responding. I did not see that previous question you are referring to as I had posted this question elsewhere and then had it moved by an admin to this site. I am not an "app script developer" and currently what I pieced together works but I wanted to jump ahead of the curve and set it up for future changes. | |
| Jun 30, 2022 at 13:52 | comment | added | Tedinoz | Hi. I recall another question asked in the last few weeks that bears a close similarity to this question. Did you see that earlier question? There's no "automatic" linage, but depending on the nature of the changes), one would think that it would be possible to write a script that would add the changes to all the sheets. If you are not currently an "app script developer", you would need to develop those skills in order to create that script, OR (and this is more sensible) you would contract someone to write it for you. | |
| Jun 28, 2022 at 19:17 | history | migrated | from superuser.com (revisions) | ||
| Jun 28, 2022 at 19:12 | history | asked | DennisAlexander | CC BY-SA 4.0 |