# Dynamic scoring system

**URL:** <https://community.glideapps.com/t/dynamic-scoring-system/24241>\
**Category:** Ask for Help\
**Created:** [March 14, 2021, 12:29pm UTC](https://community.glideapps.com/t/dynamic-scoring-system/24241 "2021-03-14T12:29:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mihai\_Enache](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mihai_enache/32/20880_2.png) [@Mihai\_Enache](https://community.glideapps.com/u/Mihai_Enache)\
**Post date:** [March 14, 2021, 12:29pm UTC](https://community.glideapps.com/t/dynamic-scoring-system/24241/1 "2021-03-14T12:29:29Z")

</div>

Hello,

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

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 14, 2021, 1:05pm UTC](https://community.glideapps.com/t/dynamic-scoring-system/24241/2 "2021-03-14T13:05:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mihai\_Enache](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mihai_enache/32/20880_2.png) [@Mihai\_Enache](https://community.glideapps.com/u/Mihai_Enache)\
**Post date:** [March 14, 2021, 1:06pm UTC](https://community.glideapps.com/t/dynamic-scoring-system/24241/3 "2021-03-14T13:06:33Z")

</div>

@Robert_Petitto Yes, a relevancy rating

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 14, 2021, 1:11pm UTC](https://community.glideapps.com/t/dynamic-scoring-system/24241/4 "2021-03-14T13:11:18Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Mihai\_Enache](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mihai_enache/32/20880_2.png) [@Mihai\_Enache](https://community.glideapps.com/u/Mihai_Enache)\
**Post date:** [March 14, 2021, 1:22pm UTC](https://community.glideapps.com/t/dynamic-scoring-system/24241/5 "2021-03-14T13:22:47Z")

</div>

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