We’re migrating from Google Sheets to Airtable, and as such also have to migrate a lot of logic we have in use for automatically triggering Zaps, which we use to automate our email funnel. One such thing is to determine if a download is done by a new lead, a customer or someone in an organization that’s a customer. We only want to email those that are truly new downloaders.
We have the following tables:
- Purchases; includes email amongst other stuff
- Downloads; again an email is collected
- Customers: both email fields from Purchases and Downloads are linked to here, creating one big list.
In Customers, I then use a formula to get the TLD (top level domain, the part after the @ in an email).
How do I count how often each unique TLD occurs, so I can filter on that integer?