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
    Yup, I got what you trying to say but, unfortunately, business wants the above implementation, if this is possible in Appian or not? Becoz the existing legacy system already heavily used similar form validation but not in Appian and they are migrating to Appian now and don't want to spend more time on changing the current database enabled validation.
    pros/cons/wrong design pattern/performance hit is something the business aware of and they are ok with it.:-)
Reply
  • 0
    Certified Senior Developer
    Yup, I got what you trying to say but, unfortunately, business wants the above implementation, if this is possible in Appian or not? Becoz the existing legacy system already heavily used similar form validation but not in Appian and they are migrating to Appian now and don't want to spend more time on changing the current database enabled validation.
    pros/cons/wrong design pattern/performance hit is something the business aware of and they are ok with it.:-)
Children
No Data