So, I have done a massive amount of research, and have looked through most of these posts as well as other sites. I designed a database for my workplace and I'm running into some problems.

My dilemma: I want to force a user to input further detailed information into the "other" field but only if someone checks the box "Animal" (Animal Complaint). This is something I'm doing for my workplace and the field keeps getting missed. I know about the IsEmpty script, but I don't want it all of the time. Could anyone help me get into the right direction?

FYI, I'm pretty good with FileMaker Pro, but need baby steps when it comes to new scripts.

Thank you in advance for anyone able to help - see picture for a better image of what I am trying to illustrate.

you can use a field level validation for the other field. not IsEmpty (other) and PatternCount (CallTpye; "Animal" ) or not PatternCount (CallTpye; "Animal" )

Thank you so much for the advice thus far. I know it may be simplistic, but for me it is somewhat difficult.

For the checkboxes, it is field called "calltype" and the other field is "typeother"

For what I typed so far, it is kicking back the message on every call I click on - rather it is animal or another type. Is there a way to make it only do this for just the one I click? I may just have them reversed or something.

Here is what I have trying to use in the field validation:

IsEmpty (typeother) & PatternCount (calltype; "Animal" )

Thanks in advance!!

Also, just FYI, I tried this in both field validations - each separately to see if it worked.

not IsEmpty (typeother) & PatternCount (calltype; "Animal" )

-Dustin_02

LaRetta is correct. You used the & sign and not the logical AND operator.

However, after looking at this again a second time, I think that a better calc would be:

NOT ( NOT IsEmpty ( FilterValues ( CallTpye; "Animal" ) ) AND IsEmpty ( Self ) )

Also make sure that your validation is set to Always and uncheck the 'Validate only if field has been modified' checkbox.