Apr 15, 2023 05:21 AM
hello, is it possible to create a correlation or correspondence system between 2 tables and many criteria such as a table where users record about ten criteria and when the second table finds as many criteria corresponding to the first table this would create an action? I hope I was clear enough. it's a bit like a search system for a person who wants to buy a vehicle and enters their criteria into the website so that they are offered corresponding vehicles.
Solved! Go to Solution.
Apr 15, 2023 05:27 AM
Yeap, you can use an automation for this. Make it trigger when the record with the required criteria gets created, and give it a "Find Record" action to look for records in the other table that match said criteria.
Then, add an "Update Record" action to update the triggering record's linked field to the other table with all of the found records
Apr 15, 2023 05:27 AM
Yeap, you can use an automation for this. Make it trigger when the record with the required criteria gets created, and give it a "Find Record" action to look for records in the other table that match said criteria.
Then, add an "Update Record" action to update the triggering record's linked field to the other table with all of the found records