# Need Help Displaying Unique Job Titles per Project for Users **URL:** \ **Category:** Ask for Help\ **Created:** [July 9, 2024, 2:55pm UTC](https://community.glideapps.com/t/need-help-displaying-unique-job-titles-per-project-for-users/74749 "2024-07-09T14:55:17Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Bryan\_Seigel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bryan_seigel/32/77374_2.png) [@Bryan\_Seigel](https://community.glideapps.com/u/Bryan_Seigel)\ **Post date:** [July 9, 2024, 2:55pm UTC](https://community.glideapps.com/t/need-help-displaying-unique-job-titles-per-project-for-users/74749/1 "2024-07-09T14:55:17Z")
Hey Everybody! I’ve gotten myself stuck on something I’m sure glide can do, but I’m having a hard time figuring it out. I’m creating a customer portal where I can add users to various projects we are working on. On each project I have a collection of users that displays name, photo, contact info etc. This all works great. Where I’m getting stuck is displaying the job title specific to that user for that unique project alongside their other info. With the way my industry works, people can hold a variety of positions on different projects. I’m making some progress using a separate table, but suspect there is a cleaner way to do this using arrays or JSON objects. Thanks for the help! ---
**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:** [July 9, 2024, 11:42pm UTC](https://community.glideapps.com/t/need-help-displaying-unique-job-titles-per-project-for-users/74749/2 "2024-07-09T23:42:48Z")
If you’re on a plan that can use Big Tables, I would use a Big Table to hold the info of user assignment to each project, so it looks like this: | Project ID | User ID | Role | | --- | --- | --- | | P001 | U001 | Project Manager | | P001 | U002 | Developer | Then relate the Projects table with this using the project ID. Another option is using an array, which I imagine will involve a custom form where you choose a user and a role, then write to a multiple files column. ---
**Author:** ![Bryan\_Seigel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bryan_seigel/32/77374_2.png) [@Bryan\_Seigel](https://community.glideapps.com/u/Bryan_Seigel)\ **Post date:** [July 10, 2024, 12:22am UTC](https://community.glideapps.com/t/need-help-displaying-unique-job-titles-per-project-for-users/74749/3 "2024-07-10T00:22:06Z")
Thanks so much! I’m doing something similar to this, but can easily switch it over to a big table. What are the advantages of big tables? ---
**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:** [July 10, 2024, 2:17pm UTC](https://community.glideapps.com/t/need-help-displaying-unique-job-titles-per-project-for-users/74749/4 "2024-07-10T14:17:59Z")
If you are positive it won’t reach 25k anytime soon, then you can just keep it in Glide Tables. Big Tables can reach 10 million, but has some limitations. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7ee8666ef744210281f943beef9debeda4967e90.png) > **[Big Tables | Glide Docs](https://www.glideapps.com/docs/big-tables#limitations-of-big-tables)** > > Scale your app with up to 10 million rows of data. ---
**Author:** ![Bryan\_Seigel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bryan_seigel/32/77374_2.png) [@Bryan\_Seigel](https://community.glideapps.com/u/Bryan_Seigel)\ **Post date:** [July 10, 2024, 2:45pm UTC](https://community.glideapps.com/t/need-help-displaying-unique-job-titles-per-project-for-users/74749/5 "2024-07-10T14:45:43Z")
Good to know, I’ll see if I can get everything to work with Big Tables for future-proofing sake. Very curious about how you would approach this using arrays. I’m having trouble sorting out how to store pairs of values. Would it make more sense to store the (Project,Role) values in the Project Table or User Table? ---
**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:** [July 10, 2024, 2:46pm UTC](https://community.glideapps.com/t/need-help-displaying-unique-job-titles-per-project-for-users/74749/6 "2024-07-10T14:46:31Z")
> [@dizzyaccordion JSON Trebuchet](https://community.glideapps.com/t/json-trebuchet/72744): > > wave Hey fellow Gliders! Part two of my Trebuchet series is live! Last week, I posted a tutorial on a new way to create inline arrays using the Trebuchet method Part 2 is a deep dive on how you can Trebuchet more than a single value by creating arrays of JSON exploding_head. Check out how to build an inventory ordering app using the JSON Trebuchet Method! :popcorn:Enjoy! [[Glide: Build an Inventory Ordering App Using the JSON Trebuchet Method] ](https://www.youtube.com/watch?v=1QbKTccN850) Here you go. ---
**Author:** ![Bryan\_Seigel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bryan_seigel/32/77374_2.png) [@Bryan\_Seigel](https://community.glideapps.com/u/Bryan_Seigel)\ **Post date:** [July 10, 2024, 2:56pm UTC](https://community.glideapps.com/t/need-help-displaying-unique-job-titles-per-project-for-users/74749/7 "2024-07-10T14:56:34Z")
Oh yes, very familiar with all the trebuchet videos from Robert now. I can bundle the values into an array of JSON objects. But as far as I can tell there is not a way to “unpack” an array of JSON objects into individual rows that can be viewed in a collection. I think the trebuchet method works best when one set of information is a fixed quantity. But in my case the number of users, number of projects, and number of roles are all variable. ---
**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:** [July 10, 2024, 2:59pm UTC](https://community.glideapps.com/t/need-help-displaying-unique-job-titles-per-project-for-users/74749/8 "2024-07-10T14:59:17Z")
> [@Bryan\_Seigel](#): > > But as far as I can tell there is not a way to “unpack” an array of JSON objects into individual rows that can be viewed in a collection. Why so though? Wouldn’t this work? > [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766): > > I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc)