topic Re: Auto Populate String Question in ArcGIS Survey123 Questions

Auto Populate String Question

icf_Eric_Link — Mon, 15 May 2023 16:22:09 GMT

Helle, I am looking to auto populate a text question based on the answer from a select one question. So basically, if no is selected from Question 1 (yes/no) then populate text question 2 with "Not Applicable". If yes is selected then text question does not get auto populated.

I have tried using if(condition, a, b) statement but can't seem to get it to work properly. Any suggestions would be appreciated.

Thanks!

Re: Auto Populate String Question

Richard_Purkis — Mon, 15 May 2023 16:28:18 GMT

Hi @icf_Eric_Link

I'd recommend sharing your form so it is easier to test and provide you with a solution

Thanks

Re: Auto Populate String Question

icf_Eric_Link — Mon, 15 May 2023 16:31:53 GMT

Hi Richard, thanks for your response. I have attached my form and the rows colored in orange are the ones I'm looking to autopopulate. Both text questions would need to be populated with Not Applicable if "no" select one question is selected.

Re: Auto Populate String Question

DougBrowning — Mon, 15 May 2023 18:36:03 GMT

For some reason you have the calc in the relevant column.

Move to the calculation column then you do this.

if(selected(${Tribal_Monitor_Present},'No'), 'Not Applicable', '')

What this does is if No set to Not Applicable else empty string. This will allow the user to then add something. Now it will then show a refrrsh icon that if the user taps it then it goes back to blank. But they can add something and leave it and it will be saved.

I know it seems funky but this is how to say make it Not Applicable or do nothing. No other way to do it. The way you have it written is a dependcency cycle which can hard to explain. You cannot say make it this value else keep that old value since once the if runs it is too late and the old value is gone already.

Hope that makes some sense it can be a tough concept.

Re: Auto Populate String Question

icf_Eric_Link — Mon, 15 May 2023 19:00:57 GMT

Ah thanks Doug. This makes sense and helped me out. Much appreciated.