Forum Discussion

SyaefulBahri3's avatar
SyaefulBahri3
Qrew Trainee
5 years ago
Solved

Dynamic form rules stopped at first condition

Hi all,

I have a dynamic form rule as below

When Requester is equal to Finance
and all of the following condition are true
Estimated price <= 2000
Action display a message You're over budget estimated

The problem is the rule is kind of skipping the second condition "and all of the following condition are true
Estimated price <= 2000"

The display message just appears after I choose the requester field

What I've missed here?. Can you please show me some direction?

The idea is to show the message if the requester is finance and estimated price is <=2000

Many thanks




------------------------------
Syaeful Bahri
------------------------------
  • maybe try adding a second condition that 

    Estimated price is not equal to (blank).

    Maybe that will prevent the message from firing prematurely, when the user has not yet entered the estimated price and the field is still blank.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------

5 Replies

  • maybe try adding a second condition that 

    Estimated price is not equal to (blank).

    Maybe that will prevent the message from firing prematurely, when the user has not yet entered the estimated price and the field is still blank.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • SyaefulBahri3's avatar
      SyaefulBahri3
      Qrew Trainee
      Hi Mark,

      Problem solved, thank you

      ------------------------------
      Syaeful Bahri
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        :) thx for letting us know!

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------
  • Mark is correct.

    Here another way to achieve your goal. Create a formula checkbox field and use this formula:
    If([Requester]="Finance" and [Estimated price]<=2000,true,false)​


    Then use this dynamic form rule where [message] is the name of the formula check box field:


    Here is the result:






    ------------------------------
    Adam Keever
    ------------------------------
    • SyaefulBahri3's avatar
      SyaefulBahri3
      Qrew Trainee
      Hi Adam,

      At first glance, I kind of thinking this is a bug with QB. It's worked before. Thank you for your solution, I've add that to my QB tips and trick list.

      Kind regards

      ------------------------------
      Syaeful Bahri
      ------------------------------