Discussions

Expand all | Collapse all

Field required based on value in another field

  • 1.  Field required based on value in another field

    Posted 12-27-2019 17:20
    Is it possible to make a field conditionally required?  If a job we are working on requires us to pay prevailing wage, we want to require the user to enter in the name of the county where the work will be done.  It is not required if the job is not prevailing wage.  So if "Prevailing Wage" =Yes then "county" is required.  If "Prevailing Wage" =No then "county" is not required.

    Thanks.


    ------------------------------
    Ben Gillihan
    ------------------------------


  • 2.  RE: Field required based on value in another field

    Posted 12-27-2019 17:25
    The usual way to do this is via Dynamic Form Rules.  When you are working with the form properties, there is a tab there for Dynamic Form Rules https://help.quickbase.com/user-assistance/form_rules.html

    If you also need to enforce this in Grid Edit then there is a slightly more advanced technique called Custom Data Rules, Post back if you need to enforce in Grid Edit and need to help to set up a Custom data Rule.  The bottom of this post here describes that  https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=178de5a6-ccb2-40eb-b39d-888a4cbe2925&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer&ReturnUrl=%2fbrowse%2fallrecentposts .

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



  • 3.  RE: Field required based on value in another field

    Posted 12-27-2019 17:28
    Ben,

    Assuming you have people entering the data into a form then the answer is yes.

    Here is a screen shot of a form rule where you would set the values to require entering the data.



    Where are you going to get the County data?   Will it be a Text field so they can type the name or will you have a Table of Counties and connect it via a relationship?

    Your follow on reporting will vary significantly based upon what you let the user do next.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 4.  RE: Field required based on value in another field

    Posted 12-27-2019 17:35

    Ugh, super simple.  Thanks guys.  I am surprised I couldn't figure that out myself of find it in the search.  Have a great weekend!