How to load google sheet data in screen 1 for screen 2?

[sanatmalani]

I have my main screen on screen 2 and screen 1 is used as a splash screen.
In screen 2 I load data from google sheets

It takes 2-3 seconds to load data from google sheets. So the screen is blank for that time, is there a way to fix this?

Is there a way to load data from google sheets in screen 1 itself or something such that.

I don’t use the inbuilt splash feature because it is not responsive to screen size and so the same image used, looks shabby in different devices with different screen sizes, and so I have screen 1 dedicated for splash.

Do you have any solution to this?

Many use google sheets to load data but their app does not 2-3 seconds, it is almost real times.

The reason I am not using CSV file is because I am expecting change in data, so I prefer to use google sheet over static CSV files.

Thank you for stopping by and considering the question.

Your response and participation is much appreciated.

[Still-learning (1-2-3-4...)]

No issue. Easily can do it… just add the screen2 init blocks into screen1 inti blocks and when web got text store it in a tinydb and then pass the value into next screen.

[Jinx]

You can simply show a circular progress and I when sheet loads then set circular progress visible to false

[sanatmalani]

Hi can you give me an example of:
How to store data in tiny db and move it to screen 2.

I havent used tiny DB before

Your help is much appreciated.

Thank you.

[Still-learning (1-2-3-4...)]

In screen1

In screen2
complete it with required block

[sanatmalani]

How to transfer the value stored from one screen to another?

[Anu10 (Anu)]

@sanatmalani

transfer the value

When you store any value in TinyDB you can get it in any screen via TinyDB GetValue Block

Refer this post

https://docs.kodular.io/components/storage/tiny-db/

[sanatmalani]

I am not able to figure out, how to use this block in screen 2?

[Anu10 (Anu)]

Example :-

Read TinyDB documentation to know more about it

https://docs.kodular.io/components/storage/tiny-db/

Here are some guides

How to save Image with the help of TinyDB?

I was searching for many ways to save the image in TinyDB, so that we can show image later in our app. Well, it is not possible to save the image in TinyDB as TinyDB only saves strings and integers but I found a way which will work for you. We use images in two ways in our app: i) Image from assets. ii) Image from internal storage which is available in our mobile. While image from assets are easy to save in tiny db, as we can just store name of file loaded in the asset. See the blocks…

Simple use of dictionary and TinyDB

Introduction Have you ever use tinyDB or other databases to store value? When there are so many data you have to store, you won’t want to store it with so many call tinyDB store block. Therefore, the dictionary can be used to help. What is a dictionary? Dictionary is a built-in component. Generally speaking, a dictionary uses a key to call and get the value. For example, It will return the string "whatever". [blocks (2)] How to use it? As mentioned, a dictionary uses a key to call and…

[sanatmalani]

It worked but screen 1 load time increased from 2.5 seconds to 4.5 seconds.

Any idea how to reduce this?

Thanks in advance.

[Still-learning (1-2-3-4...)]

It is totally depends upon website you use and the response obtained from it. You cannot change it always it song be ligtning fast

[sanatmalani]

I am using google sheets

[Still-learning (1-2-3-4...)]

It will fluctuate. But don’t worry. Sometime it will give you sooner. Just go on .
But if you create multiple lists with the help of gsheet , then certainly it will take such time

[sanatmalani]

It is one sheet with 210 rows and 4 columns

[Francisco_Toro]

Greetings, instead of making a splash on screen1 and then opening screen2, I recommend that you use a single screen…
that is, load the splash with a clock and after I don’t know 3 seconds you hide it and show the information that instead of being in screen2 it would be on the same screen inside an invisible block, and with the tools you put the first one invisible and the second visible and you don’t have to use screen2, and with that you solve loading problems.