nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Restricting duplicates for a field during repeats

SeanYancey

The situation is that there will be a transect that has multiple stopping points to listen for birds. So the initial form will collect transect information, then with a repeat section to collect information at each individual stop. I'm hoping to see if there is functionality that will not allow users of the survey to accidentally duplicate the same stop point. Each seperate transect has 10 stopping points (1, 2, 3, 4, etc.). After conducting a stop and proceeding to the next repeat can I restrict the option to not allow the use of the same stop point? It's currently set up as a select_one field.

Vind meer berichten getagd met

Accepted answers

All comments

Anonymous User

Hi Sean,

Yes, this should be possible by using some additional text fields (possibly make them hidden or null so not written to feature service or visible on form) and using calculations to write all the values selected from those select ones questions in the repeat, into one text field as a list, and then use constraints to check if the values the user selects on next repeat record are already contained in that list. I have seen other users do this successfully to validate the entries entered into repeats from select one questions and avoid the same value being selected twice.

Phil.

dougbrowning

This has been posted a few times - See my post here. https://community.esri.com/thread/233596-populate-values-in-selectmultiple-from-previous-repeat

SeanYancey

Thanks Doug,

That makes sense and I've created a text field that uses the join function to create a list the stop points that have already been recorded. I am having trouble writing an appropriate expression that either, removes the already recorded stop point from the select_one list or validating it with an error "invalid entry" when a stop point is attempting to be duplicated.

dougbrowning

You cannot remove it that is impossible. Use a constraint to yell at them if they do it. Note your text field needs to be outside the repeat.

It should all be in the post. Put this is the constraint of the large text field

not(contains(substr(${AllPlantsCheck}, 0, string-length(${AllPlantsCheck}) - 3), ${SpeciesList}))

Create a large txt (or note) field outside the repeat. i did text so users can copy and paste it.

Add a calc joining the fields from the repeat join(", ", ${SpeciesList})

Set a constraint on this join field (not the field) - the trick here is to remove the last entry since it is the one you are trying to add currently.

So like this not(contains(substr(${AllPlantsCheck}, 0, string-length(${AllPlantsCheck}) - 3), ${SpeciesList}))

--If you do not do this it immediately adds to the list then complains it is already there.

--(note my plant codes are 4 chars. so if i remove the last 3 chars it will not find what I just added)

It can be funky if you go backwards and then change something but it still seems to work ok.

I even built on exceptions to the rule. If it contains a xyz generic code then the repeat is allowed.

Like contains(${SpeciesList}, "xyz") or not(contains(substr(${AllPlantsCheck}, 0, string-length(${AllPlantsCheck}) - 3), ${SpeciesList}))

SeanYancey

Thanks Doug,

I've been trying multiple variations of your argument in the constraint field to try and get an error to pop up and it just seems to not be behaving the way it should. The argument I am using in the constraint for the joined field is:

not(contains(substr(${stops_completed}, 0, string-length(${stops_completed}) - 2), ${stop_point}))

stops_completed is the joined text field that is generated from the stop_point field. So if I'm understanding this correctly, the contains function is looking for the text you are trying to input (in my case the point you are at {$stop_point}) and referencing it to a substring of the string that is being created which is (${stops_completed}, 0, string-length(${stops_completed}) - 2). The substring argument should return back the list ,minus 2 characters in this case to account for the text you are adding to the string so it automatically doesn't come back saying it is already contained in the list. I've tried altering the amount of characters removed at the end of the string from 0 to 3 and none will return an error message. As it is currently I can generate strings of 01,01,01,01 which is obviously not what I want. Am I missing something obvious?

Thanks for your time.

Sean

SeanYancey

This is my xls form for reference.

Pheasant Crow Survey.xlsx

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.