How to sync offline data?

Discuss
#1

I have a form with 10 question.
I will collect data from 20 people.
I plan to sent the data to airtable (or any other backend db)
but i will do all data entry in the absence of internet
is there a way to have the app store 20 forms off line and get it synced when it back online?

#2

not possible with airtable

#3

use tinydb

#4

You can use firebase DB component which helps you to store data when app connect to Internet.

#5

he want to store data offline

#6

He wants to synced data when user online.

#7

but its not possible when internet is turned off

#8

He has to add questions in label text. He can store user entry when internet connect with firebase DB component.

#9

In this case you might want to use background task extension, so you can synced data and send to your database once the app detected an internet connection.

#10

U can store data in
*Tiny db
*Dictionary
*Sql lite
And use web component to check whether the user is connected to internet
If true then call your data and save it in respected columns in your database

Its not a difficult task just require some logics and u will be done

2 Likes
#11

Hmmm… How?

#12

take a look at

https://community.kodular.io/t/simple-use-of-dictionary-and-tinydb/66132

1 Like
#13

:joy::joy: I just get it from your guidse… As previously i didn’t use dictionaries :joy: and from your templates i get to know its method of storing data is very simmlar to sql lite

1 Like
#14

That’s actually my own guide :joy: I thought @Zia_Choudhary said only using the dictionary

1 Like
#15

:joy: :sweat_smile:

1 Like
#16

@WatermelonIce
I can do it but I don’t have the time :pensive:

#17

Instead of Airtable, you can integrate Google Forms to Google Sheets. If user is offline, save the url in a list in TinyDB when submit button is pressed, then create a procedure to send those to Google Sheet when it’s back online.

#18

is there any way we can sync sqlite database with mysql?

#19

Please elaborate it more what actually u want to do
?

1 Like
#20

You have to organize your idea … :+1:t2:

When do you want to activate data exchange between databases ? Check for duplicity … Insert online database… Clean the local database ?

1 Like