Form Dynamic Rules Override
I have form rules that are conflicting with one another. I have a form that has "note lines" up to 4 total. In an effort to keep the form clean and concise, I am trying to create a rule to only show t...
Forum Discussion
Perhaps in this case you need to build formula fields to associate with your note entry fields; and instead of writing conflicting rules; have 1 rule for each Note field controlled by the formula.
Example:
Formula for Note Field 1:
If([1 Note]=true or [2 Notes]=true or [3 Notes=true] or [4 Notes]=true,true,false)
Formula for Note FIeld 2:
If([2 Notes]=true or [3 Notes=true] or [4 Notes]=true,true,false)
Formula for Note FIeld 3:
If([3 Notes=true] or [4 Notes]=true,true,false)
Formula for Note FIeld 4:
If([4 Notes]=true,true,false)
Then write your Form Rules like this:
Rule 1: When [Formula for Note Field 1]=true, Show & Require [Note Field 1]
Rule 2: When [Formula for Note Field 2]=true, Show & Require [Note Field 2]
etc.
etc.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
Example:
Formula for Note Field 1:
If([1 Note]=true or [2 Notes]=true or [3 Notes=true] or [4 Notes]=true,true,false)
Formula for Note FIeld 2:
If([2 Notes]=true or [3 Notes=true] or [4 Notes]=true,true,false)
Formula for Note FIeld 3:
If([3 Notes=true] or [4 Notes]=true,true,false)
Formula for Note FIeld 4:
If([4 Notes]=true,true,false)
Then write your Form Rules like this:
Rule 1: When [Formula for Note Field 1]=true, Show & Require [Note Field 1]
Rule 2: When [Formula for Note Field 2]=true, Show & Require [Note Field 2]
etc.
etc.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendMike,
If done in regular form rules they would look like this
Rule 1
if any
# of note lines = 1
# of note lines = 2
# of note lines = 3
# of note lines = 4
Action
Show Note field 1.
Rule 2
if any
# of note lines = 2
# of note lines = 3
# of note lines = 4
Action
Show Note field 2.
Rule 3
if any
# of note lines = 3
# of note lines = 4
Action
Show Note field 3.
Rule 4
if any
# of note lines = 4
Action
Show Note field 4.
You see I have 1 rule per field and not 1 rule per situation.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
If done in regular form rules they would look like this
Rule 1
if any
# of note lines = 1
# of note lines = 2
# of note lines = 3
# of note lines = 4
Action
Show Note field 1.
Rule 2
if any
# of note lines = 2
# of note lines = 3
# of note lines = 4
Action
Show Note field 2.
Rule 3
if any
# of note lines = 3
# of note lines = 4
Action
Show Note field 3.
Rule 4
if any
# of note lines = 4
Action
Show Note field 4.
You see I have 1 rule per field and not 1 rule per situation.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
I am going to have to think about this one harder because that still doesn't work.
Here are my rules so far. Each rule controls 3 fields (quantity, cost, and description/Note)
Thank you,
Mike Klausing
------Original Message------
Mike,
If done in regular form rules they would look like this
Rule 1
if any
# of note lines = 1
# of note lines = 2
# of note lines = 3
# of note lines = 4
Action
Show Note field 1.
Rule 2
if any
# of note lines = 2
# of note lines = 3
# of note lines = 4
Action
Show Note field 2.
Rule 3
if any
# of note lines = 3
# of note lines = 4
Action
Show Note field 3.
Rule 4
if any
# of note lines = 4
Action
Show Note field 4.
You see I have 1 rule per field and not 1 rule per situation.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
