Need Help Displaying Unique Job Titles per Project for Users

[Bryan_Seigel]

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!

[ThinhDinh]

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.

[Bryan_Seigel]

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?

[ThinhDinh]

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.

Big Tables | Glide Docs

[Bryan_Seigel]

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?

[ThinhDinh]

JSON Trebuchet

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 . 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]

Here you go.

[Bryan_Seigel]

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.

[ThinhDinh]

@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?

Transpose Columns to an Inline List: The Miracle Method

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]