force field entry

[konni]

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

[LaRetta]

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

[konni]

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?

[LaRetta]

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

LaRetta

[konni]

Thanks LaRetta,

I was thinking of 'select' as a function - wasn't in the list, should have twigged. Syntax is also not one of my strong points either. My forte is digital graphhttp://www.fmforums.com/threads/images/icons/grin.gifics.

Appropriate avatar you've got - you were already chuckling at my foible. javascript:void(0)

[konni]

oh dear - quit while I'm ahead I think

the link is irrelevant - I was just trying to add a grin.

[LaRetta]

Hi Konni,

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

Let us know if you get stuck again.

LaRetta

[comment]

Gotta love the title of this thread - a quote from the Star Wars manual?

All that's missing is Ender's avatar.