Conditional validation for view builder
A system for conditional validation in forms includes at least one processor, and at least one memory coupled to the at least one processor and configured to store executable instructions. The executable instructions, when executed by the at least one processor, cause the at least one processor to visually present an expression input area for accepting user input of at least one expression defining at least one condition for controlling a property of a first field of a form in a configuration mode, generate the at least one condition corresponding to the at least one expression, and store the generated at least one condition with the form. The at least one expression comprises at least one of a logic expression or a mathematic expression.
1. A system for conditional validation in forms, the system comprising:
at least one processor; and
at least one memory coupled to the at least one processor and configured to store executable instructions that, when executed by the at least one processor, cause the at least one processor to
visually present an expression input area for accepting user input of at least one expression defining at least one condition for controlling a property of a first field of a form in a configuration mode,
visually present a list of selectable properties of the first field,
in response to user selection of the property from the list of selectable properties, visually present a plurality of parameters and a selectable item corresponding to the expression input area,
generate a condition corresponding to a set of user inputs for the plurality of parameters, wherein the plurality of parameters comprises first through fourth parameters, and wherein the executable instructions, when executed by the at least one processor, cause the at least one processor to
in response to user selection of the first parameter, visually present a first list of selectable property values of the property of the first field,
in response to user selection of the second parameter, visually present a second list of one or more selectable fields including a second field,
in response to user selection of the third parameter, visually present a third list of one or more selectable relations,
in response to user selection of the fourth parameter, visually present an input area or a fourth list of one or more selectable values, and
generate the condition based on
a selected property value from the first list,
the second field selected from the second list,
a selected relation from the third list, and
a selected value from the fourth list or an input value received through the input area, and
store the generated condition corresponding to the set of user inputs with the form.
2. The system of claim 1 , wherein
the first field and the second field are in a same table of a database, or
the first field and the second field are in different tables of the database, or
the second field is in the same form as the first field, or
the second field is in a further form different from the form containing the first field.
3. The system of claim 1 , wherein
the executable instructions, when executed by the at least one processor, further cause the at least one processor to
add a new field selected from a visually presented list of available fields to the form.
4. The system of claim 1 , wherein
the at least one expression comprises a plurality of expressions connected by one or more logic operands, and
the at least one condition comprises a plurality of conditions each defined by a corresponding expression among the plurality of expressions.
5. The system of claim 4 , wherein
the plurality of expressions comprises at least one mathematical expression.
6. The system of claim 1 , wherein
the executable instructions, when executed by the at least one processor, further cause the at least one processor to
in response to user selection of the selectable item corresponding to the expression input area, visually present the expression input area instead of one or more of the plurality of parameters.
7. The system of claim 1 , wherein
the property of the first field comprises one selected from the group consisting of
a mandatory property which, when the form is in an execution mode and in response to whether the at least one condition defined by the at least one expression is satisfied or not, configures the first field as mandatory to require data to be entered in the first field,
an editable property which, when the form is in the execution mode and in response to whether the at least one condition defined by the at least one expression is satisfied or not, configures the first field as editable to permit data to be entered in the first field,
a visible property which, when the form is in the execution mode and in response to whether the at least one condition defined by the at least one expression is satisfied or not, causes the first field to be visible in the form, or
a background property which, when the form is in the execution mode and in response to whether the at least one condition defined by the at least one expression is satisfied or not, causes the first field to be visibly presented in a predetermined format distinctive from other fields in the form.
8. The system of claim 1 , wherein
the executable instructions, when executed by the at least one processor, further cause the at least one processor to
render the form in an execution mode in which the first field has different visually presented states depending on whether the at least one condition defined by the at least one expression is satisfied or not.
9. The system of claim 1 , wherein
the property of the first field comprises one selected from the group consisting of
a mandatory property which, when the form is in an execution mode and in response to whether the at least one condition defined by the at least one expression is satisfied or not, configures the first field as mandatory to require data to be entered in the first field,
an editable property which, when the form is in the execution mode and in response to whether the at least one condition defined by the at least one expression is satisfied or not, configures the first field as editable to permit data to be entered in the first field, and
a background property which, when the form is in the execution mode and in response to whether the at least one condition defined by the at least one expression is satisfied or not, causes the first field to be visibly presented in a predetermined format distinctive from other fields in the form.
10. A method of conditional validation in forms, said method performed at least in part by at least one processor and comprising:
visually presenting an expression input area for accepting user input of at least one expression defining at least one condition for controlling a property of a first field of a form in a configuration mode,
visually presenting a list of selectable properties of the first field,
in response to user selection of the property from the list of selectable properties, visually presenting a plurality of parameters and a selectable item corresponding to the expression input area,
generating a condition corresponding to a set of user inputs for the plurality of parameters, wherein the plurality of parameters comprises first through fourth parameters, and wherein said generating comprises:
in response to user selection of the first parameter, visually presenting a first list of selectable property values of the property of the first field,
in response to user selection of the second parameter, visually presenting a second list of one or more selectable fields including a second field,
in response to user selection of the third parameter, visually presenting a third list of one or more selectable relations,
in response to user selection of the fourth parameter, visually presenting an input area or a fourth list of one or more selectable values, and
generating the condition based on
a selected property value from the first list,
the second field selected from the second list,
a selected relation from the third list, and
a selected value from the fourth list or an input value received through the input area, and
storing the generated condition corresponding to the set of user inputs with the form.
11. The method of claim 10 , wherein
said storing comprises updating a JavaScript Object Notation (JSON) configuration of the form with the generated condition, without writing an Extensible Markup Language (XML) or Hyper Text Markup Language (HTML) file.
12. The method of claim 10 , wherein
said generating and said storing require no coding by a user.
13. The method of claim 10 , further comprising:
rendering the form in an execution mode in which the first field has different visually presented states depending on whether the at least one condition defined by the at least one expression is satisfied or not.
14. The method of claim 13 , wherein
said rendering is performed without linking the form with a database including the first field.
15. A computer program product, comprising a non-transitory, tangible computer readable storage medium storing a computer program that, when executed by at least one processor, causes the at least one processor to:
visually present an expression input area for accepting user input of at least one expression defining at least one condition for controlling a property of a first field of a form in a configuration mode,
visually present a list of selectable properties of the first field,
in response to user selection of the property from the list of selectable properties, visually present a plurality of parameters and a selectable item corresponding to the expression input area,
generate a condition corresponding to a set of user inputs for the plurality of parameters, wherein the plurality of parameters comprises first through fourth parameters, and wherein the computer program, when executed by the at least one processor, cause the at least one processor to
in response to user selection of the first parameter, visually present a first list of selectable property values of the property of the first field,
in response to user selection of the second parameter, visually present a second list of one or more selectable fields including a second field,
in response to user selection of the third parameter, visually present a third list of one or more selectable relations,
in response to user selection of the fourth parameter, visually present an input area or a fourth list of one or more selectable values, and
generate the condition based on
a selected property value from the first list,
the second field selected from the second list,
a selected relation from the third list, and
a selected value from the fourth list or an input value received through the input area, and
store the generated condition corresponding to the set of user inputs with the form.