Skip to main content
Solved

Dynamic form rules stopped at first condition

  • November 19, 2019
  • 0 replies
  • 61 views
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
------------------------------

Best answer by MarkShnierYou

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Registered
  • November 19, 2019
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
------------------------------
Terms & ConditionsAccessibility statement