AGOL GIS Request Management Solution: Displaying CSV "Label" Instead of "Name" in Dashboard Filters and Tables

Cierra_Scriven

Hello again @BrandiRank22  & @DanielWickens ,

I am currently working on the AGOL GIS Request Management Solution and have encountered an issue I could use some help with. I've set up the CSV that feeds the Survey123 form to include pre-made values for the "assignedto" field, as per the documentation. Specifically, the "name" field in the CSV contains the team member's email address (e.g., JaneDoe@organizationhandle.org), and the "Label" field contains their full name (e.g., Jane Doe).

However, in the dashboard, I would prefer to see the label "Jane Doe" displayed in the sidebar filters and table column values. Instead, the dashboard is showing the email address (e.g., JaneDoe@organizationhandle.org) in these areas.

Could you provide guidance on how to configure the dashboard so that the label (e.g., "Jane Doe") is shown instead of the email address? Any advice or examples would be greatly appreciated.

Thank you in advance for your help!

Cierra_Scriven

Surprise! I actually managed to solve by modifying the Arcade script in the Dashboard Configuration -> Table -> Values.

There are two lines (19 and 20 at the time of writing this post) that contain variables:

var urgent_textcolor = IIf($datapoint.urgent == "Yes", '#ffffff', '')
var urgent_bgcolor = IIf($datapoint.urgent == "Yes", '#a11506', '')

 

Just below them on line 21 through 25 I added another variable: 

 

var name_assigned = IIf($datapoint.assignedto == "JaneDoe@organization.org", 'Jane Doe',
IIf($datapoint.assignedto == "JohnDoe@organization.org", 'John Doe', ''))
​

Then I replaced the "displayText" for a column return like so:

 

assignedto: {
displayText : name_assigned,
textColor: '',
backgroundColor: '',
textAlign: 'left',
iconName: '',
iconAlign: '',
iconColor: '',
iconOutlineColor: ''
},

 

Success!