Arcade Table Not Running Function

Ed_ — Tue, 05 Nov 2024 15:53:08 GMT

Hello all, good morning, hope all is well 🙂, so I have added three functions in an Arcade script for a table.

The script itself is not flagging any errors, but the output window say "Unable to execute Arcade script"

How can I fix this?

Whole code:

// Color severity values function returnColorS(value){ return When( value == "Minor", "#dedede", value == "Significant", "#C1C1C1", value == "Major", "#D18E8E", value == "Severe", "#D17578", ) } function showIconS(value){ return IIF(value == "Severe", "Alert",'') } function showIconL(value){ return IIF(value == "Likely", "Alert",'') } return { cells: { name: { displayText : $datapoint.name, textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, home_address: { displayText : $datapoint.home_address, textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, cell_phone: { displayText : $datapoint.cell_phone, textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, email_address: { displayText : $datapoint.email_address, textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, date_and_time: { displayText : Text($datapoint.date_and_time), textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, who_is_submitting_the_potential: { displayText : $datapoint.who_is_submitting_the_potential, textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, what_government_level: { displayText : $datapoint.what_government_level, textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, what_kind_of_hazard_are_you_rep: { displayText : $datapoint.what_kind_of_hazard_are_you_rep, textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, please_specify_the_type_of_haza: { displayText : $datapoint.please_specify_the_type_of_haza, textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, how_severe_could_the_injury_to: { displayText : $datapoint.how_severe_could_the_injury_to, textColor: '', backgroundColor: returnColorS($datapoint.how_severe_could_the_injury_to), textAlign: 'left', iconName: showIconS($datapoint.how_severe_could_the_injury_to), iconAlign: '', iconColor: '', iconOutlineColor: '' }, what_is_the_probability_that_in: { displayText : $datapoint.what_is_the_probability_that_in, textColor: '', backgroundColor: '', textAlign: 'left', iconName: showIconL($datapoint.what_is_the_probability_that_in), iconAlign: '', iconColor: '', iconOutlineColor: '' }, } }

Functions and where there are being used in the script:

Re: Arcade Table Not Running Function

Ed_ — Tue, 05 Nov 2024 15:54:13 GMT

Good morning @KenBuja hope all is well, any help with this will really appreciated, cheers 🙂

Re: Arcade Table Not Running Function

KenBuja — Tue, 05 Nov 2024 16:24:53 GMT

One issue is the When function doesn't have a default value. When I remove that from my test, I get the "Unable to execute" message

function returnColorS(value){ When( value == "Minor", "#dedede", value == "Significant", "#C1C1C1", value == "Major", "#D18E8E", value == "Severe", "#D17578", "#f00000" ); }

Re: Arcade Table Not Running Function

Ed_ — Tue, 05 Nov 2024 16:36:17 GMT

yup that worked like charm 🙂 you are the best 😎 thank you for the super quick response

have a nice day and week ahead 🙂

topic Arcade Table Not Running Function in ArcGIS Dashboards Questions

Arcade Table Not Running Function

Re: Arcade Table Not Running Function

Re: Arcade Table Not Running Function

Re: Arcade Table Not Running Function