topic Re: How to return a blank from IF THEN statement in hidden field? in ArcGIS Survey123 Questions

How to return a blank from IF THEN statement in hidden field?

ChrisShuck1 — Fri, 19 Oct 2018 19:13:32 GMT

I am using an IF THEN statement in the calculation column of a hidden field. If the user answers 'no' to the question then 'N/A' is returned. If the user answers 'yes' then nothing is returned, which I have designated by using ''. Here's the statement: if(${BM_1}='no', 'N/A', ''). It's important that the blank field is returned as blank on the printed report. However, it is being returned as "undefined" instead. I want this field to remain hidden in the survey itself. If the field is not hidden in the survey, a blank is returned on the printed report. If the field is hidden, it returns "undefined". This is how I want it set up:

I have attached the spreadsheet and Word template. There are 11 questions which will be formatted this way, starting at line 30. It's kind of a mess, because I've been playing around with various ways to try to get this to work.

Is there a way around this issue?

Re: How to return a blank from IF THEN statement in hidden field?

Anonymous User — Thu, 03 Jan 2019 02:27:35 GMT

Hi Chris,

Sorry for the delay in replying to this post, however I came across it while looking for something else so thought I would give you an update. I tested your report template with your xlsx form published as a new survey and the issue no longer occurs with the latest release of the website. I believe the problem with "undefined" being displayed when values are "null" in the report was resolved recently. Can you please try again with your survey and report template and let me know if you still have any issues.

Phil.

Re: How to return a blank from IF THEN statement in hidden field?

ChrisShuck1 — Wed, 20 Feb 2019 21:40:41 GMT

Hi Phil,

Sorry for the late reply, and thanks for testing this and getting back to me. This does work properly now.

Thanks,

Chris