Hello I have data for my app in excel files. ...

(עמי רצין) #1

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?

(Aleksi Alkio) #2

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.