I have a question that maybe someone can help me with.
I have various different tables; they are listed below. Main CapGown Obligations Prom
All of these tables are linked together on the Main table, by FullName column.
My question is, how would I go about making sure all the tables stay in sync?
In other words, if someone were to change a name in the Main table; what would be the best process to go about making sure the name changes in the other tables, so that all the tables stay in Sync?
Right now this is the major drawback I am having within my app.
I can’t figure out the best practice, to keep all tables in sync and connected.
I have tried doing things within the Google Sheet itself, but none of them work.
So now, if someone changes a name in the Main table, the other tables just lose the reference, and I have to manually go in and adjust them.
If I can automate this process, everything would be perfect.