mac Date Validation

[jharper]

Hey! I'm somewhat of a novice at Filemaker so I'm wondering if this requirement is possible.

I have a table that stores events, an event's date doesn't necessarily have to be unique but it would be nice to alert the user if two dates are the same. 

 

Would some form of validation or script offer a solution?

 

For the logic, I'm thinking:

on input -> if date is equal to existing date in the table -> notify user (e.g. text turns a different colour/ dialog box) -> open matched records in a new window

 

If anyone could advise on how to assemble this then that would be great! 

[comment]

I believe the first step is to define a self-join relationship matching on the EventDate field and excluding the current record, e.g.:

Events::EventDate = Events 2::EventDate
AND
Events::EventID ≠ Events 2::EventID

The rest depends on how you prefer to alert the user. For example, you could show the related records in a portal, or format the field conditionally when:

Count ( Events 2::EventID )

or any number of other devices, incl. script triggers.

 

 

In any case, validation is not the proper tool to use here - if only because a validation error message would be (even more than usual) confusing to the user.

[jharper]

Fantastic! I did a little bit of research and implemented your suggestion - it works a treat! Thank you