Discussions

Back to 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 11-19-2019 07:28
    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 11-19-2019 07:57
    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
    ------------------------------

    Original Message


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

    Posted 11-19-2019 20:48
    Hi Mark,

    Problem solved, thank you

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

    Original Message


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

    Posted 11-19-2019 20:48
    :) thx for letting us know!

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

    Original Message


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

    Posted 11-19-2019 09:07
    Edited by Adam Keever 11-19-2019 09:09
    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
    ------------------------------

    Original Message


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

    Posted 11-19-2019 20:50
    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
    ------------------------------

    Original Message