topic Creating a maintenance summary note from calculated field in ArcGIS Survey123 Questions

Creating a maintenance summary note from calculated field

BryanO_Reilly — Tue, 21 Apr 2020 19:52:44 GMT

Hello,

I'm trying to create a detailed and formatted maintenance summary dynamically from user input. So far, I have got the function to work, but it will only take the first TRUE if statement. Ideally, everything with a rating > 1 would be appended to the "Maintenance Summary" with the format shown below (Name: {Rating} 'new line indented' Comment: {Comment}). I'm doing this using one hidden field for the calculation (type: calculate) and one field for the Maintenance Summary (type: note; label: <center>Maintenance Summary</center>${Maintenance_Calc})

the calculation in the calculated field is as follows (only for two fields at the moment for testing; it will be used on around 200 fields if I can get it to work..)

if(${IB_IZ_IO_Rat}>1,'Inlet Zone - Inlet obstruction: ' + ${IB_IZ_IO_Rat} + '<blockquote>Comment: ' + ${IB_IZ_IO_Comm} + '</blockquote>','') or if(${IB_IZ_EBSS_Rat}>1,'Inlet Zone - Erosion, bare spots, & sedimentation: ' + ${IB_IZ_EBSS_Rat} + '<blockquote>Comment: ' + ${IB_IZ_EBSS_Comm} + '</blockquote>','')

Any and all help is greatly appreciated!!!

Re: Creating a maintenance summary note from calculated field

BryanO_Reilly — Tue, 21 Apr 2020 21:26:20 GMT

I got it to work as I intended.

Modified Calculation Code below. The Key was to make them self contained if statements and use the "+" symbol to combine them.

if(${IB_IZ_IO_Rat}>1,'Inlet Zone - Inlet obstruction: ' + ${IB_IZ_IO_Rat} + '<blockquote>Comment: ' + ${IB_IZ_IO_Comm} + '</blockquote>','') + if(${IB_IZ_EBSS_Rat}>1,'Inlet Zone - Erosion, bare spots, & sedimentation: ' + ${IB_IZ_EBSS_Rat} + '<blockquote>Comment: ' + ${IB_IZ_EBSS_Comm} + '</blockquote>','') +if(${IB_IZ_PT_Rat}>1,'Inlet Zone - Pretreatment: ' + ${IB_IZ_PT_Rat} + '<blockquote>Comment: ' + ${IB_IZ_PT_Comm} + '</blockquote>','') +if(${IB_IZ_SI_Rat}>1,'Inlet Zone - Structural Integrity: ' + ${IB_IZ_SI_Rat} + '<blockquote>Comment: ' + ${IB_IZ_SI_Comm} + '</blockquote>','') +if(${IB_PZ_SA_Rat}>1,'Perimeter Zone - Surface area: ' + ${IB_PZ_SA_Rat} + '<blockquote>Comment: ' + ${IB_PZ_SA_Comm} + '</blockquote>','') +if(${IB_PZ_SSE_Rat}>1,'Perimeter Zone - Side slope erosion: ' + ${IB_PZ_SSE_Rat} + '<blockquote>Comment: ' + ${IB_PZ_SSE_Comm} + '</blockquote>','')