I am getting some interesting behavior when using a contains() function. I want to make a field relevant only if at least one of the records in a repeat has a specific value. Ideally I would use a formula like contains(sum(${field_of_interest),'no') which should return a value of true if any of the repeat record has a value of 'no' in the field_of_interest field. This is not the case and my contains function always returns true, even if the function is given as contains("A","B").
I have attached some screenshots of the survey I was using.
Any help is appreciated!
P.S. Please disregard the SITE_ID field, it is populated from a pop-up window in a AGOL web-map.
Hi Matthew,
I'm not seeing the results you are describing - the contains() function seems to work properly (in your form, I both the contains("A","B") and contains(sum(${Test}),"no") functions work).