I’m quite new to thunkable and am looking for advice.
I’m working on a project that would allow a user to record traffic data on a roadway by observation. Whenever a vehicle passes, the user would press the corresponding button (depending what direction the vehicle is travelling), which would record a timestamp in a database. I want to note that the user would record data while offline.
Now the goal is to export the database of timestamps into a spreadsheet (preferably excel, csv, or google sheets) when the traffic observation session is finished. Is there a way to record the timestamps in Local DB and then export those results to a spreadsheet after? Or maybe record the results in google sheets while offline and sync the data when online? I know it’s possible to store the data on google sheets or firebase while online, however, the user would be clicking buttons very frequently for at least a 2 hour period (some sessions could last up to 8 hours of recording traffic), so I feel this method would drain the battery quickly and require the user to have a mobile data plan. Could it be possible to record the timestamps in a list and retrieve that list somewhere in the phone app files?
Any thoughts/ideas would be greatly appreciated and of great help.