Speed Dating matching system

Topic Labels: Base design
1367 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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 ?

2 Replies 2
4 - Data Explorer
4 - Data Explorer

I’m also interested. Up

7 - App Architect
7 - App Architect

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.