Hi all, I have some unique ID columns in diff...

[Danny_Smith]

Hi all, I have some unique ID columns in different tables that are working just fine, my question however is.

I’ve a batch of data that I’d like to load into the sheet of the respective tables that was generated before I created my app.

Can I just import / copy my data into the tables and create a UID for the legacy data (and if so how), or what is your suggestion?

Thanks in advance

Danny

[Suvrutt_Gurjar]

Hi @Danny_Smith,

Do you have

Google sheets or MS Excel as back end database? You may wish to explore approach mentioned in the article below to assign the UID values to the legacy data copied in respective tables.

help.appsheet.com - Manually Generating UNIQUEID() Key Values Manually Generating UNIQUEID() Key Values help.appsheet.com

[Aleksi_Alkio]

If you are using UNIQUEID() for your column at this moment for new records, you can copy & paste the data. You can just add some unique text value like Text0001, Text0002 etc.

[Danny_Smith]

Thank you both