Hey,
I’m new in Airtable and I’m trying to build a dating candidates data table.
I store my record as (part of the data): full name, photo, age, height, phone, email, gender, pref_min_height,pref_max_height, pref_maxAge (the pref_ is what the candidate’s preferences)
what I’m looking to do and I want your help if it can be done with Airtable + automation schedule + integration with Whatsapp / Slack:
once a week it checks each record and checks his/her preferences
looking in the table other candidates that match preferences.
send automatically all the offers to Whatsapp(by phone)/slack message(by email)
write all the candidates offers to new Airtable record called “candidates offers”
if the candidate wants any offer, he needs to write the id of the candidate offered by Whatsapp (it should be chatbot) then it will write the new record in Airtable and send the user the offer phone number back to his Whatsapp.
it a complicated app, so I’m trying to understand if I can do something like that in Airtable by automation trigger.
thank you.