Auto Populate String Question

icf_Eric_Link

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!

dougbrowning

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.