How do you clean up unanswered survey questions in a dashboard popup.

Question

I have a form on Survey123 which collects point data along with other information. This data is put into a webmap which is displayed on a dashboard. When you click on the point in the map the popup shows all possible fields on the form. I would like to clean it up so that only the fields that were answered get displayed.

Annotation 2020-06-05 090543.png

JoeLemeris_1-1739639757759.png

CameronAmrine1 · Answer

Hey Garrett, Here is some arcade you can use. It will remove any fields that are null/empty. Additionally, the order in which you declare the fields in the script will be how they show up in the popup. #Create dictionary of fields. Text within single quotes is the desired field alias var fields = Dictionary('Field Name 1',$feature.Fieldname1, 'Field Name 2',$feature.Fieldname2, 'Field Name 3',$feature.Fieldname3); #Populate dictionary with fields from above var fields = [Dictionary('fieldName', 'Field Name 1', 'fieldValue', $feature.Fieldname1), Dictionary('fieldName', 'FieldName2', 'fieldValue', $feature.Fieldname2), Dictionary('fieldName', 'Field Name 3', 'fieldValue', $feature.Fieldname3)]; var popup = ''; #Remove null/empty fields for(var f in fields){ if (IsNan(fields[f]['fieldValue'])== false && IsEmpty(fields[f]['fieldValue']) == false){ popup += Concatenate([fields[f]['fieldName'], ':', ' ', fields[f]['fieldValue'], ' '], ''); } } return popup;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Just insert the expression into your popup as a custom popup. If there are a ton of fields, it can be tedious but it works! If its being entered into a Details Element within a dashboard you can also add html tags to line 15 to make text bold or add color. Just a note: This does not change the actual data itself in any way. It's just forming the popup in memory and displaying the data in a different way visually.

GarrettBlevins · Answer

I thought of that but then it puts it on every popup when the goal is to have it show up only if that point has that field.

DonShawEsri · Answer

Try this in your second table row with expression/expr1: Reporters Phone Number: {expression/expr1}