One user should not create record in same date

I am having a timesheet application ,in timesheet table i am having columns
Email ID = Useremail()
ID=UNIQUEID()
From date =WORKDAY(TODAY(),0)

I need to restrict the user to create only one record with today Date
Any suggestion.

The most quickest workaround should be to push expression of

[Email ID]&[From date]

as initial value expression for your ID field, instead of Uniqueid()

2 Likes

Valid_IF Formula for the timesheet table. Can be set to any row really but I’d suggest [From Date] with Invalid Value Error of “Only 1 time entry per day allowed”

COUNT(Select(TableName[ID],AND(
[Email ID]=UserEmail().
[From Date]=[_ThisRow].[From Date]
)))=1

1 Like