Syncing gsheet between two applications.
I have two apps hitting the same gsheet workbook.
One, is called the ‘Volunteer’ app, and is used to assist volunteers at an event to gather information from event participants at the show.
The other app is the ‘Director’ app, and includes charts that show different metrics about the participants that are being signed up by the Volunteers.
The problem comes in, when the ‘Director’ app is only pulling the last iteration of the gsheet made in the ‘Director’ app, and not the very last iteration posted to the same workbook and sheet in Volunteer app.
How can I make the ‘Director’ app always pull the latest existing iteration in the workbook?