hi all, Here's my usecase with the data and visibility Components:
Data capture is done using:- Google forms.
DataSource/ database :- Google sheets
Data Visibiliity: Appsheet
Usecase: I have users interacting with the app in real time for visibility, i.e users submit data using google forms and eventually ending in google sheets in real time and the appsheet app is accessed by the users to see what data is entered. (all the action happens in peak hours approximating for 45min to 1 hour every day.)
what is the best Configuration to get latest data into the appsheet without users manually Syncing every time when the data is inserted into google sheets, (i.e currently the user has to keep pressing the sync button.)
i saw some posts which are posted earlier from my search:
1)QUick sync feature doesnt work as my google sheet data is being entered by non-appsheet system (i.e - google forms) and i have google formulas
https://www.googlecloudcommunity.com/gc/Announcements/PREVIEW-Users-see-updated-data-with-Quick-sync...
2)Another recommended answer from 2020, is to create linkaction to force the sync using
LINKTOVIEW("ViewName")&"&at="&(NOW()+1).
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Sync-Action/m-p/345051
But in my use case i have bulk updates that are made by user in appsheet updating cells in the google sheet. which takes time. like 5-10 seconds. is there a way to execute the last linktoview action after all the updates are done.
(note: The whole idea for me to start the appsheet app project is by getting impressed at the home page display of the graphics (.gif) image where the appsheet automatically syncs up from the google sheet update.) - probably i shall have asked this question first and read the limitations to get the desired end state on what i was building.
Google AppSheet | Build apps with no code
any advice is highly appreciated. Hoping the product maturity since since the last post from 2020 there is an answer for my use case in 2023.
LinkedIn
Twitter
