Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 31, 2020 06:02 AM
Hello everyone,
I’m running a speed dating business and would like to automate the matching system. What I want is the following.
After the speed dating, each participant will receive an airtable form in which they can each select any number of participants of the opposite sex that they want to match.
If Woman1 selects Man1 AND Man1 selects Woman1, then a formula must be triggered and I’ll then use zapier or the email block to send emails automatically with each other’s private info.
Any idea on how to organize that ?
Mar 31, 2020 06:03 AM
I’m also interested. Up
Apr 11, 2020 04:09 AM
Hi there Amael,
Haven’t got to a full solution but you can use the following field formula as an inspiration of how to achieve this:
IF(FIND({Who I like}, {Who likes me}),1,0)
Assume that you have a ‘males’ table and ‘females’ table.
{Who I like} and {Who likes me} are both linked record fields in males and females table respectively.