I'm trying to resolve a script to check on duplicate records as data is entered. I'm using telephone numbers as the duplicated reference point.
This script works fine as a script but when I have it triggered by Script Trigger (on exiting Telephone Number) it goes nuts and sits in a loop. I have to force quit filemaker.
Set Field [ MPS Target Data Converted::Global; MPS Target Data Converted::telno ]
Go to Record/Request/Page [ Previous; Exit after last ]
If [ MPS Target Data Converted::Global = MPS Target Data Converted::telno ]
Show Custom Dialog [ Title: "Duplicate Record"; Message: "This is a duplicate record"; Buttons: “OK”, “Cancel” ]
Go to Record/Request/Page [ Last ]