Auto Generated Sequential Number

Question

I've built a custom Survey form thru Survey123 Connect and been using it for awhile now. After additional review(s), it was requested that an auto generated sequential number be added to the final form print (I have a power automate flow that takes the form and prints to PDF).

Not sure how, OR if this is possible to do?

If we start with lets say 2400, the next time the foreman starts a new form from this particular survey, the field will auto generate 2401, or at least the user will have to possible do an action for the field to populate.

Any advice on how I can make this happen? I dont have any idea how to write the code for it.

MarkWILSON_LLS · Answer

Hi there.

Im guessing you could do a pulldata query on the existing records in the hosted feature

Return Max(Sequential Number)

the trick is getting this pulldata query to refresh just as the form is submitted incase multiple field staff are creating forms at the same time.

Keep me posted if you get something to work

mw

rbd · Answer

I am also looking to be able to do this, but with the next available project number in year-xyz format. (I’m thinking the pull data function would be used, along with stripping and a math function.) So, for example someone submits a project intake form and the next available number for this year, 2024-141, would be assigned—but only if the form is submitted, and not hanging out there in the ethers as a draft. We don’t want a bunch of unused numbers if folks start a form and never submit it. Possible? I sure hope so!

ModernElectric · Answer

@ZacharySutherby @NateLickteig_KendallCoTX @IsmaelChivite @MJBiazar

Was thinking, could I use the ObjectID of the feature/form within the Hosted Feature Layer as the unique identifier? Its known this number is auto-generated and unique to each feature and layer. If this is possible, how would I pull this number into the form? I am not sure when the actual feature is created in the feature layer on AGOL when a form is created.

Edit: I understand the ObjectID is created AFTER the Survey Form is submitted so it would not show up in the Survey Form for the viewer. However, I have a Power Automate flow created the takes the data, and creates a PDF print. Is there a syntax available to use the Object ID and print it to the PDF form?

Progress Update: I was able to find away (in-case someone else reading this can benefit from it) to incorporate the feature's Object ID into the final report. I used Power Automate to take the Object ID, and include it as part of the printed PDF report name. Also, was able to use the generic syntax to print the Object ID to the report template.