I have a form/view that is SO heavy in database calls, that users are complaining on how long it takes.
I have a form value that needs to be validated against a database to see if the value exists. There are thousands of possibilities for this value. We have done what we can to try and widdle down the error rate for this value, but still get occasional bad values later down the line.
Does anyone know how to do a function or data validation within a workflow step? I dont mind the validation being done after form submittal, and if data validation does not pass, that the workflow go a different direction.