Compare two lists and create a thing based off missing records

[dalton.wu]

Hello Everyone!

Still learning some of the ins and outs of bubble and any help will be greatly appreciated. So basically I have an app with employees as one data type and time cards as another. The time card data type has a field to tie it to an employee but the employee data type does not have a time card field since a new time card will be submitted every week. If they did not work that week they are still required to submit an “empty” time card (where all hours worked are 0). Basically I am trying to create a workflow that compares a list of employees with a list of time cards and any employee that does not have a time card, an empty one will be generated. I am having trouble with comparing the two lists and getting the list of employees without time cards. Any help will be greatly appreciated!

[mikeloc]

Hi there, @dalton.wu… I haven’t tested this expression, but I believe it would result in a list of employees who don’t have a timecard that was created within the past week (depending on when you generate the list, of course, and you could change the Created Date constraint as needed).

Here is the advanced filter that is used in the expression.

Here are the constraints on the search for timecards.

So, again, I’m not 100% sure that expression will work, but it certainly can’t hurt to give it a shot, and I hope this helps.

Best…
Mike

[dalton.wu]

@mikeloc Thank you so much for your reply! I will give it a go