As discussed in the Montly GDE App Hangout of 20150310:
To ease the edit of the impact on activities, build a Google Sheet with the following features:
AutoUpdating sheet with the activities of the last X Month/s (a month, a quarter?)
Update data from the backend OnOpen to avoid too many calls to the backend
Data pulled from the API are for that GDE only
Should be possible to authenticate calls from GAS to the API with the current user
Automatically push updates/New activities after validation
Check if the minimum required values are present before pushing any update
Add a "Status" column to show if the row is Synced/Missing Data/Error Sync, etc...
Some things to consider that I don't have a clear idea how to implement:
Support for activities with multiple activity_metadata:
By adding different set of columns for each activity based on the number of activity_metadata?
maybe using different background columns to highlight the group
Activity Creation, should we support it from the Spreadsheet or only Edit?
The Main problem is that we might end up trying to create a new activity if the user copy and paste the same activity into a different row or delete the id column (that would be in an hidden column... but happens)
As discussed in the Montly GDE App Hangout of 20150310: To ease the edit of the impact on activities, build a Google Sheet with the following features: