Action button - configure - dependent on dropdown = no or blank

Hi Taufique,

Can you replace the formula as mentioned equal($pr_informal_extension_c, "No") and check how it goes?

Thanks and Regards,

PK,

www.bhea.com

Thank you for the reply 

Unfortunately, this update did not work

To confirm the dropdown is brand new, 99% of records in Sugar the value saved would be blank

I was hoping the formula would be able to determine if the field is empty?

Thanks again

potentially I could use a NOT function

Something like this (currently getting errors on this)

not(equal($pr_informal_extension_c, "Yes")

This has worked

not(equal($pr_informal_extension_c, "Yes"))

Hi Taufique,

You have mentioned that (this is a new dropdown so 99% of the records will have blank) - blank or empty is not equal to No, that is the reason this formula equal($pr_informal_extension_c, "No") did not work for the records which are having as empty. You have used the same formula with opposite conditions. In your latest formula, you are saying not equal to Yes which includes both Null, Empty, and No values. This is the reason it worked.

Hope this information helps :)

Thanks and Regards,

PK,

www.bhea.com

Hi Taufique,

You have mentioned that (this is a new dropdown so 99% of the records will have blank) - blank or empty is not equal to No, that is the reason this formula equal($pr_informal_extension_c, "No") did not work for the records which are having as empty. You have used the same formula with opposite conditions. In your latest formula, you are saying not equal to Yes which includes both Null, Empty, and No values. This is the reason it worked.

Hope this information helps :)

Thanks and Regards,

PK,

www.bhea.com

Thank you

For future reference

Would you know how would I create the formula to 

Equal

No or Null or Empty or No Values