Notes Error: field didn't pass validation formula

Ciao,probabilly is a “foolish problem” but I can’t find where error is.

I’ve a Radiobutton field called “Settore”. On Imput Validation I write this code:

@If( Settore = “” ; @Failure (" Compilare ") ; @Success )

When I try to save the form without fill the field appear 3 messages:

"Field Contains Incorrect Value

Compilare"

I click OK and appears the second message

“Notes Error: field didn’t pass validation formula”

I click OK again and appears the third message

"Field Contains Incorrect Value

Compilare"

So, why appears the message “Notes Error: field didn’t pass validation formula”?

Where is the mistake?

Many thanks and have a nice weekend :slight_smile:

Subject: Notes Error: field didn’t pass validation formula

I’m confused…

You seem to want to validate the Settore field.

Then, when it validates this field “When I try to save the form (document) without fill the field” - it validates this field, just like you asked it to?

Validation can run either:

  1. Just when document is saved. Form is set to ‘Automatically Refresh fields’ is not on.

  2. When you fill in the fields. Form is set to 'Automatically Refresh fields.

You created validation, its working, what is the problem ??

Subject: RE: Notes Error: field didn’t pass validation formula

Ciao & thanks for the response,yes, its working. But I don’t understand why appear 3 messages. Normally appears only the first message and not “Notes Error: field didn’t pass validation formula”

I’ve other forms with the formula on Input Validation but appears only the message that I want and not the other.

Subject: Notes Error: field didn’t pass validation formula

Nicola,

I prefer to do my input validation in the QuerySave event. That way, I can have the LotusScript code gracefully stop trying to save if it encounters a problem.

With the regular input validation, if you have a button that is trying to save, it doesn’t gracefully stop and so you can easily get multiple prompts.

regards,

raphael

Subject: RE: Notes Error: field didn’t pass validation formula

Thanks Raphael,in effect I use only Formula Language because on LS I’m not an expert…but I’ll follow your advice.

Thanks again & Ciao

Nicola

Subject: Notes Error: field didn’t pass validation formula

If you want to get rid of all those messages, do the validation in QuerySave:

If trim$(Source.FieldGetText(“Settore”)) = “” then

msgbox " Compilare "

Continue = False

Exit Sub

end if

Subject: RE: Notes Error: field didn’t pass validation formula

The problem is that I have many fields with messages. But I think your suggestion is better than the way that I follow on my form.

Thanks

Ciao