Jump to content

force field entry


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

Recommended Posts

  • Newbies

My apologies for not taking time to search through previous posts for answers - time is a little precious and I need a solution.

I have a field that is YES/NO. If the selectin is YES I would like to force the user to enter data in a text field.

I'm using FMP 6 - which I do so rarely so I'm a bit of a novice.

thanks

Link to comment
Share on other sites

Hi konni,

Add this validation to your yes/no field, in this example Select. Unclick 'Validate only if field has been modified."

Select <> "Yes" or not IsEmpty(TextField)

Click 'Strict' and specify a message "If YES, you must enter something in Text."

This can be written other ways also; I have a suspicion XOR might be used here, right JT?

LaRetta wink.gif

Link to comment
Share on other sites

  • Newbies

OK - I'm misreading your instruction, sorry. I get an error alert box.

SO...

I have a pop up field called AVAILABLE with 2 options = YES/NO

I have a text field called DETAIL

In options for field (define) I check Validated by calc - Specify

then... type in the following?

Select <> "Yes" or not IsEmpty(DETAIL)

and so you can probably see I'm doing something dumb - yes?

Link to comment
Share on other sites

Not to worry, Konni, I should have said YesNoField instead of Select so it was very clear ...

AVAILABLE <> "Yes" or not IsEmpty(DETAIL)

... validation applied to your Available field. When working in calc boxes, it's always safest to double-click your field to insert them into the line just to be sure they are right. Do I follow my own advice? Nope, I type them. And welcome to FM Forums, by the way!! smile.gif

LaRetta

Link to comment
Share on other sites

Hi Konni,

I am the Queen of Foible ... most of my 1,000+ posts have been questions! crazy.gif And hey ... that's my SERIOUS face; you should see it when I'm really happy!! grin.gif

Let us know if you get stuck again.

LaRetta

Link to comment
Share on other sites

This topic is 6605 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
×
×
  • Create New...

Important Information

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