Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
May 06, 2021 10:04 AM
Question:
I have a customer CRM base, and a Contacts table for all contacts.
There are a handful of forms I’m using (hubspot, google forms, FB ads, etc) to collect new leads/contacts.
Do you find it better/cleaner/more useful to Zapier that data directly into Contacts, or to use another table to collect form responses and link relevant data back to contacts?
A separate table feels cleaner, but I’m learning more and more to reduce tabes and use views.
Thoughts + reasonings?
Thx in advance all!
Damon
May 16, 2021 12:33 AM
Views all the way, filtering is one of the best things about having a powerful relational database. Performance shouldn’t be an issue unless you’re big on looking at 25k records Across 500 fields at once lol. What ‘feels’ clean is beside any point bar, perhaps, a semantics debate. The client doesn’t care, the infrastructure doesn’t ‘care’, so it sounds like you’re just making life more complicated for yourself for real reason (in this highly specific instance that you describe).