Question regarding forms and field validation

Certified Senior Developer

need a quick solution on one of the problem statement in Quantum
Form -> fields validation to be done from the pre-configured table validation queries
example:-
- lets assume a form has 5 fields
- 5 fields has 5 different validations
- validations are stored in the database in the form of 5 distinct queries
1. Form Name
2. Field Name
3. Validation ( queries, which is stored in validation table against each field in the below form:
ex : to validate age field the query in the db : select age from table1 where formName = "form1"
and age > 40)
(there will be 5 different, queries like this for each form elements)


Question:-

Is there a ready made solution in Apian for ...

OriginalPostID-191735

OriginalPostID-191735

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    Yes, you are correct. For example, if there a form field named [Age] in the Interface and the validation for the field age, the user should restrict enter age less than 18.
    The database will have a text query like for the [Age] field
    "select 1 from table where age>=18) - the query returns true or false OR 0 or 1 ,
    the validation should fire if the end user enter age less than 18.
    Please feel free to ask if you have further questions
Reply
  • 0
    Certified Senior Developer
    Yes, you are correct. For example, if there a form field named [Age] in the Interface and the validation for the field age, the user should restrict enter age less than 18.
    The database will have a text query like for the [Age] field
    "select 1 from table where age>=18) - the query returns true or false OR 0 or 1 ,
    the validation should fire if the end user enter age less than 18.
    Please feel free to ask if you have further questions
Children
No Data