We are using Airtable to track receipts. The current setup is a Receipts tab, where employees can fill out a form to submit their receipts.
The Staff tab, is where the list of staff names are that the staff choose from when filling out the form that goes to the Receipts Tab.
Then I have a 3rd tab for Reconciliation Month that the Finance Manager can apply onto the Receipts tab when they do the final approval of the receipts.
The workflow is that an employee will fill out the form when they have a receipt. Then once a month the finance manager will go in and review confirm which month the receipt applies to so that it will group together.
I am trying to get it setup to do an automation that sends the receipts to the finance manager by staff person by month. I am able to do the email that pulls all the receipts together for that month, but can't figure out how to break it down by person. The staff tab has a lookup of receipts by person, but it is pulling all the receipts. I know I can set a filter on the lookup field to be a specific month, but that would require changing the filter every month. Is there a way to do this more automatically where I can get just the month's receipts for that person. I've been trying to do it via interface and buttons and filters, but still can't seem to get it to do just those receipts.
