Hello,
Is there a way to have the feature report insert conditional text when no response was entered in Survey123?
I have a monthly inspection form with 15 numeric questions, but depending on conditions on site, some may be left blank intentionally. The project manager want to insert a text value like "N/A" or "Not Collected" in the report table rather then hiding these rows or leaving them blank.
I have tired ${decimal_1}${if decimal_1 == “”} N/A${/} based on another post, but this does not insert anything in the report, and ${select2}${if select2 != “”} N/A${/} which inserts "N/A" whether the question was answered or not.
I know I can add some calculations in the Survey123 form to flag if the question was answered as a work around but I would rather not as it changes the output table and adds to the development cost and I feel like there must be a way this can be accomplished in the feature reports.
Thanks
Ryan
Enter a default value.
This is not always possible. If we are collecting something like pH or Temperature in the field, you cannot really add a default number to it if you did not measure it.
Could you default to something like -999 to indicate no measurement? Toxicologists here sometimes use the minimum detectable level in place of NA when having to use numeric values, since they can't actually say 0 when something could be present below detectable levels.
Another option, maybe: convert numeric values to text in another field in the survey and use that for your report.