# Many to many match **URL:** \ **Category:** Ask for Help\ **Created:** [April 18, 2023, 1:47pm UTC](https://community.glideapps.com/t/many-to-many-match/60685 "2023-04-18T13:47:44Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\ **Post date:** [April 18, 2023, 1:47pm UTC](https://community.glideapps.com/t/many-to-many-match/60685/1 "2023-04-18T13:47:44Z")
How would go about the following: Each user picks his five favorite cities then hits “match” and a list of any other users who match on at least one city is generated. Thank you for any insight. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 18, 2023, 1:58pm UTC](https://community.glideapps.com/t/many-to-many-match/60685/2 "2023-04-18T13:58:53Z")
If you use a multi-select choice component to select cities, then the result will be a comma delimited list of cities. Use a Split Text column to convert that comma delimited list into an array. Then create a Relation column that links the array to the city column in the table where you want to find the matches. You can display a collection sourced from that relation. ---
**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\ **Post date:** [April 18, 2023, 2:43pm UTC](https://community.glideapps.com/t/many-to-many-match/60685/3 "2023-04-18T14:43:08Z")
Will try it. Thank you ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [April 18, 2023, 8:51pm UTC](https://community.glideapps.com/t/many-to-many-match/60685/4 "2023-04-18T20:51:26Z")
This worked well. Thank you! Only problem I have now is javascript suddenly stopped working. Could this be specific to my account? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 18, 2023, 10:35pm UTC](https://community.glideapps.com/t/many-to-many-match/60685/5 "2023-04-18T22:35:07Z")
Have you restarted your browser and/or computer? It shouldn’t be something specific to your account. Either the browser is having an issue or you have malformed javascript. ---
**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\ **Post date:** [April 19, 2023, 12:48am UTC](https://community.glideapps.com/t/many-to-many-match/60685/6 "2023-04-19T00:48:10Z")
Fixed the JavaScript. Thank you ---
**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\ **Post date:** [April 20, 2023, 8:56pm UTC](https://community.glideapps.com/t/many-to-many-match/60685/7 "2023-04-20T20:56:38Z")
I got this to work and want to test across about a dozen user profiles I have set up. Log in as user1, make the selection and create the collection, then user 2 and so on. Problem is that it will only write the selections to the first user in the user profiles table. I have cleared cookies and cache. Any ideas would be appreciated. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 21, 2023, 12:29am UTC](https://community.glideapps.com/t/many-to-many-match/60685/8 "2023-04-21T00:29:42Z")
> [@George\_Pillari](#): > > Problem is that it will only write the selections to the first user in the user profiles table It seems like you’re setting up your screen on the first row for every user. Please use the “filter” on the tab level to filter to the right row (e.g: email is signed-in user), so that it will write to right row. ---
**Author:** ![George\_Pillari](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_pillari/32/55971_2.png) [@George\_Pillari](https://community.glideapps.com/u/George_Pillari)\ **Post date:** [April 21, 2023, 12:14pm UTC](https://community.glideapps.com/t/many-to-many-match/60685/9 "2023-04-21T12:14:45Z")
Perfect. Thank you. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 26, 2023, 6:46pm UTC](https://community.glideapps.com/t/many-to-many-match/60685/10 "2023-04-26T18:46:39Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.