topic Re: Automate Work Order Numbers in ArcGIS Survey123 Questions

Automate Work Order Numbers

ThomasGoodridge — Tue, 18 Jun 2024 12:21:06 GMT

I'm trying to auto generate work order numbers. The work order id should be the current year dash submission number padded with zeros. So the submissions should look like 2024-0001. The closest I got was concat(format-date(now(), '%Y'),'-',count(${location})), which doesn't actually count survey submissions.

Re: Automate Work Order Numbers

abureaux — Tue, 18 Jun 2024 17:11:18 GMT

There is a blog post that covers this: Creating 'Ticket Numbers' in Survey123 for ArcGIS

you probably are looking for ObjectID, which you don't get until after you submit. Have a look at the blog.

Re: Automate Work Order Numbers

ThomasGoodridge — Wed, 21 Aug 2024 14:59:14 GMT

I figured it out! You have to create a new survey based on the original one, delete everything that aren't the work order number (bind::esri:fieldType esriFieldTypeString) and objectid fields,(bind::esri:fieldType null) , and input this calculation into work order

if(string-length(${objectid})=1,concat(format-date(now(), '%Y'),"-000",${objectid}),if(string-length(${objectid})=2,concat(format-date(now(), '%Y'),"-00",${objectid}),if(string-length(${objectid})=3,concat(format-date(now(), '%Y'),"-0",${objectid}),${objectid})))