Avoid Duplicates on form submit

[Matty_Fenny]

Hi,

I’m looking for a way to cancel adding the row on form submit if there is already a row for the same thing existing. At the minute heres how it works.

The form consists of 3 Text Entries(Ill name the important one “Requests” for ease):

Name, “Request”, Notes.

If there is already a request in the table for “Request”, I don’t want it to add the row.
I have created a List, and then a split list of “Requests”. I have then Checked if the Split list contains “Request”, cancel and show a fail notification.

Obviously this isn’t working as it is adding the row on Form Submit, then checking if that “Request” exists, which it now does, and then removes the row.

Any ideas?

Hopefully this was clear enough.

[nathanaelb]

You might want to create a custom form to prevent duplicate new entries.

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…