topic Re: How to get gdb sequence from feature service based survey123 back into the survey results. in ArcGIS Survey123 Questions

How to get gdb sequence from feature service based survey123 back into the survey results.

Amarz — Wed, 13 Nov 2024 15:57:25 GMT

I have a Survey123 survey created through S123 Connect, that is based off a feature service. The Feature Service has a geodatabase sequence to create an ID for each new survey.

I am attempting to either create that sequence within the survey, or to pull the data after its created back into the survey so I can create a Report to email out.

Any advice would be greatly appreciated.

Re: How to get gdb sequence from feature service based survey123 back into the survey results.

abureaux — Wed, 13 Nov 2024 16:23:03 GMT

A little more context may help.

How are you creating these reports? If this is a standard Feature Report, then you need objectId, which S123 will pass along to the reporting engine naturally via whatever reporting engine you go with (e.g., Power Apps or Make).

At what point does the custom ID get generated? If your custom ID field only gets populated after a survey is submitted, then you will need to write data to the datastore, generate that ID, and then send an email, which is doable, but a more complicated process.

Re: How to get gdb sequence from feature service based survey123 back into the survey results.

Amarz — Wed, 13 Nov 2024 17:22:21 GMT

The reports I am referring to are the ones that can be generated via the Survey123 online feature reports. The custom ID is currently being generated once the survey is submitted and the new feature is created. I would be happy to create the custom ID within the Survey is possible. I couldn't find enough documentation on how to do so within S123 Connect.

Re: How to get gdb sequence from feature service based survey123 back into the survey results.

abureaux — Wed, 13 Nov 2024 18:07:02 GMT

Custom IDs are tricky. Depending on what you want, it may or may not be possible within the app...

Do you just want something unique that a human won't need to remember? Then use a uuid field.
Do you want something a human can use, like 0001? Then your options are more limited.
Just using the ObjectId field generated by submitting a survey may also be sufficient.

This blog has a lot of good info, and is likely what you are looking for: Creating 'Ticket Numbers' in Survey123 for ArcGIS

As for generating reports, you don't need your custom Id field for that. Reports use ObjectId.

Re: How to get gdb sequence from feature service based survey123 back into the survey results.

Amarz — Wed, 13 Nov 2024 19:25:48 GMT

Gotcha, I did see that, but I really wanted an incremental ID.. looks like that's near impossible.

I think for sake of just getting a unique ID, I will have to utilize the date option.

Thanks for the help.