So I would like to do the following:
I have a “Time Log” app/table set up where employees log there time (Like a timesheet). Go to a service call, & at the end of your service call you log your time and what you did. I would like to create a Bot that daily looks at my “Active Employee” app/table , and then looks at my “Time Log” app/table and for any employees that haven’t logged time for the day and creates a 0 time entry for that employee.
Here’s What I have so far:
The Event:
I presume the “Condition” will be (in basic English I’ll figure out the actual formulas later):
If someone from this list:
1 Bob
2 Jane
3 Tim
4 Gail
Dosen’t appear in the time logs that match todays date, then run this bot for each employee missing a log for today’s date.
The process is my stumbling block here. I can’t find a way for it to run an action to create a new entry via the bot. Is there even a way to do what I want?
User | Count |
---|---|
40 | |
35 | |
30 | |
23 | |
17 |