Field required based on value in another field

Question

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

markshnier__you · Answer

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

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?&nbsp; &nbsp;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 LarsonPaasporterWestlake OH------------------------------

bengillihan · Answer

Ugh, super simple.&nbsp; Thanks guys.&nbsp; I am surprised I couldn't figure that out myself of find it in the search.&nbsp; 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?&nbsp; &nbsp;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 LarsonPaasporterWestlake OH------------------------------

Forum Discussion

Field required based on value in another field