Find records based on record dates

Topic Labels: Automations
684 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I have the “Dashboard” table with a list of all let’s say - “Loads”. Each “Load” has it’s own “Driver” that is in a separate field. I, also have an “Invoice” table, and in that table, I want to Invoice all “drivers” that had “loads” from the “Dashboard” table. So that means, I’ll need to have a certain range, because I want to invoice them weekly, and not by the load. So I ended up making “From Date” and “To Date” fields. So, my question is how can I make it when I choose “Driver” and mark my “From Date” and “To Date” fields that Airtable automatically import “Loads” that were, let’s say, driven between those dates for that exact driver? Hope you understand!


0 Replies 0