Looks like Airtable doesn’t have an out-of-the-box flow process for a single record to move it to another table, but there are extensions that can do that with some configuration. It’s sort of a different functionality than what a database or spreads...

You could try to emulate a relational database but will only get you so far. Using 3 tables. The first one is just names of each individual. The second one for “Relationship Definitions” where you label the roles of the left and right columns, for ex...

I agree with the prevention of possible records, which could be done when entering data manually. This could easily be a feature on a column type, where the “dupe detector” is turned on, and it searches to see if the record already exists, giving the...

@Adam_Reece I read your feature request and in my opinion it doesn’t fall into data validation (even though validation is much needed) but more as “cascading drop-down options” aka dependent drop-downs which should be also a nice feature.

I have a use case: I manage a small club. There are Prospective Members, Active Members, and Former Members. They’re all “Contacts”. Then there is Attendance. When I take attendance I would like the Active members to show up as a list of available va...