https://community.esri.com/t5/arcgis-survey123-questions/using-null-or-not-null-values-in-a-field-to-set-a/m-p/1251868#M47122 <P>Upon loading a survey, I am trying to make an answer for a select_one question default to either 'new' or 'existing' based on whether or not another value in my table is null or not null. What would be the code for this, and would it be entered in the default or calculation column? Can this be done with an if/then statement?<BR /><BR />Am I at least in the ballpark with this or is there an easier way?<BR />if(${Location} = null),select_one = 'new') or if(${Location} = notnull),select_one = 'existing')</P><P>Thanks!</P> Thu, 26 Jan 2023 14:59:42 GMT JoeDahlen 2023-01-26T14:59:42Z https://community.esri.com/t5/arcgis-survey123-questions/using-null-or-not-null-values-in-a-field-to-set-a/m-p/1251868#M47122 <P>Upon loading a survey, I am trying to make an answer for a select_one question default to either 'new' or 'existing' based on whether or not another value in my table is null or not null. What would be the code for this, and would it be entered in the default or calculation column? Can this be done with an if/then statement?<BR /><BR />Am I at least in the ballpark with this or is there an easier way?<BR />if(${Location} = null),select_one = 'new') or if(${Location} = notnull),select_one = 'existing')</P><P>Thanks!</P> Thu, 26 Jan 2023 14:59:42 GMT https://community.esri.com/t5/arcgis-survey123-questions/using-null-or-not-null-values-in-a-field-to-set-a/m-p/1251868#M47122 JoeDahlen 2023-01-26T14:59:42Z https://community.esri.com/t5/arcgis-survey123-questions/using-null-or-not-null-values-in-a-field-to-set-a/m-p/1251908#M47125 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/650937">@JoeDahlen</a>&nbsp;</P><P>I think something like this should work for you:</P><UL><LI>if((string-length(${<SPAN>Location</SPAN>})&gt;0),'existing','new')</LI></UL><P>Place this in your calculation field</P><P>Hope this helps</P> Thu, 26 Jan 2023 16:13:40 GMT https://community.esri.com/t5/arcgis-survey123-questions/using-null-or-not-null-values-in-a-field-to-set-a/m-p/1251908#M47125 Richard_Purkis 2023-01-26T16:13:40Z https://community.esri.com/t5/arcgis-survey123-questions/using-null-or-not-null-values-in-a-field-to-set-a/m-p/1252167#M47142 <P>Thank you <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/361875">@Richard_Purkis</a>!</P><P>Formula worked great. The only thing I had to add was under <STRONG>bind::esri:parameters</STRONG>, <STRONG>calculationMode=always</STRONG></P> Thu, 26 Jan 2023 22:51:00 GMT https://community.esri.com/t5/arcgis-survey123-questions/using-null-or-not-null-values-in-a-field-to-set-a/m-p/1252167#M47142 JoeDahlen 2023-01-26T22:51:00Z