Jump to content

Making a field reqd based on the value of another


This topic is 6485 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am trying to make a field required but only if the value of another field is 'x".

Scenario - this is an issues submission form for production support of a much larger enterprise application - the field in question is "Description of Requirement". This should be a required field only if the value of "Issue Type = Enhancement".

I am a beginner, sorry for the ignorance.

Thanks in advance.

Jam

FileMaker Version: 6

Platform: Windows XP

Link to comment
Share on other sites

Try validating based on the calculation

IssueType <> "Enhancement" or not IsEmpty(DescriptionOfRequirement)

It's a good idea not to use spaces in field names. Either concatenate the words with capital letters or use underscores.

NOTE: in the validation calculation, deselect 'Validate only if field has been modified'.

Link to comment
Share on other sites

  • Newbies

Thanks - It worked exactly as I wanted it to. To go one step further, can I limit which password/group can bypass this? i.e. SalesOps shouldn't have to detail the requirement when going through the list, however anyone else, i.e. the EndUser should.

FileMaker Version: 6

Platform: Windows XP

Link to comment
Share on other sites

This topic is 6485 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.