Skip to main content
Question

Field required based on value in another field

  • December 27, 2019
  • 0 replies
  • 73 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
    Forum|alt.badge.img+15
    • DonLarson
    • Registered
    • December 27, 2019
    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
    ------------------------------
      Terms & ConditionsAccessibility statement