Hi
We have two types of data collectors and to each group, we need to give the list of sites with different filters. Currently, this is solved by two different variables (with different “relevant” conditions) which then get merged through the calculation: concat(${site_select_impl},${site_select_geo}))
The problem is that we cannot edit the calculated field after the form is saved to the server (which we occasionally have to do) – if we edit the two select_one fields, the form isn’t recalculated in order to fill the calculated field.
An alternative solution would be to use an if-condition in the appearance column. Does this work?
What doesn’t work is:
if(selected(${collector_type},‘A’),minimal search(‘facilities_xx’,‘contains’, ‘label’, *, ‘flt_geoinstorg’, ${geo_org}),minimal search(‘facilities_xx’,‘contains’, ‘flt_geoinstorg’, ${geo_only}))
