Discussions

Expand all | Collapse all

Gray out box

  • 1.  Gray out box

    Posted 18 days ago
    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. 


    ------------------------------
    Sarah Burres
    ------------------------------


  • 2.  RE: Gray out box

    Posted 18 days ago
    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
    ------------------------------



  • 3.  RE: Gray out box

    Posted 18 days ago
    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
    ------------------------------



  • 4.  RE: Gray out box

    Posted 18 days ago
    Edited by Mark Shnier (YQC) 18 days ago
    You 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
    ------------------------------



  • 5.  RE: Gray out box

    Posted 18 days ago

    This sounds much easier.  Thank you Mark!