Dynamic scoring system


I have a table with users and their criteria and another table with apartments.

For each user, based on his specific criteria, I want to add a score to each apartment and then show in a tab only the apartments that are above a certain value.

Is this possible?
Thanks for your help

By ‘score’ do you mean a relevancy rating? Which apartments are best suited for the user?

@Robert_Petitto Yes, a relevancy rating

Possible, but labor intensive. I think you’d need to create an if then for each response (brought in via relation/lookup or template>user columns) resulting in a 1 (or some other number) if it matches or a 0 if it doesn’t. Then add a math column to add the 1s to create the score.


I will try it like this and come back with a feedback.
Thanks for your help Robert