Bob work in a company which uses spreadsheet to collect responses from users through a form. Bob gets thousands of submission daily, over a weeks time, the spreadsheet becomes huge causing the performance issues while viewing or editing, So he need to copy the whole data from submission sheet to a new spreadsheet and clear the original sheet evreyday or everyweek.
Solution:
This work can be automated by writing an script which runs daily or weekly (by adding it to triggers).
This script Copies the whole data from Submission sheet, creates a new Spreadsheet and put all the data in newly created sheet.
After that, it clears the original sheet.
Here is the example script.
function 'executeIt()' is added to trigger to run daily or weekly.
|
Case Studies >