topic Re: Survey 123 Unique IDs in ArcGIS Survey123 Questions

Survey 123 Unique IDs

BNix_TPA — Tue, 04 Oct 2022 18:20:08 GMT

Hi,

I'm looking at having on of my fields in Survey123 auto-populate. I know this has been asked a bunch, but I think this may be a unique scenario. Basically I'm creating a dashboard to show current construction projects. Each project can have multiple Construction Notifications, this is the number I want auto-populated. I want to be able to have unique Construction Notification Numbers, and be sequential, per project. Say I have Project 123-45 this could have notification 1,2,3. Project 789-10 could also have notification 1,2,3. But the notifications are each unique to the project they are for. Is this possible? Seems like a JS solution, but the solutions I have come across don't do this exactly.

Thank you!

Re: Survey 123 Unique IDs

DougBrowning — Tue, 04 Oct 2022 18:45:30 GMT

You could try the new pulldata to a layer which is in beta now.

But it will never be perfect. User A starts a form, lookup brings back 8 + 1 =9. While User A is filling out the form User B starts a form, lookup brings back 8 + 1 = 9. Then they eventually both submit - dups.

Some type of timestamp key is about the only way Project 789-1004221244. Or use no key at all. Pass the main ID from the parent in and forget it.

With the relationships built in what is the use case for the IDs?

Re: Survey 123 Unique IDs

BNix_TPA — Tue, 04 Oct 2022 19:48:04 GMT

I don't think there will be much overlap with the submissions, so dups aren't necessarily an issue. They use the IDs to see how many notifications have been sent out per project.