Hi everyone,
I’m working with a Survey123 Connect form for a salmon spawning survey. The survey layer has many fields, and depending on what data is collected at a point, many of those fields may not be populated.
Instead of leaving these fields <null>, I’d like them to be filled with "NA" via the survey. All of the fields that should default to "NA" are select_one fields, and all are tied to relevant expressions.
I’ve tried setting this default:
if(${Data_Type} = 'Reach Start' or ${Data_Type} = 'Reach End', '', 'NA')and using this choice filter:
(${Data_Type} != 'Reach Start' and ${Data_Type} != 'Reach End') or name != 'NA'This is for "Flow" data, which is only being gathered when the 'Reach Start' or 'Reach End' Data_Type is selected.
Here is the Relevant expression
${Data_Type} = 'Reach Start' or ${Data_Type} = 'Reach End'
My attempt did not work.
What’s the best approach to populate "NA" for all relevant fields without manually adjusting each one? Any sample formulas, workflows, or best practices would be greatly appreciated!
Thanks,
Aaron
