Add row without duplicating

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.

Hi @Hern-ec53 :honey_pot: :honeybee:

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. :slightly_smiling_face:

1 Like

A post was split to a new topic: Conditional visibility for message on screen

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.