Bot to create an entry on to a table daily

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?

0 6 401
6 REPLIES 6
Top Labels in this Space