Hey Team,
I am having some challenges with form rules / validation working correctly against a field that I am populating using a data variable.
Build Details:
- I have a form variable “StaffID” that I am populating from a value parsed in the form URL
- I then have a form data variable configured that is querying a SQL view that is filtered using the StaffID value
- On the form itself I have a field “StaffName” which is configured as “Required” and “Read Only” and to populate the StaffName Field I have a rule rule triggered if it is “Not Filled” to set the value based on what is returned in the data variable.
Now this all work great if the StaffID that I use in the URL is valid and returns a result, but if I use an invalid ID in the URL, the StaffName field will obviously be blank and you would expect that the form would throw an error saying that the SatffName field is required when the submit button is hit, but it does not… the form is submitted with a blank value for StaffName.
I have also tried using a submit rule to throw an error if StaffName is either “Not Filled” or equals “” but this fails to trigger as well.
I have tried a few different approaches using hidden service type fields and run counts to trigger the validation rules but so far I have not been able to find a working solution.
Thanks in advance for any help.