script to copy and move data to update tables in a google sheet

4 views
Skip to first unread message

Vampy Vampy

unread,
Feb 3, 2026, 5:48:10 AM (yesterday) Feb 3
to Google Apps Script Community
i have this set of sheets - 

the sheets are used to collate data from my online game. 
the sheet called "test data INPUT form" includes buttons that use scripts to add data to the sheet named "test data lists" which then adds data to the sheet named "test tables 2" 

clicking the add new character button on the input form adds the new character info to the data lists sheet which then also adds the name of the new character to each and every table found in the "test tables 2" page, however the table creation script only allows for the addition of the new character name and keeping a blank cell after the newest added character in its header (character name) row to keep a space between each table, what it does not do is also keep a full blank column between the tables so when a new character is added the data below it does not move which means that after each new character is added the collated data becomes incorrect. 

i need to know if anyone can think of a way to make sure that the data in the tables also moves along with the addition of a new character name so that all collated data remains true and correct. 
Reply all
Reply to author
Forward
0 new messages