I’m working on a scavenger hunt app. It requires offline data storage before uploading a google sheet as the hunt takes place in areas of poor service.
The data (name/number - variables & timestamp/QRdetails - labels) are saving correctly into the offline storage, as seen in the img below with the three times.
However, when I then try to upload this data to a google sheet it has no problem calling the name/number which are both variables but will not include the timestamp & QR details. This can be seen below.
It also uploads to Google one more set of data than recorded in the offline data. E.g. 3 tags scanned in 1st img, but when uploading it sends 4 tags. Why is this?
As making to many updates in a sort period can exceed the limit of google APIs, I suggest every time you upload a row to delete it from the local table so you don’t upload it again in the future:
That has worked a treat thank you. Is it possible to upload the whole of the offline table to the google sheet, instead of pressing finished for each entry in the offline table?
Is it possible to call the first and last entry from the offline db, to determine the elapsed time (last row timestamp - first row timestamp) with logic operation??
You don’t need to use the find first occurrence block because you’re not searching for a value. Just get the first list item and the last list item using this block:
The timestamps being pulled from the local db are in the HH.MM.SS format. I’m presuming these are being pulled in as text, so I tried to convert them to a number by x1. The value for elapsedtimestamp =NaN right now.
