# Finding Similarities Between Users

**URL:** <https://forum.bubble.io/t/finding-similarities-between-users/243471>\
**Category:** Database\
**Created:** [January 26, 2023, 3:36am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471 "2023-01-26T03:36:47Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![zacharynelson0](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zacharynelson0/32/146908_2.png) [@zacharynelson0](https://forum.bubble.io/u/zacharynelson0)\
**Post date:** [January 26, 2023, 3:36am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/1 "2023-01-26T03:36:47Z")

</div>

Hello everyone!  
My users can save their favorite movies to the User data type with the field “Top Movies” which is a list. I want a button to be able to search for all users with one or more of the same favorite movies as them, and then navigate to one of those users randomly. I want the search for users to return all users who have **at least one exact match** in the current users Top Movies, which again, is type list. The setup I have below only works when one of the lists only has one entry so i need something beefier. I have not worked with intersect or filtering much, maybe one of those will help with this feature. Any ideas appreciated.

Also, the movie titles are pulled and saved via API, so different spelling isn’t an issue, every movie is spelled the same way. Thanks!

 ![Screen Shot 2023-01-25 at 9.23.52 PM](https://us1.discourse-cdn.com/bubble/original/3X/7/8/78b5f2bd84a7dc3ccc55f79b5d9837e8d06c009c.jpeg)

---

<div class="post-metadata">

**Author:** ![ksplinter007](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ksplinter007/32/157751_2.png) [@ksplinter007](https://forum.bubble.io/u/ksplinter007)\
**Post date:** [January 26, 2023, 3:42am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/2 "2023-01-26T03:42:36Z")

</div>

you have random item there, so its only going to return you one user. there may be a plugin that will return a list of random users, maybe like “list shifter” might do it.

---

<div class="post-metadata">

**Author:** ![zacharynelson0](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zacharynelson0/32/146908_2.png) [@zacharynelson0](https://forum.bubble.io/u/zacharynelson0)\
**Post date:** [January 26, 2023, 3:54am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/3 "2023-01-26T03:54:13Z")

</div>

ok thanks ill check! So there’s not a way to return all users who match at least one entry in each other’s lists?

---

<div class="post-metadata">

**Author:** ![ksplinter007](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ksplinter007/32/157751_2.png) [@ksplinter007](https://forum.bubble.io/u/ksplinter007)\
**Post date:** [January 26, 2023, 3:57am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/4 "2023-01-26T03:57:24Z")

</div>

try “intersect” count \>0

i believe ists something like

do a search for users, whos list of movies intersects with current users movies \>0: count (or not count if you want a list of users

---

<div class="post-metadata">

**Author:** ![doug.burden](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/doug.burden/32/179967_2.png) [@doug.burden](https://forum.bubble.io/u/doug.burden)\
**Post date:** [January 26, 2023, 4:02am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/5 "2023-01-26T04:02:25Z")

</div>

You’re going to want to use “:ranked by” operator

Search for Users:ranked by

---

<div class="post-metadata">

**Author:** ![zacharynelson0](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zacharynelson0/32/146908_2.png) [@zacharynelson0](https://forum.bubble.io/u/zacharynelson0)\
**Post date:** [January 26, 2023, 4:08am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/6 "2023-01-26T04:08:35Z")

</div>

Where would i put the intersect function? it just gives me contains

 ![Screen Shot 2023-01-25 at 10.08.03 PM](https://us1.discourse-cdn.com/bubble/original/3X/c/7/c73a4a78258af2603aae71ac1674d77cb3c1b523.png)

---

<div class="post-metadata">

**Author:** ![ksplinter007](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ksplinter007/32/157751_2.png) [@ksplinter007](https://forum.bubble.io/u/ksplinter007)\
**Post date:** [January 26, 2023, 4:11am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/7 "2023-01-26T04:11:25Z")

</div>

[Buildfactor (bubbleapps.io)](https://buildfactor.bubbleapps.io/version-test/test_play?debug_mode=true)

use the dropdown to select the user, and it will show you users that contain at least one text item that is the same

![image](https://us1.discourse-cdn.com/bubble/original/3X/9/f/9f3cb36e51a867796dab5efd1eef9a4e8af47631.png)

---

<div class="post-metadata">

**Author:** ![zacharynelson0](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zacharynelson0/32/146908_2.png) [@zacharynelson0](https://forum.bubble.io/u/zacharynelson0)\
**Post date:** [January 26, 2023, 4:12am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/8 "2023-01-26T04:12:13Z")

</div>

How would you set it up?

 ![Screen Shot 2023-01-25 at 10.10.46 PM](https://us1.discourse-cdn.com/bubble/original/3X/b/0/b0b47b7ae2e44232abfedaa64a75c1e94ae14a94.png)

---

<div class="post-metadata">

**Author:** ![zacharynelson0](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zacharynelson0/32/146908_2.png) [@zacharynelson0](https://forum.bubble.io/u/zacharynelson0)\
**Post date:** [January 26, 2023, 4:14am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/9 "2023-01-26T04:14:52Z")

</div>

Will that work with the “data to send” part? Because i am trying to send a users data to a page. Its not a repeating group

---

<div class="post-metadata">

**Author:** ![ksplinter007](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ksplinter007/32/157751_2.png) [@ksplinter007](https://forum.bubble.io/u/ksplinter007)\
**Post date:** [January 26, 2023, 4:15am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/10 "2023-01-26T04:15:49Z")

</div>

your going to send movei data to a page?

---

<div class="post-metadata">

**Author:** ![zacharynelson0](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zacharynelson0/32/146908_2.png) [@zacharynelson0](https://forum.bubble.io/u/zacharynelson0)\
**Post date:** [January 26, 2023, 4:17am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/11 "2023-01-26T04:17:17Z")

</div>

no the buttons worlflow is navigate to a page, and the data to send will have to be a certain users data, the user that contains at least one of your own Top Movies

---

<div class="post-metadata">

**Author:** ![doug.burden](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/doug.burden/32/179967_2.png) [@doug.burden](https://forum.bubble.io/u/doug.burden)\
**Post date:** [January 26, 2023, 4:18am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/12 "2023-01-26T04:18:01Z")

</div>

I believe all you’d just use Search for Users:ranked by numberical similarity to Current User

This should match all like users together.

---

<div class="post-metadata">

**Author:** ![ksplinter007](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ksplinter007/32/157751_2.png) [@ksplinter007](https://forum.bubble.io/u/ksplinter007)\
**Post date:** [January 26, 2023, 4:19am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/13 "2023-01-26T04:19:28Z")

</div>

yeah now that a read your question again i think i understand. so the repeating group is just to show you what data you returned from the expression. then you would run a workflow to send a random users data to a page (or group).

if dougs idea works go for it to, i havent used ranked

![image](https://us1.discourse-cdn.com/bubble/original/3X/f/5/f580d33a3fdc0ade41ce394751f60f42e4d6c2d8.png)

---

<div class="post-metadata">

**Author:** ![zacharynelson0](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zacharynelson0/32/146908_2.png) [@zacharynelson0](https://forum.bubble.io/u/zacharynelson0)\
**Post date:** [January 26, 2023, 4:20am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/14 "2023-01-26T04:20:29Z")

</div>

Ok and what would i put here? it cant just be that on its own.

 ![Screen Shot 2023-01-25 at 10.19.46 PM](https://us1.discourse-cdn.com/bubble/original/3X/9/9/9986327c3f48d40578252fbf2ee8bf4720177d45.png)

---

<div class="post-metadata">

**Author:** ![zacharynelson0](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zacharynelson0/32/146908_2.png) [@zacharynelson0](https://forum.bubble.io/u/zacharynelson0)\
**Post date:** [January 26, 2023, 4:22am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/15 "2023-01-26T04:22:12Z")

</div>

Expanded:

 ![Screen Shot 2023-01-25 at 10.21.50 PM](https://us1.discourse-cdn.com/bubble/original/3X/f/a/fac6a1a4ea526658e9fcc73cc29a7717d8a2aefb.png)

---

<div class="post-metadata">

**Author:** ![ksplinter007](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ksplinter007/32/157751_2.png) [@ksplinter007](https://forum.bubble.io/u/ksplinter007)\
**Post date:** [January 26, 2023, 4:23am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/16 "2023-01-26T04:23:44Z")

</div>

is your index page set to user data type?

---

<div class="post-metadata">

**Author:** ![doug.burden](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/doug.burden/32/179967_2.png) [@doug.burden](https://forum.bubble.io/u/doug.burden)\
**Post date:** [January 26, 2023, 4:24am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/17 "2023-01-26T04:24:10Z")

</div>

An oversight on my part, I thought you were wanting to display Users together who’s fields matched with a RG. I’m not sure about sending data to a page.

Edit. index data type should be User ksp be right

---

<div class="post-metadata">

**Author:** ![zacharynelson0](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zacharynelson0/32/146908_2.png) [@zacharynelson0](https://forum.bubble.io/u/zacharynelson0)\
**Post date:** [January 26, 2023, 4:24am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/18 "2023-01-26T04:24:45Z")

</div>

It is, yea

---

<div class="post-metadata">

**Author:** ![ksplinter007](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ksplinter007/32/157751_2.png) [@ksplinter007](https://forum.bubble.io/u/ksplinter007)\
**Post date:** [January 26, 2023, 4:25am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/19 "2023-01-26T04:25:16Z")

</div>

at the end of that exression you need to put random item, right now its a list, you need to make it one thing

---

<div class="post-metadata">

**Author:** ![ksplinter007](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ksplinter007/32/157751_2.png) [@ksplinter007](https://forum.bubble.io/u/ksplinter007)\
**Post date:** [January 26, 2023, 4:28am UTC](https://forum.bubble.io/t/finding-similarities-between-users/243471/20 "2023-01-26T04:28:04Z")

</div>

[Buildfactor (bubbleapps.io)](https://buildfactor.bubbleapps.io/version-test/test_play?debug_mode=true)

this is what the numaricall similarity returns in the repeating group, im not so sure thats the answer i dont see how to specifiy what you are ranking the data types by.

only numarical difference and numaricall similarity, not comparing lists

its good practice to test your results with a visual representation of the return, so you know what data you are getting at the end point

[Next page](https://forum.bubble.io/t/finding-similarities-between-users/243471.md?page=2)
