I am currently evaluating a workflow platform for my department, Joget is in my evaluation list.
I want to design a form with a Text Field where the input of this Text Field must be restricted to a field value of another table/form. I understand that this can be achieved via SelectBox, however, the respective look-up table/form will have 30K records, and it could grow up to 100K in couple of years. So using a SelectBox to restrict the input is not very practical.
The Text Field is equipped with basic validator tools (e.g. default & duplicate) which does not meet the requirement. Is there a way to write some custom codes to validate the input against another table/form when moving to next field in the same form, or upon clicking <Save As Draft> or <Complete> button?
Thanks in advance for sharing.