Forums

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

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

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

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

Thanks Sir

This serves as a better choice