Have Calculated Field Show Label Instead of Value for Dropdown Choices | Community
Skip to main content
VicSellers
Community Advisor
Community Advisor
October 10, 2023
Question

Have Calculated Field Show Label Instead of Value for Dropdown Choices

  • October 10, 2023
  • 1 reply
  • 1088 views

On dropdown lists, we use both the Label + Value for a choice. We then use calculated fields to consolidate the choices across multiple dropdowns; however, since we used both the Label + Value, what returns in the calculated field is the Value (which isn't the user friendly name). Does anyone have any tips for getting the calculated field to pickup the Label here instead of Value? 

 

We do use IF statements as the workaround, but it is cumbersome when there are a lot of choices / maintenance. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Level 3
January 3, 2024

Did you manage to figure this out @vicsellers 

We need to know the answer to this too...

Rob

VicSellers
Community Advisor
Community Advisor
January 3, 2024

Hi @robertdy - We've requested an enhancement for this (who knows if it will be added though, but fingers crossed!), but our short-term solution has been using a calculated field with a replace statement.

Level 3
January 3, 2024

Oh man... what a nightmare. That defeats the whole purpose of having the ability to alter the label separately from the value for our purpose 😞

Fingers crossed they listen. I have a support ticket in with them now. 

Do you have a link to the feature request so I can upvote?

 

Rob