This article explains the reasons why you are getting the “ScriptError: Document is missing” error message when running the Advanced Summary add-on.
ScriptError: ... perhaps it was deleted
The error above is triggered when your Awesome Table's linked Google Sheets datasource:
- Was deleted or
- You are running the Advanced Summary add-on that references a datasource that is owned by someone else and you don’t have read-access to the file.
To remedy this, make sure that:
- The pertinent Google Sheets datasource is not deleted.
- If it's not deleted, unlink the form, then relink to a spreadsheet datasource. More about these procedures from Google Support's help.
Then update the Google Sheets datasource with the new tab (sheet) name in the AwesomeTable editor by following steps 3 - 4 of this tutorial.