Help

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

Solved
Jump to Solution
190 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