Validating custom dialog input field

[messadua]

Hello everybody,

 

I have a database where the very first step is to add a new patient.

When the button is hit, a custom dialog box pops up asking for patient last name, first name and social security number (ssn).

The SSN is validated so to be unique and to show a warning message in case inserted patient has the same SSN as a previous one (i.e. the same patient has been created twice).

When everything goes well (that is, SSN is unique), the record is created in the current demographics table and also new records are created in related table as appropriate. The whole procedure is script driven.

When the same patient is inserted twice (i.e. the user is trying to insert a patient with the same SSN that has been already used), the warning message pops up appropriately, and when the used decide to "revert field" current record in the Demographics table is actually not created, but the script does not stop and creates empty records in the related tables.

Beyond the fact that the options in the warning message when the validation fails are not totally clear to me (Ok for "Revert field" but what about "Yes" or "No" ?), I have created an If statement so that

If not IsEmpty(fieldSSN)

then go ahead with the script

Else

Exit script.

Now, even when the user correctly decide to Revert field, the script goes on no matter what, and I cannot understand why...

 

Any help, as usual, will be greatl appreciated !

 

Diego

 

[bruceR]

The usual first step when asking a question about a script is to show the script.

 

Please create and attach a PDF copy of your script, or provide a copy or clone of your file.

Or; a screen shot.

[LaRetta]

Beyond the fact that the options in the warning message when the validation fails are not totally clear to me (Ok for "Revert field" but what about "Yes" or "No" ?) ...

Now, even when the user correctly decide to Revert field, the script goes on no matter what, and I cannot understand why...

 

Hi Diego,

 

Although Bruce is correct that seeing the script would help, it certainly must be because you are not checking to see whether the User selected Yes or No.  You do this by using an If[] and checking for Get ( LastMessageChoice).  So an example might be:

 

Show Custom Dialgog [ bla bla ; "Yes" ; "No" ]

If [ Get ( LastMessageChoice ) = 1 // user selected yes ]

... do this

Else

// user selected NO

... do this other thing

End If

[Fitch]

So we're talking about two dialog boxes: 1) the initial custom dialog, and 2) the field validation fail dialog.

 

For the first one, you may want to experiment with using global fields for the dialog and scripting a Find for duplicates, rather than creating a new record and then reverting it. This may obviate the issue with dialog 2.

 

You have FM Advanced -- turn on script debugger and show the data viewer. You'll see exactly what's going on.