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?
What you mean by โlast iterationโ?
Open a gsheet associated with an app. From the drop down, locate the option to view revision history. Every time a change is made to the workbook, it saves a new version (iteration) of the workbook. So if you have two applications hitting the same workbook, the appโs will point to the last workbook version saved in that respective app, (and not the latest available).
I donโt get the point. If two apps are using the same gSheet and you sync them, both will have the latest data. I donโt understand why are you thinking the gSheetโs version history.
@Aleksi_Alkio Iโm more than happy to demonstrate the problem to you, when I have time to take some screenshots.
The problem is rhat the apps donโt automatically point to the latest iteration of the sheet. It points to the last saved iteration known to the app.
Volunteer app points to gsheet.rev4.
Director app points to gsheet.rev2 (so doesnt show the changes made I, rev 3 and rev 4. Csnt state this anymore plainly than this!
It sounds that you are not using the same gSheet as a backendโฆ and you donโt have any user settingsโฆ sliceโฆ or security filters?
@Kim_Coffman Hi Kim, could you clarify what you mean by โgsheet iterationโ? Also, what does the extension โ.rev2โ or โ.rev4โ mean?
Hello @Kim_Coffman According to my understanding, I guess what you need is enable the โSync on Startโ option for Director app.
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |