I have a base that has multiple tables with different kinds of items (RFIs, Submittals, To Do list, Change Orders) and I want the main tab to have a list of only the open items from each category. How would one go about doing this?
What is your base structura and what data you wanna see in this new Table? Maybe this could be useful: https://airtable.com/universe/expLpOufs5M3HyF2U/sales-crm-dashboard
Other thread: Creating a summary/dashboard record