I’m using Airtable at a small car dealership, and wanted to know if there is a way to automatically move a record to a different table, while keeping it’s info intact.
For instance. I have a table of current inventory. If that inventory sells, I don’t need it on the Current Inv. tab. I know I can put a checkbox for SOLD and filter it out, but then it still comes up in lists when I’m linking to current inventory from another table. And that will eventually become an incredibly long list. Right now I have another table for Sold Inventory, and I have been copying and pasting the records there, but then it loses any info that was linked to it from Leads and Repairs. Is what I want possible, or can it be?