Gray out box

Question

Is there a way to gray out or remove a field that does not have any content associated with the record?&nbsp; I have the Orientation which may be blank depending on the previous drop down picked.&nbsp;
------------------------------Sarah Burres------------------------------

markshnier__you · Answer

You can put in a Dynamic form rule to decide when to show or hide the field. Look for the tab on Form Properties called Dynamic Form Rules. Often you have two Actions on the Rule like

when some conditions are true

show [field 1]
require [ field 1]

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

sarahburres · Answer

Thanks Mark.&nbsp; 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.&nbsp;&nbsp;There are hundreds of options that the value in this field depends on.&nbsp; So would I need to go through each option - For example: "If Point of Discover = Cross Butt, Then Hide Orientation?------------------------------Sarah Burres------------------------------

markshnier__you · Answer

You have two choices.1. Make a single form rule to hide that field.IF Multiple conditions are true:ANY of the following&nbsp;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].&nbsp; Then have a single Dynamic Form Rule based on that field.&nbsp; If you go that route, then the formula field must be on the form, even if hidden by a form rule.&nbsp; Else the form will not dynamically recalculate it while you are working on the form doing data entry.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

sarahburres · Answer

This sounds much easier.&nbsp; Thank you Mark! &nbsp; &nbsp;

Forum Discussion

Gray out box

Related Content

Formula URL Button to Open New Form and Check a Box

Nested API Button open form to add input, check box and redirect back to original form

Check box doesn't always show in my table

Sending data to Box via CSV?

Working with %%rid%% and checking a box