Solved: Duplicate entry detection - Page 2

Raju_Tadepally · 01-30-2020 07:39 PM

HI every one,
I have a table Named: SCAN
it contains three Columns
[Date] , [Time] , [Application ID]

the app scans the Application ID from 2d Bar code & saves the date along with Date & Time.
i want to have an expression in "valid if " to detect any duplicate entries of [Application ID] in particular day when the scan is in progress. i.e the while scanning it shall declare invalid or already Scanned message if the scan code was already in the same date.

i am not familiar with higher order Expression writing . request Help.
Regards
Raju

Suvrutt_Gurjar

Hi @Raju_Tadepally,

Can you please try

NOT(IN([_THIS], SELECT(CANTEEN SCAN[Application ID], AND(NOT(IN([KEY], LIST([_THISROW].[KEY]))),[Date]=TODAY(),OR([Type of Meal]= “Breakfast”, [Type of Meal]= “Lunch” , [Type of Meal] =“Dinner” )))))

View solution in original post