Details about this thread
  • State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 318 subscribers
  • Views 1730 views
  • Users 0 members are here

IfElse Formula help

Phuong Trinh

Hello everyone Slight smile

I have problem with my formula IfElse and i don't why it doen't work... 

So here is my formula :  ifElse(equal($statut_prospect_c,""),"","ACHAT")

I'm trying to parameterize the "OFFERS" field. I want to indicate that if the $status_prospect_c field is empty, the "OFFERS" field containing this formula will take the empty value "", otherwise "PURCHASE".

I cannot execute the formula, i received the message : "The formula must be of typeboolean"

Knowing that the "OFFER" field is of the multiple-choice list type

Can someone point out what I am doing wrong?

Thanks in advance!

  • 0

    Hi  . I have never tried formula on a multienum field before, maybe the error you are facing is due the way multienum values are set. try that instead:

    ifElse(equal($statut_prospect_c,""),"^^","^ACHAT^")

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Hi  i've tried your formula, but it still doesn't work Disappointed I've received the same message box : The formula must be of typeboolean

  • 0

    In which module do you want to implement that formula?

    And how are the fields defined?

    Is the name of the field status... or statut...?

    Which field is the multiselect field and how is the dropdown defined?

    AND in which language did you use the studio formula editor?

  • 0

    Hi  ,

    Multiselect fields do not have an option in Studio to set the field as a calculated field. Based on the error message you are receiving, it seems like you are trying to put the formula in the 'Required If' or 'Read Only If' formula options since those options require a boolean outcome. If you are looking to set the multiselect field based on another field value, your best option in terms of native Sugar functionality is to use SugarBPM.

    Chris

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