Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

organizing contacts in airtable for apartments that have multiple contacts (tenants) per apartment

Solved
Jump to Solution
410 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jzeller
5 - Automation Enthusiast
5 - Automation Enthusiast

Currently I have one apartment per row and the tenants #1 name, tenant #2 name, tenant #1 email, tenant #2 email as column name with the tenants info on the row. This hard to export the data this way or to sync to a crm with zapier. what is the best way to organize the contacts/ tenants in general so that easier to export or sync via zapier to a third party crm like cloze.

 

 

 

1 Solution

Accepted Solutions
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

I'd suggest making three tabs, so that you can see not only who's in each apartment, but also keep track of the apartment's next lease when things change:
Screenshot 2024-11-20 at 4.27.19 PM.pngScreenshot 2024-11-20 at 4.27.25 PM.pngScreenshot 2024-11-20 at 4.27.30 PM.png

See Solution in Thread

2 Replies 2

Hm how you export it to each service is going to vary depending on how that service ingests data I'm afraid

As a general recommendation, try creating a new table called "Tenants" with the fields for the tenant info, and then create a linked field to the Apartments table.  That way you can have multiple tenants without having to create "Tenants #1", "Tenants #2", "Tenants 3" etc

Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

I'd suggest making three tabs, so that you can see not only who's in each apartment, but also keep track of the apartment's next lease when things change:
Screenshot 2024-11-20 at 4.27.19 PM.pngScreenshot 2024-11-20 at 4.27.25 PM.pngScreenshot 2024-11-20 at 4.27.30 PM.png