Script for finding empty fields

[MarcBauwens]

I guess this is easy and that the question has already been asked but I can't see how to do it.

I have a client records database with the usual fields like name, address, etc. What I want is that when you trigger the submission script it looks for fields that should be filled with info but are empty and then signals it through a dialog box.

For example : the fields 'Address' and 'First name' are empty!

Anyone an idea how to tackle this?

Thanks in advance.

[IdealData]

Look at the FIELD VALIDATION when defining your fields (in the OPTIONS). You can set the conditions that the contents of a field must have before accepting the data. viz.

Address <> ""

(Address is not equal to nothing)

[MarcBauwens]

Yes but the problem with that is that I have multiple dialog boxes popping up if the user forgets multiple fields.

The idea is more that at the end of filling out the form, the user clicks a submit button that triggers a script which looks if there are mandatory fields that are empty. If there are empty fields, the user gets a dialog box telling him which boxes are emoty and that have to be filled out before the record is valid.

[Genx]

...

Why would you have multiple dialog boxes, why not use one?

e.g.

If[isEmpty(Address) or IsEmpty(Name) or IsEmpty(State)]

Show Custom Dialog[Title: "Missing Information" ; "You have failed to fill in the following fields:¶¶ " & If(IsEmpty(Address) ; "Address¶" ) & If(IsEmpty(Name) ; "Name¶" ) & If(IsEmpty(State) ; "State¶" ) ]

End If

... you get the gist

[MarcBauwens]

Yup! that's the way to go!

Thanks for the heads-up!

It was right in front of me but I failed to see the light!

Thanks again!