Gray out box
Is there a way to gray out or remove a field that does not have any content associated with the record? I have the Orientation which may be blank depending on the previous drop down picked.
...
Forum Discussion
Thanks Mark. I was thinking of a dynamic but I couldn't find a way to say if there are no choices to chose from then hide.
There are hundreds of options that the value in this field depends on. So would I need to go through each option - For example: "If Point of Discover = Cross Butt, Then Hide Orientation?
------------------------------
Sarah Burres
------------------------------
There are hundreds of options that the value in this field depends on. So would I need to go through each option - For example: "If Point of Discover = Cross Butt, Then Hide Orientation?
------------------------------
Sarah Burres
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendYou have two choices.
1. Make a single form rule to hide that field.
IF Multiple conditions are true:
ANY of the following
then list all your conditions and the action is to hide and them typically remember to check the checkbox at the bottom of the form to collapse the space when hiding.
2. If the rules are too complex with nested ANDs and ORs, then the other way is to make a formula field called [hide field X]. Then have a single Dynamic Form Rule based on that field. If you go that route, then the formula field must be on the form, even if hidden by a form rule. Else the form will not dynamically recalculate it while you are working on the form doing data entry.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
1. Make a single form rule to hide that field.
IF Multiple conditions are true:
ANY of the following
then list all your conditions and the action is to hide and them typically remember to check the checkbox at the bottom of the form to collapse the space when hiding.
2. If the rules are too complex with nested ANDs and ORs, then the other way is to make a formula field called [hide field X]. Then have a single Dynamic Form Rule based on that field. If you go that route, then the formula field must be on the form, even if hidden by a form rule. Else the form will not dynamically recalculate it while you are working on the form doing data entry.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
This sounds much easier. Thank you Mark!