My case bellow could be a small question or a big issue:
- I add a Company via a form and such data is stored in GS sheet=Companies
- Within Company’s record (once created of course), I have another form to “Add Contact” to add contacts associated with Companies - and such data will be stored in GS Sheet=Contacts
- The “Add Contact” form automatically takes Company name and fill Column=Comapny in the Contact tab.
If I change company name (from App), this change doesn’t automatically get updated in the Contact tab!!!
This is one example out of many other dependencies in the App, such as:
Customer >> Agreement >> Invoice >> Payment
Supplier >> Purchase Order >> Bill >> Payment
And so on…
And I hope the answer won’t be "Use google script to do global tagging, find & replace )