Hello I have data for my app in excel files. I want to copy it to my app as a bulk and also use the UniqueId function to generate the id for all that data so when i use the app to create new data there won’t be a duplicate id for each data row. Can the app generate unique id for data already in my google sheet?
I’m afraid you need to generate them manually because you have to do that when creating your record, not when updating. Because it’s a text field, you can use for example a value Key001 and then drag it down so the result would be Key002, Key003 etc.