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.