Subtotal: $164,783.00
I have a live forms instance for registration that sends an email to the user. If the user enters a duplicate display name or a password that doesn't meet the requirement, the email is sent even though the action "execute if all previous actions are successful" is selected. The entries also show up in the submissions.
The criteria is not checked until form submission. Is there a way to check the fields prior to form submission? So, If a duplicate display name is entered they are prevented to go on to the next field? I tried to use sql form validation but was unable to get it to work.
Also, does form validation actions carry over to registration actions? In other words, if I choose an action on registration that only executes if all prior actions are successful do it include form validation?
Any other suggestions?
Simply add "Bind or update a single form field via SQL Query" action to check user exist or not in Users table and add condition accordingly in email action.
Using the Bind or update doesn't work as I am not trying to update another field. I tried to using on form validation/execute SQL to see if a display name already exists i.e.: If SQL result not equal [DisplayName] but could not get it to work.
Please disregard previous comment. I created a hidden field called checkexisting and updated it if displayname already exists. Then on email I set the action to if checkexisting is empty. I think this is what you were suggesting.
Yes.