You’re offline. This is a read only version of the page.
I have Gallery1.
I have Shape - circle (1-4).
Each circle can be either 'Red' or 'Green'.
I am trying to write a formula that changes the content of the ComboBox based on the color of each Shape.
There are four shapes. Each can be either 'Red' or 'Green'.
I trying to figure out this formula -
Switch(
true,
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green, ["Continuous","Intermittent","New Claim","Leave Policy"],
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,["Continuous","New Claim"],
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,["Continuous","Intermittent","Leave Policy"],
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,["Continuous","New Claim","Leave Policy"],
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,["Continuous","Intermittent","New Claim"],
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,["Continuous","New Claim"],
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green,
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green,
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red,
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,["Continuous","Intermittent"])))))))))))))))))))))))))))))
Hi @Phineas
You need to && then together or And
Also i dont know why you had some many ) at the end of it i removed them
Share
Report
5,331
All responses (
Answers (
Switch(true,
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green &&
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green &&
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,
["Continuous","Intermittent","New Claim","Leave Policy"]
,
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red &&
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green &&
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,
["Continuous","New Claim"]
,
Radar_Data_Continuous_Circle_Icon.Fill=Color.Gree &&
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green &&
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green &&
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,
["Continuous","Intermittent","Leave Policy"]
,
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red &&
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Green &&
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,
["Continuous","New Claim","Leave Policy"]
,
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green &&
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red &&
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,
["Continuous","Intermittent","New Claim"]
,
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Red &&
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red &&
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Green,
["Continuous","New Claim"]
,
Radar_Data_Continuous_Circle_Icon.Fill=Color.Green &&
Radar_Data_Intermittent_Circle_Icon.Fill=Color.Green &&
Radar_Data_Leave_Policy_Circle_Icon.Fill=Color.Red &&
Radar_Data_New_Claim_Circle_Icon.Fill=Color.Red,
["Continuous","Intermittent"]
)
for them all
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
