March 2, 200520 yr 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
March 2, 200520 yr 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
March 2, 200520 yr Author 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?
March 2, 200520 yr 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
March 2, 200520 yr Author Newbies 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)
March 2, 200520 yr Author Newbies oh dear - quit while I'm ahead I think the link is irrelevant - I was just trying to add a grin.
March 2, 200520 yr 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
March 2, 200520 yr Gotta love the title of this thread - a quote from the Star Wars manual? All that's missing is Ender's avatar.
Create an account or sign in to comment