I am a beginner to using the Filemaker program, so forgive me if this is a simple question! I am in the process of developing a Filemaker database for our company (relatively small contracting company) and I have several requests from people who want me to add alerts that will warn them if they are making a change to an important field.

I have a Filemaker manual and I understand the basics behind a Custom Dialog; but I am having trouble with the If statement. I basically want to say IF (Date Start) changes, Run Custom Dialog. Is there a calculation or tool I can use that will determine whether a date has changed up or down?

Thanks so much!

I believe you would need a Plug-IN like EventSript or ScriptFire to accomplish this.

Not if you reverse the order:

Untitled.fp7.zip

I'm sorry, I don't know what you mean by "reverse the order". I tried looking at the script steps but was not able to. Can you explain further?

... or even without a script.

Untitled2.zip

I meant instead of letting them change the field, THEN warning them - warn them FIRST.

Why can't you see the script steps?

Nice one, Daniele. But I wouldn't go that way. What if there are other fields on the layout that were modified (but not committed)? The only way to cancel is to revert the ENTIRE record.

... But I wouldn't go that way...

Neither I :

It was only a joke, I dislike the custom message coming from validation...and your objection is right.

Not if you reverse the order:

Thanks for posting comment i am really learning by these little examples. :smile2: