Solved: Restrict duplicate entries based on two conditions - Page 2

MitchLags · 12-06-2022 10:58 AM

Hi,
I know this has been covered on multiple threads but I can not figure out a method to adapt to my situation.

I have a form users can fill in appsheet, In short its a Name selection & Topic selection followed up with a signature. I want to stop users from being able to enter the same name and topic more than once. for example, Jeff can be signed off on 10 different topics but all topics have to be unique and he should not be able to submit the same one twice.

I need a formula which will display only outstanding topics(Toolboxtalks) based on the name entered. I feel like it should be so simple, if this would have been in sheets i'd have no issue but expressions are a different language here.

Thank you.

Markus_Malessa

Proposed Valid:

ISBLANK(SELECT(TableName[id], AND([_THISROW] <> [id], [_THISROW].[Name] = [Name], [_THISROW].[Toolboxtalk] = [Toolboxtalk]))

This should check your existing data only for a match and at the same time prevent an error to crop up if you have to resave an existing row in the table.

View solution in original post