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()
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
User | Count |
---|---|
60 | |
25 | |
13 | |
12 | |
6 |