So I have 2 Typeform surveys, essentially both surveys have the same questions, however each survey goes to a different group.
Survey 1 goes to CDL class A truck drivers in the USA
Survey 2 goes to Trucking company owners in the USA.
Trucking companies who are looking for drivers have specific bench marks they require for hiring drivers, and likewise drivers have specific benchmarks they are looking for in their new trucking company.
My question is, is there any apps I can integrate via zapier that would automatically pair optimal matches? It would make thing soooo much easier, if there was an app that said “8/10 questions match candidate A with company C”
Best answer by john.desborough
@levivanpay - welcome to the community ..
what you have is a classic many to many relationship to solve.. lol..
you could have both surveys connected to the same Google Sheet - the data would end up on separate tabs (one for driver responses and one for company)
You could then create a third tab where you would use a set of formulas to score each driver against each company and then determine the highest match score for the record, something conceptually like this on the 3rd tab :
what you have is a classic many to many relationship to solve.. lol..
you could have both surveys connected to the same Google Sheet - the data would end up on separate tabs (one for driver responses and one for company)
You could then create a third tab where you would use a set of formulas to score each driver against each company and then determine the highest match score for the record, something conceptually like this on the 3rd tab :
