How should you structure an Airtable database for client information (bases vs. rows)?
One member shared their Airtable structure: multiple bases organized around Companies, Contacts, and Communications as the core tables. Every contact ties to a company (e.g., a married couple tied to a household "company" record, or a business entity). Communications come in via Fireflies. They also track leads, proposals, tasks, and client-uploaded documents in Airtable, with a prettier front-end app for the team to work from while Airtable holds the backend data. They cautioned that it's easy to build the database the wrong way early on, which then affects everything downstream, so some restructuring should be expected as the system evolves.
The full answer is members-only
Membership gets you this answer, the recording, and the rest of the library.
See membershipAlready a member? Sign in