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!

[Neal-Kittelson]

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".  

[Neal-Kittelson · Accepted solution]

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

[dsinha]

Thank you so much @Neal-Kittelson. 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