Hi Everyone,

I am new using the filemaker script/calculation, I don’t know to validade a field if someone click at the “CustomerNumber” field a message box should show up and asking “Are you sure you want to make changes at this record?” If they click “OK” it is allow to make change at that field and if they click “No” changes are not allowed.

Any help will be appreciated and thank you in advance.

Sandy

Hi Sandy,

From layout mode, select Layouts > Layout Setup and uncheck 'Save record changes automatically.'

I believe that's what you are asking. If not then we will need more information.

LaRetta

You could define the field as a button that runs a script like:

Show Custom Dialog [ Message: "Are you sure..."; Buttons: “OK”, “Cancel” ]

If [ Get (LastMessageChoice) = 1 ]

Go to Field [ Yourfield ]

End If

Hi Sandy,

You will also want to remove that field from the tab order (if you haven't already). Otherwise someone could tab to it, bypass the script and change it freely.

LaRetta

That's a good point, which I took for granted - thanks for adding that. I usually make the field non-enterable in Browse mode, which also makes it skip its tab order. You could also add the button itself to the tab order, so you can tab into it and fire the script by pressing Return.