Select to view content in your preferred language

Prevent Unique ID from Updating When Editing?

70
1
yesterday
DaveK
by
Frequent Contributor

Hello, 

I have a survey being developed in Survey123 Connect that contains a unique ID. The uniqueID field contains 3 digits that are randomly generated. I have this survey embedded within a Dashboard for users to edit, but when editing the uniqueID number changes. Is there a way to keep the original number from when the survey was first submitted? 

Thanks. 

0 Kudos
1 Reply
Neal_t_k
Frequent Contributor

Have you tried the once() function when calculating the uniqueID

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

Also keep in mind that that chances are pretty high of getting a duplicate uniqueID using that method.

You can generate a uuid() field, or if you want something a little prettier, consider incorporating datetime into the uniqueID.

https://community.esri.com/t5/arcgis-survey123-questions/generating-a-ticket-number/m-p/1620621

0 Kudos