Discussions

Expand all | Collapse all

Dynamic form rules stopped at first condition

Jump to Best Answer
  • 1.  Dynamic form rules stopped at first condition

    Posted 24 days ago
    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
    ------------------------------


  • 2.  RE: Dynamic form rules stopped at first condition
    Best Answer

    Posted 24 days 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
    ------------------------------



  • 3.  RE: Dynamic form rules stopped at first condition

    Posted 23 days ago
    Hi Mark,

    Problem solved, thank you

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



  • 4.  RE: Dynamic form rules stopped at first condition

    Posted 23 days ago
    :) thx for letting us know!

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



  • 5.  RE: Dynamic form rules stopped at first condition

    Posted 24 days ago
    Edited by Adam Keever 24 days 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
    ------------------------------



  • 6.  RE: Dynamic form rules stopped at first condition

    Posted 23 days 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
    ------------------------------