Is there a way to get the value of a custom field instead of the label when building a calculated field? | Community
Skip to main content
Kurt_Jones
Community Advisor
Kurt_JonesCommunity Advisor
Community Advisor
March 30, 2025
Solved

Is there a way to get the value of a custom field instead of the label when building a calculated field?

  • March 30, 2025
  • 2 replies
  • 506 views

My example, I have a drop-down field, countries where I have a value and label set up, such as Australia (label=Australia value=AU), United States (label=United States value=US), and so on.  I would like to use the value in a Calculated field but not sure how to get to it or if that is possible, anyone know?

 

 

Best answer by Doug_Den_Hoed_AtAppStore

 

Hi @kurt_jones,

 

If a calculation uses the label by default and you'd prefer the value (or vice versa; I'm away from my computer, but from memory), I usually use a series of IF statements to decode the desired translation.
 
Regards,
Doug

 

2 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
March 30, 2025

 

Hi @kurt_jones,

 

If a calculation uses the label by default and you'd prefer the value (or vice versa; I'm away from my computer, but from memory), I usually use a series of IF statements to decode the desired translation.
 
Regards,
Doug

 

VicSellers
Community Advisor
VicSellersCommunity Advisor
Community Advisor
March 30, 2025

We run into this problem a lot (especially with AEM integrations)...definitely wish there was an option to choose to show the label vs. value in a calculated field without needing to write out the IF/Replace statements. 

Terms & ConditionsAccessibility statement

Loading footer...