IfElse Formula help

Hello everyone

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!

Parents

0 Chris Raffle 6 months ago

Hi Phuong Trinh ,

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Chris Raffle 6 months ago

Hi Phuong Trinh ,

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data