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.
@RyanMcKenna did you ever happen to work out a solution for this? I, and many others on the forums, have tried exactly what you originally posted ( ${if ...==""}<TEXT>${/} ) to no avail. I read one forum post earlier with a response from an Esri Product Engineer that even signed off on that syntax, so it seems even Esri doesn't know how to do it if it is possible...