Script to Check data

[philgavin]

Im New to FM pro, using version 7.

Id like to set up a method that checks that the salesman enters data into cetain fields, and returns to that field until he does complete it.

does anyone know of a library of scripts that i can peruse and adapt to suit.

Cheers guys & gals

Hope you can/will help

Philgavin

[philgavin]

Im New to FM pro, using version 7.

Id like to set up a method that checks that the salesman enters data into cetain fields, and returns to that field until he does complete it.

does anyone know of a library of scripts that i can peruse and adapt to suit.

Cheers guys & gals

Hope you can/will help

Philgavin

[philgavin]

Im New to FM pro, using version 7.

Id like to set up a method that checks that the salesman enters data into cetain fields, and returns to that field until he does complete it.

does anyone know of a library of scripts that i can peruse and adapt to suit.

Cheers guys & gals

Hope you can/will help

Philgavin

[DykstrL]

Here's a quick validation script that I use:

Got to field [Field1]

If [isempty(Field1)]

Beep

Show Custom Dialog [Title:"Record Error";Message:"You did not enter anything in " & Get (ActiveFieldName);Buttons:"OK"

Exit Script

Endif

Got to field [Field2]

If [isempty(Field2)]

Beep

Show Custom Dialog [Title:"Record Error";Message:"You did not enter anything in " & Get (ActiveFieldName);Buttons:"OK"

Exit Script

Endif

{Repeat in the script for each field to check}

{Mark for validation} Set field(Valid),1

I usually attach the script to a Pseudo "Save" button on the layout and I do not let the user do anything else until the record is validated. I track the validation by setting a numeric field to 1 if the validation passes.

The validation can also be done with a calculation, but is a little more difficult to give feedback to the user as to what is missing.

[DykstrL]

Here's a quick validation script that I use:

Got to field [Field1]

If [isempty(Field1)]

Beep

Show Custom Dialog [Title:"Record Error";Message:"You did not enter anything in " & Get (ActiveFieldName);Buttons:"OK"

Exit Script

Endif

Got to field [Field2]

If [isempty(Field2)]

Beep

Show Custom Dialog [Title:"Record Error";Message:"You did not enter anything in " & Get (ActiveFieldName);Buttons:"OK"

Exit Script

Endif

{Repeat in the script for each field to check}

{Mark for validation} Set field(Valid),1

I usually attach the script to a Pseudo "Save" button on the layout and I do not let the user do anything else until the record is validated. I track the validation by setting a numeric field to 1 if the validation passes.

The validation can also be done with a calculation, but is a little more difficult to give feedback to the user as to what is missing.

[DykstrL]

Here's a quick validation script that I use:

Got to field [Field1]

If [isempty(Field1)]

Beep

Show Custom Dialog [Title:"Record Error";Message:"You did not enter anything in " & Get (ActiveFieldName);Buttons:"OK"

Exit Script

Endif

Got to field [Field2]

If [isempty(Field2)]

Beep

Show Custom Dialog [Title:"Record Error";Message:"You did not enter anything in " & Get (ActiveFieldName);Buttons:"OK"

Exit Script

Endif

{Repeat in the script for each field to check}

{Mark for validation} Set field(Valid),1

I usually attach the script to a Pseudo "Save" button on the layout and I do not let the user do anything else until the record is validated. I track the validation by setting a numeric field to 1 if the validation passes.

The validation can also be done with a calculation, but is a little more difficult to give feedback to the user as to what is missing.

[Rob 7 Collins]

From the help system:

Defining field validation

You can select validation options to ensure that data is entered into a field correctly. When validation options are selected, FileMaker Pro displays a message if you enter data incorrectly.

...

4.

Select an existing field or define a new one.

5.

Click Options (or double-click the field name).

6.

In the Options for Field dialog box, click the Validation tab.

7.

Select validation options for the field.

[Rob 7 Collins]

From the help system:

Defining field validation

You can select validation options to ensure that data is entered into a field correctly. When validation options are selected, FileMaker Pro displays a message if you enter data incorrectly.

...

4.

Select an existing field or define a new one.

5.

Click Options (or double-click the field name).

6.

In the Options for Field dialog box, click the Validation tab.

7.

Select validation options for the field.

[Rob 7 Collins]

From the help system:

Defining field validation

You can select validation options to ensure that data is entered into a field correctly. When validation options are selected, FileMaker Pro displays a message if you enter data incorrectly.

...

4.

Select an existing field or define a new one.

5.

Click Options (or double-click the field name).

6.

In the Options for Field dialog box, click the Validation tab.

7.

Select validation options for the field.

[philgavin]

Cheers for that, I had nearly got there on my own, but didnt use the "goto field". thanks again,

Phil

[philgavin]

Cheers for that, I had nearly got there on my own, but didnt use the "goto field". thanks again,

Phil

[philgavin]

Cheers for that, I had nearly got there on my own, but didnt use the "goto field". thanks again,

Phil