Prevent filtered duplicate records

[Wojciech_Sz]

Hi!
I have an app with buildings who have many floor plans.

I have another form that uses that data and have unique number (unique for floor plan). I want to prevent duplicate records.

In other words: every floor plan should have a unique set of numbers.

How to implement this idea?

I know this pattern:
Not(In([_THIS], SELECT(Table[Column_Name_for_THIS_Column], [TableID] <> [_ThisRow].[TableID])))

[Marc_Dillon]

Wojciech_Szczepanik:

I know this pattern:
Not(In([_THIS], SELECT(Table[Column_Name_for_THIS_Column], [TableID] <> [_ThisRow].[TableID])))

Sounds like you solved your own question here then, no?

[Wojciech_Sz]

Not really

I have table with columns:
floorplan | ID (which is not the key)

I can have many floorplans. I want to have different set of ID for every floorplan. For example:
Data A | 1
Data B | 1
Data C | 1
but when trying to add
Data A | 1 > invalid.

With this code I can only prevent duplicates globally.

[Marc_Dillon]

Ahh. You’ll need a slightly different approach if there is more than 1 thing to check the duplication against.
Like
ISBLANK( FILTER( table , AND(...

https://community.appsheet.com/search?q=prevent%20duplicates