Create primary key with Google Sheets

Hello!

I am new to Retool. The first stuff I did is to connect Google sheet's data to be used in my app.

Is there a way that I can create a primary key using Google sheet?

Hey @Peera!

Welcome to Retool happy to help here! Great question, after a little searching there seems to be a number of different methods to generate a unique ID for each column in a google sheet. If you're looking to do it from Google Sheets side this post seems to have some helpful solutions. If you are looking to generate unique Ids from within Retool you can use the function {{uuid.v4()}} to generate a UUID:\

Do you think this could work for your use case here?\

Thank you for your post. This helps me a lot.