
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 21, 2022 03:31 PM
Hello community, I am wondering if anyone has any experience setting up table like this: I am a realtor. The workspace would consist of a table for buyers I work with, their buying criteria filled out in the fields (ie. Min. $200k investment; Min. 2 bed 1 ba, etc). I would like a corresponding table/sheet with property data that corresponds with those buy box fields. If a $150,000 2 bed 1 ba house is inputted into the system, how do I create it so that it automatically emails to the corresponding appropriate buyers? Also would this count as a run per email (buyer) with regards to my automation run limit?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 21, 2022 05:00 PM
If your Buyers table looks like this:
and your Properties table looks like this:
You would set up an automation to trigger when all the appropriate Properties fields get filled in. Then you’d have a Find Records step that looks for up to 100 users with matching criteria:
From there you need to decide when precisely the matching users should get emailed.
If you are fine with mass emailing all the users about this one new matching property:
- Add an action after the Find Records step that uses the List of Field Values => Email Field in the To or BCC field and insert the Trigger Record in the email body. This will result in only 1 automation run per property.
If you want each user to get a custom email:
- Add a Update Record action after the Find Records step that inserts the List of Record IDs from the Find Records Step into the trigger Property record’s {Notified Buyers} field (or whatever field links Properties to Buyers}.
- Add a new automation that watches for changes to the Buyers table’s {Matching Properties} field. Add a Send Email action step with info from the linked property. If 10 buyers’ criteria matched the new property, then you’ll have 11 total automation runs.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 17, 2025 02:18 AM - edited ‎Jan 17, 2025 02:19 AM
Yeah, Airtable can totally handle this. I’d set up one table for buyers with their criteria (like budget, bedrooms, etc.) and another for the properties. You can use a formula to flag when a property matches a buyer’s needs, and then link them together.
I’ve seen setups like this work great for managing lots of data, but if you’re dealing with a ton of properties and tasks, you might want to check out something like https://www.valleymanagementgroupinc.com/. They make managing rentals super easy.
