Help

Re: correspondence system between 2 tables

Solved
Jump to Solution
605 0
cancel
Showing results for 
Search instead for 
Did you mean: 
MathieuCharlie
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

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

See Solution in Thread

1 Reply 1
TheTimeSavingCo
17 - Neptune
17 - Neptune

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