I built two separate spreadsheets in Google Drive and spreadsheet "A" has a script that when run, will copy the input data into spreadsheet "B". When I test it, it works perfectly. But I have other users that only have access to spreadsheet "A". When they run the script it doesn't work because they don't have permission to spreadsheet "B", but I don't want to give them the historical data that's saved in spreadsheet "B".
The error message is:
Document ID is missing (perhaps it was deleted?)
How do I get through this?
I made a Demo copy that can be accessed: demo copy