Forum Discussion

BenGillihan's avatar
BenGillihan
Qrew Cadet
5 years ago

Field required based on value in another field

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
------------------------------
FormRule
Forms

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    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
    ------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    5 years ago
    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
    ------------------------------
    • BenGillihan's avatar
      BenGillihan
      Qrew Cadet
      5 years ago

      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!



      ------Original Message------

      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
      ------------------------------