Applying the DB Save action if there are no duplicates in DB

Hi,

I have created a Chronoform data entry form for a client who is concerned that there may be duplicates as time goes on. The form adds details on Name, Email and MobileNumber.

I am looking for a Chronoform action/method to check if certain duplicate rules exist at the point of submission and to block the data entry until this has been resolved by the person submitting the form.

For example, if they submit the form one of the following 3 actions may appear for duplicate issues:
1. "That combination of mobile number and email address have already been stored"
2. "That mobile number has already been stored"
3. "That email address has already been stored"

Is it possible to check for pre-existing values in the database, and if they exist to block the submission?

Thanks.

Brendan

Hi Brendan,

Typically a Custom ServerSide Validation action would be the place to do that.

You can also do it in the form using Ajax if you want to give the feedback more quickly.

Bob

Cheers Bob,
haven't an idea where to start on either suggestion but will look into it further.
many thanks,
Brendan