Working on attendance app (want single entry on a specific date)

[vicks88980]

HI guys,

i have created an attendance app. But i want single entry to be done on today(). How can i prevent just one entry only.. 

sometimes users mark multiple attendance on a single date which causes confusion..
may be the +(add) button gets disabled after one entry.. 🙂

pls give me some ideas on how to do it?

mine is a simple app not very complex..

thanks in advance, Hope to get a solution

[TeeSee1]

Please share the definition of your table with the community and define what duplication you want to avoid.

[vicks88980]

I appreaciate your response sir, i am pretty new to the appsheet community.

i dnt know how to share definition of the table, but i want to avoid duplication of record for a specific date. Like we use attendance, so i dnt want attendance marked multiple times on same day. how to prevent multiple entries on the same day

[eldderri]

Hi friend,

I am not an expert in appsheet ,but I have made a similar app and to avoid duplicate enteries for the same employee on the same day I have used this expression :

Not(IN([Employee ID],SELECT(Attendance[Employee ID],AND([Date]=TODAY(),[Employee ID]=[_THISROW].[Employee ID]))))

in my action to add attendance.

but it is better to share the structure of your table with the community for better understanding

Best regards,

[vicks88980]

Oh Thanks for sharing the code..means a lot.i wil try it for sure and let u know in this post thread.

meanwhile this is my gsheet and related tables

[AleksiAlkio]

One simple method is to use key column for this purpose with the initial value like.. USEREMAIL()&TEXT(TODAY(),"ddmmyyyy"). With this way the user is not able to save a new record more than once in a day.