# Offline data upload - Labels, Variables & Looping
**URL:** https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064
**Category:** Questions about Thunkable X
**Created:** [April 5, 2024, 2:58pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064 "2024-04-05T14:58:26Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)
#### Post date: [April 5, 2024, 2:58pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/1 "2024-04-05T14:58:26Z")
Hi all,
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?
The images of the page & blocks are seen below.
---
### Author:  [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)
#### Post date: [April 12, 2024, 3:02pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/2 "2024-04-12T15:02:31Z")
Hi @nuuzonessqnzvv, thanks for your patience.
Were you able to get this sorted?
---
### Author:  [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)
#### Post date: [April 12, 2024, 4:54pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/3 "2024-04-12T16:54:58Z")
Hi @matt_conroy
I have not been able to get this sorted yet. Are you able to provide any guidance?
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [April 12, 2024, 7:34pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/4 "2024-04-12T19:34:19Z")
Hello @nuuzonessqnzvv 👋
I think I understand the feature you are trying to build and another way to implement it 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:
---
### Author:  [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)
#### Post date: [April 12, 2024, 8:50pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/5 "2024-04-12T20:50:13Z")
Hi @ioannis
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?
Thank you
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [April 12, 2024, 8:58pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/6 "2024-04-12T20:58:45Z")
Hi @nuuzonessqnzvv
Unfortunately it is not possible to create multiple rows with data source block. You could use Web API block.
---
### Author:  [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)
#### Post date: [April 12, 2024, 9:26pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/7 "2024-04-12T21:26:15Z")
Evening @ioannis
Ahhh ok thank you for your help anyways 🙂
---
### Author:  [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)
#### Post date: [April 15, 2024, 7:40pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/8 "2024-04-15T19:40:24Z")
Hi @ioannis
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??
---
### Author:  [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)
#### Post date: [April 15, 2024, 9:42pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/9 "2024-04-15T21:42:05Z")
I’ve attempted to create variables for the first and last timestamp. Then create the elapsed timestamp variable and display it in a label.
In the ‘find first occurrence’ and ‘find last occurrence’, i’m not sure what to put in place of the ‘b’.
Any ideas?
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [April 15, 2024, 10:15pm UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/10 "2024-04-15T22:15:40Z")
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:
---
### Author:  [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)
#### Post date: [April 26, 2024, 8:29am UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/11 "2024-04-26T08:29:35Z")
Hi @tatiang
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.
How can i determine the elapsed time between the 1st and last timestamp?? I would like to have it also in the HH.MM.SS format.
Many thanks
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [July 25, 2024, 8:29am UTC](https://community.thunkable.com/t/offline-data-upload-labels-variables-looping/2931064/12 "2024-07-25T08:29:50Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.