How to save daily data in a local storage ? And how to make the app recognize its same day and don't overwrite it?

[acrh2025wtbqik]

Hi!
I’m currently developing an App where users must give their rating on health questions, example stress levels. So I want them to check-in their rating everyday and that to be stored in a local data storage in Thunkable.

I manage to make a data storage and it’s 7 questions (made as column) and the row (should be days). I tried to make the app create new row in data storage for every new day and the rating for that day saves according to the row number.

Example:
User X start using the App 15 April 2025 (Row 1), 16 April (App create new row, now data is written from Rating tool to Row 2), 17 April (App create new row, now data is written from Rating tool to Row 3) and so its going…

I will also have a statistic page where the user should could compare the results over time and between 2 dates.

I appreciate if someone could help me figure out how to figure this out!

Best Regards Ali

[Goldking]

Hi,
probably you have to create your template with layout ,contanier and label to move data from your database to tamplate to see all the data you want .
Or you can use the component Data Viewer to show data if you can use list layout

[Goldking]

But did you manage to create the database ? Show your relevant block about save and retrive data

[acrh2025wtbqik]

Hi thanks for your answer. But I really don’t get it how to fix it.
Here I upload how rating is saved to databas, and the databas structure.

[Goldking]

Hi, first of all I suggest you watch tutorial about component that you can find in the docs, very helpful.

This is one way to optimize your blocks

Also for create

This can be one way to show data in your app

But there are a lot of way , you have to find the best for you. You can use a single label like in the pic, you can use a list view, you can create a form where show data and so on

[acrh2025wtbqik]

Hi! Thanks a lot for your answers, Appericiate it!

But I wonder how to manage that the app recognise it’s a new day and automatically create a new row in table and allows the answers for that day to go to the new row? So it also doesn’t mess upp yesterday’s values in the table?

[Goldking]

Hi, now I don’t remember if there is another way to catch the date but you can use this core block to make date and save to database.
Here

When the app starts you have to get the last row and verify if date value is equal to the current day or not