Need help with calculation

[PHP2005]

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

[LaRetta]

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

[comment]

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

[LaRetta]

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

[comment]

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.