nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

generating a ticket number

dsinha

I used Survey123 Connect to prepare a form for residents to submit their complaints. For tracking purposes (both internal and for the public) I would like to automatically generate a number. Nothing complicated, - just the year followed by the next number in the sequence (e.g. 2025-1).

I am using the pulldata query described here. I have confirmed that the feature layer is editable and supports query. I just cannot get it to work!

What am I doing wrong?

Thanks!

Find more posts tagged with

Accepted answers

Neal_t_k

To add, you could make it a little prettier by formatting the date:

All comments

dsinha

@JordanHyche_MCI I used this in the calculation field for datetime so that it does not change to the most current date/time when opened/edited: once(now())

Neal_t_k

In that case instead of now() you could use a required user input date and pull that field into the calculation. That still would change upon user change but it won't change automatically upon reopen. You could also play with the calculation modes and see if any of those work to remedy that situation.

I wonder if you could also play with the "start" question type, I don't know if that recalculates on reopen or if it remains the original start date and time, but it could be worth a shot.

https://community.esri.com/t5/arcgis-survey123-questions/where-do-quot-start-quot-and-quot-end-quot-date/td-p/786531

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-calculation-modes/ba-p/1206967

the other option is uuid(), Those are kind of not pretty, though.

https://community.esri.com/t5/arcgis-survey123-questions/survey123-unique-id/td-p/815617

JordanHyche_MCI

I am so glad I came across this workflow because I have been trying to figure out this same problem the past few days.

However, have you had any issue with the "Ticket Number" changing and/or updating when the form is reopened or edited in the app and the web? Looks as though the ticket number updates to the most current date/time when opened/edited in both the app and through the Survey123 webpage. Hopefully there is a solution for the ticket number not to update when the form is edited.

JordanHyche_MCI

I am so glad I came across this workflow because I have been trying to figure out this same problem the past few days.

dsinha

Thank you so much @Neal_t_k. After having spent almost 3 days trying to calculate a ticket number using the method in the link, your suggestions are godsend.

I went with this format

Neal_t_k

To add, you could make it a little prettier by formatting the date:

Neal_t_k

Not sure what you are doing wrong, but can I suggest an alternative? There are issues with using that method for making a unique ID, namely if 2 people are submitting at the same time, it is possible they generate the same ID. The preferred method is to incorporate the now() function and concat what ever pre- or post-fix you want, it is not necessarily pretty but it avoids the issue of multiple "unique ids".

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.