Forum Discussion

SyaefulBahri3's avatar
SyaefulBahri3
Qrew Trainee
6 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 ...
Forms
  • MarkShnier__You's avatar
    MarkShnier__You
    6 years ago
    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
    ------------------------------
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
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
    6 years ago
    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
    ------------------------------