You are viewing this page out of context. To see it in the context it is intended please click here.

About This Page

Reply posted by Armand Tara on Wed 27 Mar 2002 in response to Form Validator R2.0

Can I use a field to specify required fields?

Hi,


First of all: I love this site!


I have many different forms with different required fields on my database and I
like to use just one Validate page or subform. I also want to hand it over to
administrators to deside which fields on which form should be required.


I would like to make a "ReqFields" for required fields and a "ReqFieldsText"
for description of required fields on the current form. The Value of these
fields comes from a view, which lookup to a administrator-defined form (see the
ex.)


ReqFields value:@DbLookup("" : "NoCache"; ""; "viewValidate"; Seminar;3)


ReqFieldsText value::@DbLookup("" : "NoCache"; ""; "viewValidate"; Seminar;4)


ReqFields are defined in the view like this:
@If(FirstNameValidate="*";"FirstName";"")+
@If(LastNameValidate="*";";"+"LastName";"")+
@If(CompanyValidate="*";";"+"Company";"")


ReqFieldsText are defined like this:
@If(FirstNameValidate="*";"Please enter your first name";"")+
@If(LastNameValidate="*";";"+"Please enter your last name";"")+
@If(CompanyValidate="*";";"+"Please enter your first company";"")


So if the administrator sets a "*" in field "FirstNameValidate" than the field
FirstName should be required.


Now, how can I refer to the Reqfields and ReqfieldsText on the form instead of
to specify each required field on the Validate Page?


Thank you for any help.
Armand Tara