AnsweredAssumed Answered

Contains() Giving Strange Results

Question asked by MKEMPER_governmentofbc on Nov 26, 2018
Latest reply on Dec 2, 2018 by JTedrick-esristaff

Ismael Chivite

James Tedrick

 

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.

Attachments

Outcomes