I am trying to make an attendance app and facing issue with duplicate entries. When Admin clicks on “Add Attendance” against an employee name, then one entry should get created for that day. I am using “Date+Employee-Mobile” as one of the columns.
Problem is that without uniqueness check, multiple entries are getting created for same “Date+Employee-mobile” when admin clicks “add attendance” repeatedly.
My question is - is there a way/hack to limit only one entry or “update if record already present” when the “add attendance” button gets clicked second time?