Determine the primary key

[zakri_sultan]

hi
I have data in Google Sheet and I want to store it in tinydb and put the primary key into a specific column data

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

Have you tried anything so for?

[zakri_sultan]

I can import data from Google Sheet and store it in tinydb, but the problem with that is when storing it. I want to specify the data of a particular column as the primary key so that I can search for row information

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

If you want to store it in a specific cell you need to get row number first (use index is in the list block after getting value from gsheet to app during screen init or button click). With the help of row number you can easily store in the google sheet again.

If you show model of your gsheet and so for how did try. we can able to suggest you more…