One record per person per day
(First, I'm new to QB. So, sorry in advance.) I have been asked to create functionality where employees can check-in/check-out at the beginning/end of day. I found some apps in the exchange that we...
Forum Discussion
Tate,
You can have a field for the current date which is a data entry field which defaults to "today". (no data entry required)
You can have a field for the user which defaults to the current user. (no data enruy required.
Your can then make a formula field to concatenate them together.
Lirt("-", ToText(Date]), UsertoName([Userid]))
and set the field properties for that field to be that to be unique. Then there can only be one record per user per day.
You can have a field for the current date which is a data entry field which defaults to "today". (no data entry required)
You can have a field for the user which defaults to the current user. (no data enruy required.
Your can then make a formula field to concatenate them together.
Lirt("-", ToText(Date]), UsertoName([Userid]))
and set the field properties for that field to be that to be unique. Then there can only be one record per user per day.