One user should not create record in same date

G_S
Participant IV

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.

0 2 110
2 REPLIES 2

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()

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

Top Labels in this Space