topic Build a unique ID using now()? in ArcGIS Survey123 Questions

Build a unique ID using now()?

EdApalinski — Thu, 10 May 2018 19:39:46 GMT

Hi,

I would like to build an ID number based on the date and time as shown below:

YYYYMMDDHrHrMnMn

Y=Year, M=Month, D=Day, Hr=Hour, Mn=Min

I am trying the now() function in the calculation column where I get a number reported as a value (see image) which . Does anyone know how to interpret this value so I can convert it to my format?

Or does anyone know another way to create such an ID in the xls form?

Thanks for any help and or ideas!

Re: Build a unique ID using now()?

JamesTedrick — Thu, 10 May 2018 20:20:40 GMT

Hi Edward,

Date and time are internally stored as 'epoch time' - the number of milliseconds from 1 Jan. 1970. To create a human-readable time, you need to use the format-date() function - look for the 'Date Formatting' section in Formulas—Survey123 for ArcGIS | ArcGIS . Also, Dates and Time in Survey123 for ArcGIS and Creating 'Ticket Numbers' in Survey123 for ArcGIS may be helpful blog articles.

Re: Build a unique ID using now()?

EdApalinski — Fri, 11 May 2018 15:35:03 GMT

James,

Thanks! found exactly what I needed in the Creating Ticket Numbers blog. If anyone else is interested I used: format-date(now(), '%y%m%d%H%M%S') in the calculation field to get the auto-populated ID.

Cheers!

Re: Build a unique ID using now()?

AnkiGuna — Fri, 03 Mar 2023 20:26:32 GMT

This is working fine when I create survey 1st time. But I want to keep that same unique id during edit also. And if user is performing copy action at that time this unique id needs to be regenerated. Would you please guide me how can I achieve this requirement?