Need validation suggestion

HCL Domino Domino Forum
1

Requirement:

Form1 has 60 Fields. Field1… Field60. Each Field1… Field60 is Dialog List field. User selects the value from the dialog list for each field. On exit of the field, user should get a message saying that “This field value is already selected”, if the selected value for that field is already selected earlier.

I thaught of doing following way,

  1. Input validation of each field, but checking and comparing value with 60 field values.

  2. On Exiting event of Field, and again checking and comparing value with 60 field values.

  3. Perform check for all 60 field values, in QuerySave upon user saves the document.

Is there a better way to check the duplicate values and throw a validation message.

Thanks

MS

2

Subject: Need validation suggestion

Why not make the fields available options computed so that your users can’t select duplicate values?

Why throw an error when you can prevent it.

3

Subject: RE: Need validation suggestion

Thanks for your kind reply. I am going to check that URL and shall update you if I don’t get it.

Peter:

I did not understand your response.

Thanks

MS

4

Subject: RE: Need validation suggestion

It might be too slow to recalculate 60 keyword lists, each with a formula that refers to 59 other fields, every time the user enters a value. Not to mention the long validation formulas which would also trigger for each field.

It might be better to use LotusScript code in Querysave, since that can quickly scan all the fields and build a list of the selected values, to confirm uniqueness.

I would not check for uniqueness on field exit. That just makes it difficult for the user.

Might also consider using table editing tool found here: http://www-10.lotus.com/ldd/sandbox.nsf/0/816d64935ee8842485256c680051b592?OpenDocument which might give better performance.