Database read to stop multiple requests

Prevent duplicate form submissions using a phone number check.

Overview

The issue occurs when multiple contact forms allow repeated submissions with the same phone number, leading to duplicate entries in the database.
Use a database read action in the form's On Submit event to check for existing phone numbers, then add an event switcher to stop processing and display a message if a duplicate is found.

Answered
ChronoForms v6
Co Corne Strydom 24 Jul, 2020
Good day,

We have multiple contact forms on our website, that saves to one database.

What I would like to do is take one field say the telephone number field to check against. So if a client submit the form the first time it saves to the database as it does now, but then as soon as client submits a second form with the same number shortly after the form stops with a message we have already received a request with that telephone number today.

As far as I can gather it needs to be set up in a database read action, but I do not have clarity on how, can you please assist and point me in the right dirrection.

Thanks

Corne
Gr GreyHead 24 Jul, 2020
Answer
1 Likes
Hi Corne,

In the form On Submit event you can use a Read Data action to check if the phone number is already registered; and follow that by an event switcher which stops the form processing and shows your message if the number is duplicated.

Bob
Co Corne Strydom 24 Jul, 2020
Thank you GreyHead! I missed the event switcher part of the request. All sorted now.
This topic is locked and no more replies can be posted.