Sample ID

Question

Hi,

I would like to have a unique ID number for each report I make with survey123.

I know that there is an option to use the formula uuid() that returns a random UUID string, but it is too long for me.

Each report I send is written in a table and automatically have an objectID.  Maybe there is a way to show that ID in the form? or use it to calculate new Id?

Thanks,

Dikla.

IsmaelChivite · Answer

Added some ideas here: https://community.esri.com/groups/survey123/blog/2017/11/25/creating-ticket-numbers-in-survey123-for-arcgis

Jean-YvesLandry1 · Answer

Here's an idea to create a more manageable Unique ID:

1) Add the survey team number to the ID: T1, T2, T3

2) Use the Start_Survey value:  format-date(${start_survey},'%y%m%d')

3) Create a CSV which allocates a number to every 5 min, (I assumed a team would not take more than 5 minutes to complete a survey).

surveytimetimeid7:0017:0117:0217:0317:0417:0527:0627:0727:0827:092

4)Based on the start_survey time value i get a timeid value:

pulldata('time_id_survey','timeid','surveytime',format-date(${start_survey},'%H:%M'))

5) Concatenate and you'll get something like T1-171123-1

JamesTedrick · Answer

Hi, that is understandable, though a difficult problem to solve across all collection conditions.  The problem we have is creating an ID that we can guarantee is unique, even when multiple devices are possibly used by the same user (for example, if an inspector conducts a survey on one day with a tablet that later breaks and then received a new tablet with the survey loaded previously and is offline - how would we know the values needed to provide an ID that is unique?)  That being said, we are looking at what options we can support through Survey123.