Forums

PREVENT DUPLICATE DATABASE ENTRY OF PAGE REFRESH

atanunu 28 Aug, 2015
Please,

How do I prevent duplicate entry of data into the database. This occurs when the page is refreshed or the back button is clicked.

I do not have an idea of what to do or codes to use to prevent this.

Thanks
GreyHead 29 Aug, 2015
Hi atanunu,

You can use the Submit Limit action in the Security actions group to block re-submissions for a period of time. That will prevent most immediate re-submissions, If there is still a problem you could add a marker to the User session on the first submission and check that when the form is submitted.

Bob
atanunu 29 Aug, 2015
Thanks Sir,

Is it possible to make use of the UPDATE CONDITIONS so as to insert record if 3 unique records are not found or update / ignore if the 3 unique records are found on a row.

The form has 3 unique records namely: ApplicationNumber, ApplicationReference, ReferenceNumber.

I am looking for the right way to prevent a new record if the same entry already exist (entry to rejected / ignored) but if they don't exist then an INSERT should be done.

Looking to a solution.

Thanks
GreyHead 29 Aug, 2015
Hi atanunu,

Use an Event Switcher action to check if the values have been used and only run the DB Save action if they have not.

Bob
atanunu 30 Aug, 2015
Thanks Sir

This serves as a better choice
This topic is locked and no more replies can be posted.