Details about this thread
  • State Not Answered
  • Replies 2 replies
  • Subscribers 320 subscribers
  • Views 151 views
  • Users 0 members are here

Finding the Display Label via the Item name

Hugo Geyskens

Hi all,

We have a dropdown that holds all 2-character-country codes as Item Name and next to it the continent/region as Display label , to which that country belongs.

F.i. FR gives EMEA, CA gives NA.

Can I use some kind of lookup formula in BPM/Studio to find the region via using the country code?

(I'm not familiar at all with PHP).

Thanks !

;-)

Hugo

  • 0

    Hi  ,

    The best available option I can think of is the getDropdownValue Sugar Logic formula. The formula is used in following format where I assume the dropdown list is called 'region_list' and the field that has the dropdown value saved is called region_c:

    Fullscreen
    1
    2
    3
    4
    getDropdownValue(
    "region_list",
    $region_c
    )
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    I hope that suits your needs!

    Chris

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

  • 0 in reply to Chris Raffle

    Hi  

    That was the perfect hint (as usual :-) ) 

    Thanks.

    Do you know when we can use AI to querry the user forum and knowledge base ? 

    So that I can simply ask AI "how to get the region when I have the 2 character ISO code for country when both are in one dropdown list in Sugar ?"

    :-)

    Bye now

    Hugo