Selectively syncing edits between parent and child Google Sheets (Overview) скачать в хорошем качестве

Selectively syncing edits between parent and child Google Sheets (Overview)

SEE MY TEMPLATES AT http://www.jpmueller.com Have you ever needed members of your organization update data that feeds from and to a overall parent sheet and the IMPORTRANGE function and cell linking doesn't make the cut because different members are breaking the parent sheet by manipulating their own child spreadsheets in unexpected and undesired ways? This solution uses a combination of permissions, scripting and triggers to take a form submission, populate a parent spreadsheet, push the submitted data to the appropriate child spreadsheets and then let the members of the organization manage their data in their child spreadsheets and only push the updates that I, the admin, will allow back to the parent sheet. Further, it still allows the managers to add their own data column to their child spreadsheets without fear of breaking the overall parent sheet. I discuss The scenario The different users for the form and various sheets Editable fields Protecting sheets Generating a unique ID for each submission Making the formulas and script resilient Editing fields in the child spreadsheets and seeing them update the parent Controlling which fields are allowed to be edited Inserting new columns in the child spreadsheet without hurting the parent The code and triggers