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!
