Hi there!
I want to create two tables that create "matches" based on certain criteria's between the two tables. The one is for houses, the other for people who are looking for a certain house. As soon as a match is found, a signal needs to be send to a third party tool that sends the specific house to a person. The script that sends this signal to the other tool is already in place.
Whenever a new profile is created or a new house is created/updated, the matching criteria needs to run (we primarly match on price, m2 and location).
My initial thoughts are to run three separate automations based on the create/update triggers with a script that searches through the database.
Is this the most effective approach or would there be a smarter way?