Count how often (a part of) a string occurs


Hi all,

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?