Going through all existing repeats before submitting survey

IniobongBenson

I have a survey where I have enabled inbox to pull in existing records and the records use repeats. For example, one building may have multiple cameras on which an inspection is to be carried out.

The form shows that for a particular building there could be 1 of 3 cameras when a particular building is open from the inbox list, and there are relevant questions that must be answered before the form can be summitted, however, an inspector that submit the form even without going through the remaining 2 cameras in the building. How can I solve this?

 

I've been able to create a field that stores the count of cameras in each building and show it in a note using the count(${repeat_field}) but this is not enough. Is there a way to force the inspector to actually go through each repeat and answer at least the relevant question?

Thanks

Using a join like this on the image above would probably make it work but I don't know how to implement this.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-repeats/ba-p/898041

Anonymous User

Hi @IniobongBenson,

Yes, you can do this using a constraint in the main layer referencing values from the repeats. Add a count in a hidden field that will check each repeat and either count a question or do a string-length > 0, to ensure there is an answer in that question and returns a 1.

Then sum or count the 1's, and if they match the number of repeats, the constraint will be met, if they do not match, it means one of the repeats is not answered. This will cause an error and the form can not be submitted.

Please refer to https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm for supported formulas and functions, including the newly added functions for position and indexed-repeat, which you may find useful to query each repeat for specific values.

Regards,

Phil.