I am hoping someone has some ideas, as this has me stumped.
Our users are delegates on trainng programmes. They each have a unique User profile and in the User table we have unique ‘email’ turned on. When registering with us we have to offer double opt-in (a GDPR thing), the delegate also agrees T&C’s and then gets an intro pack. This all works well. Each user has a record in the User table.
But we have multiple courses, and our Delegates can return for other courses.
They apply for a course using a public form to collect their name and email.
This form is connected to Users table and creates new user accounts as described above… BUT
For returning clients I need a better solution.
What I want to happen is that on submission the Form recognises that the email is not unique (its been used before) and takes the returning users on a different path from new Registrants (because we don’t need to repeat GDPR and welcome pack), but do need to register them for the course.
However I can’t see how to do this.
What actually happens is that the Form tries to directly update the User table, but fails as it rejects the non unique address. Returning users just see an error
In the form, I’ve tried to use Validation rules, to check for the non-unique email, and this works. But validation rules have no action related to them other than a text messgae - I can’t use validation rules to do something different for returning users. The form will either validate or fail. Its no advance on where I was.
Other Form actions seem to happen after validation - so they won’t work for me either.
I guess I want to have an action thats started by a validation… but I can’t see how I can do that.