AnsweredAssumed Answered

Contains() Giving Strange Results

Question asked by deleted-user-AHEapLrN7M1u 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.