Help! Iโm new to AppSheet, and need to create an app to log passengers and cars boarding our island ferry. The crew will be filling out the form offline, then sync with the backend at the end of their shift. Our office will then be able to see ferry boardings etc. on the spreadsheet.
Now here is the problem: The crew needs to be able to work with a blank form at the start of each shift. On the backend, however, the office needs to keep track of all the data for recordkeeping. Syncing the app with the backend will grab and show all records on the app, which is bad; I want the app form to be blank at the start of each shift.
Is there a way to clear the form on the app, and prevent it from reloading all the records from the backend? I suspect that the answer is no, which will be a real bummerโฆ
thanks!
-Joseph
Maybe I can mark records as โSyncedโ after a sync and not display those records on the app? If so, what would be the best way to do that? Thank you!
โฆ maybe use a slice, where I exclude all records that have been synced? (slowly getting the hang of this?)
@Charlie_Wells yes, the slice or even a security filters would be the way to go here!
You can even make it to where the ferry operators can only see the forms they have uploaded that day, shift, etcโฆ
Thanks @Grant_Stead - Iโll give all that a try. As long as I know itโs doable Iโll figure it out (I hope!). And thanks too for the swift response!
Hi @Grant_Stead - sorry to bug you. It looks like thereโs a variable called โlastSyncTimeโ in the Audit Log Details Properties. I can just check the timestamp on the records synced into the backend and not display them if the timestamp on them is earlier (which it will be). Do you know if thereโs a way I can check that variable? Will all that date math slow things down? Typically each table (shift) will have about 20 records (small ferry!), times 10 shifts a day, and the office will periodically slurp the data out of the spreadsheet and into Excel every couple of days.
nah, you canโt access a lot of the meta informationโฆ You can build everything you need from what Iโm seeing,likeโฆ Really, your ferry guys donโt even need to see anything, they can do strict inputโฆ I would make a car button and a people buttonโฆ Tap tap tap while loading, then lock the gate records those quantities and woes the temporary tableโฆ Easy day
@Grant_Stead thanks! If only it were that easy. What youโre describing was exactly the form I had created using another form builder, but for a variety of legacy and operational reasons it wasnโt acceptable. The ability to display crew input in tabular form is a major part of the spec, and itโs the main reason I went with AppSheet. Iโll figure it out - I have some ideas already.
Thanks!
@Charlie_Wells good luck, I understand thatโฆ Bummer it is
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |