Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Creating groups based on a category?

259 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a set of data that contains first name, last name, timezone, and email address. I’d like to create automatic groups of 3 based on time zone (each participant needs to have the same timezone per group) and then somehow (hopefully in an automated manner!) communicate the peer groups with their first, last, email to each group. Anyone have any ideas for how this could be done with Airtable? Thanks in advance!

1 Reply 1

I can see this happening with a combination of a script in the Scripting app and a webhook-triggered automation. The script would do the heavy lifting of matching people and building groups. Once that’s done, it would call the webhook once per group to trigger the automation, which would send an email to the members of each group. For example, if there are 15 people, the script would build five groups of three, then call the webhook five times, each time sending data for a single group’s members to the automation to email those members.