Find next activity date in simple case management ...

[Amael_Verbeure]

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 ?

[Sacha_Lochet]

I’m also interested. Up

[Brenkoh]

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.

[Ryan_Wilson]

I’ve worked on something similar before, and here's what I did to get things moving. Basically, I set up Airtable so that after each speed date, I could send a form where everyone picks who they liked. Then, I set it up so that if both people liked each other, the system would trigger and automatically email them with their contact details.
For something like a speed dating setup, especially if you’re dealing with a site like tosituhma.com, it can help keep things smooth and private while still making those connections happen easily. You just need to make sure the system’s working behind the scenes to match people properly, and platforms like that make it a lot easier to handle.