Add row without duplicating

[Hern-ec53]

Hello Community!

I want to add a filter that allows me to check if the row to be added already exists.

I have this form, and I have a message that I want to show if the add already exists.

I have the "Add" button configured as shown in the image.

[Alyssa]

Hi @Hern-ec53

You have the right idea to use the run options! I'm happy to show you a formula that would meet your needs. You can use a FILTER formula that checks that there are no rows in a particular table that match particular content on the screen.

For example, I created a table of items and a screen with a button that only adds a new item row if that item's name does not exist in the table yet. (It checks that there are 0 rows in the items table that match the name on the screen).

Formula used in my example: =(FILTER(Items,"Items[Name]=$[Item Name]")=0)

If the name already exists, a row will not be added.

Hope this example helps! Let us know if you have any other questions.