Thread Details
  • State Suggested Answer
  • Replies 10 replies
  • Answers 2 answers
  • Subscribers 371 subscribers
  • Views 1848 views
  • Users 0 members are here
Forum Actions

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

Taufique Ahmed

Hi all

Hoping this is a simple one for the experts!

My aim is to have an Action button appear if the dropdown = No or blank

I have tried a number of different variations, (blank, null, space) but cannot make the button appear 

this is a new dropdown so 99% of the records will have blank

I have tried using the "or" function but I get syntax errors (this is likely how I am writing the forumla)

Parents
  • 0

    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

  • 0 in reply to Ramya Katram

    Thank you for the reply Slight smile

    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

  • 0 in reply to Taufique Ahmed

    potentially I could use a NOT function

    Something like this (currently getting errors on this)

    not(equal($pr_informal_extension_c, "Yes")

  • 0 in reply to Taufique Ahmed

    This has worked

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

  • 0 in reply to Taufique Ahmed

    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

Reply
  • 0 in reply to Taufique Ahmed

    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

Children