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.

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)

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.

...

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

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!