I’m not sure if I am doing this right, but still trying!
So I want to make an app for film production services, where each type of service has their unique set of people assigned.
For example:
“Explainer Video 1:30 min” service always needs 2 Talents to be made:
- DoP (Director of Photography)
- EDITOR
So Customer can go into “shop” and click on “Explainer Video…” and inside of this service see theese needed talents in specification of service.
But also on the Service page, Customer can see names of available Talents that are “DoP’s” and “EDITORS”.
So I have USERS TAB where I store both “Talents” and “Clients” - They just has different “Account Types”.
but also they have “Role” column, where (if Talent), they can choose what profession they have.
So then I created the “Service List” tab, where I put all the services that Client can buy in the shop.
I wanted to add as many “Team Roles” as needed to each service to show customer what kind of talents are needed to make this job.
Unfortunately Glide shows only 1 type of Team Roles in Relation Column. When I put more values, there is no way to show it.
So I even tried few colums like: Team Role 1, Team Role 2 - and then somehow collect all the roles in another column, but that is also not possible.
How should I do it to gather all Team Roles for each Video Services?
I made Role selection which is viewable for ADMIN only, I can gather more data in one cell, but it still doesn’t work.