Prevent Duplicates During Survey123 Submittal Process

Question

My goal is to prevent duplicate survey records from getting entered into the hosted feature service. I would like for the survey submittal to act similar to a database form when you try to insert a record with a duplicate key, it throws an error and aborts. I would like the survey to check for a unique ID to see if it already exists in the feature service records. If it already exists then an error message is presented to the user telling them of the problem and the submittal is aborted. If no record exists with the key then the submittal goes through. Is this kind of behavior possible using Survey123 and the hosted feature service?

In this post, I see how the surveys are moved to the Sent box when they are successfully submitted but that is not quite what we are looking for. Survey 123 Data in Sent folder not received in database

Thanks,

Bill

wwwl_singlis · Answer

Has anyone had any luck with this? This is the exact issue I am working on at the moment. Customised error message. It's not a show-stopper, but it is ugly having this gibberish message appear.

Sara_ · Answer

Hi,

Has anyone had any success with this concept in Field Maps?

I need to limit duplicate input QR codes when samplers are submitting from the field.

Thanks

JonahW · Answer

Hello @khutchinson,

I was curious if you were able to figure out how to generate a custom message.

Thank you!

Alina