https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-working-fine-while/m-p/1207127#M4398 <P>You're comparing $feature.RAINFALL to a string value. Is the field really a string field?</P><P>Also, you can shorten that script like so:</P><LI-CODE lang="javascript">var mdm1 = [1,1,2,2,3,3,3,5]; var mdm2 = [1,1,1,2,2,2,2,3]; var mdm; if (DomainName($feature,"Area_Charectristics") == "Open Forest") { mdm=mdm1;} if (DomainName($feature,"Area_Charectristics") == "Open Grassland") { mdm=mdm2;} var index = Number($feature.RAINFALL); return mdm[index]</LI-CODE> Mon, 29 Aug 2022 09:21:05 GMT JohannesLindner 2022-08-29T09:21:05Z https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-working-fine-while/m-p/1206596#M4389 <P><SPAN>forms for every calculated expression is working fine while testing but not populating in fields&nbsp;&nbsp;while populating</SPAN></P><P><SPAN>for more insight This was the script getting&nbsp;result on testing&nbsp;but not on inputting&nbsp;data in form</SPAN></P><P><SPAN>var mdm1 = [1,1,2,2,3,3,3,5];<BR />var mdm2 = [1,1,1,2,2,2,2,3];<BR />var mdm;<BR />if (DomainName($feature,"Area_Charectristics") == "Open Forest")<BR />{ mdm=mdm1;}<BR />if (DomainName($feature,"Area_Charectristics") == "Open Grassland")<BR />{ mdm=mdm2;}<BR />if ($feature.RAINFALL=="0"){<BR />return mdm[0];<BR />}<BR />if ($feature.RAINFALL=="1"){<BR />return mdm[1];<BR />}<BR />if ($feature.RAINFALL=="2"){<BR />return mdm[2];<BR />}<BR />if ($feature.RAINFALL=="3"){<BR />return mdm[3];<BR />}<BR />if ($feature.RAINFALL=="4"){<BR />return mdm[4];<BR />}<BR />if ($feature.RAINFALL=="5"){<BR />return mdm[5];<BR />}<BR />if ($feature.RAINFALL=="6"){<BR />return mdm[6];<BR />}<BR />if ($feature.RAINFALL=="7"){<BR />return mdm[7];<BR />}</SPAN></P> Fri, 26 Aug 2022 00:59:47 GMT https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-working-fine-while/m-p/1206596#M4389 SajoJose 2022-08-26T00:59:47Z https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-working-fine-while/m-p/1207127#M4398 <P>You're comparing $feature.RAINFALL to a string value. Is the field really a string field?</P><P>Also, you can shorten that script like so:</P><LI-CODE lang="javascript">var mdm1 = [1,1,2,2,3,3,3,5]; var mdm2 = [1,1,1,2,2,2,2,3]; var mdm; if (DomainName($feature,"Area_Charectristics") == "Open Forest") { mdm=mdm1;} if (DomainName($feature,"Area_Charectristics") == "Open Grassland") { mdm=mdm2;} var index = Number($feature.RAINFALL); return mdm[index]</LI-CODE> Mon, 29 Aug 2022 09:21:05 GMT https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-working-fine-while/m-p/1207127#M4398 JohannesLindner 2022-08-29T09:21:05Z https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-working-fine-while/m-p/1207503#M4404 <P>Thanks for the response<BR />$feature.RAILFALL is a code value</P><P>This is also returns value while testing but no updating while inputting through forms</P><P>&nbsp;</P> Tue, 30 Aug 2022 00:08:15 GMT https://community.esri.com/t5/arcgis-field-maps-questions/calculated-expression-is-working-fine-while/m-p/1207503#M4404 SajoJose 2022-08-30T00:08:15Z