Relate multiple items from a single cell

Ask for Help
1

Hello

I have a question regarding relations. I have already made a simple relation work but what confuses me the most
is how do you relate multiple items from a cell to a single category?

In my case I have built a job offers app and some offers have multiple locations and types of work, I was thinking there has to be an easier way to relate all of them without making a copy for each combination.

https://go.glideapps.com/app/kerFTc5qJCEnOI7Y6lUv/data

Please help,

Thank you

2

Hi,

I’m new to glide. But regarding the relation. This tutorial maybe can help you.

3

HI @biha

Thank you for the suggestion I’ve already tried this and if there is more than one item in the cell it doesn’t recognize it.

have a nice day

4

Can you show the screenshot for me to understand your problem. Just need you to share :slight_smile:

5

I’d love to,

643Ă—534 55.6 KB

881Ă—340 45.2 KB

thanks

6

The things you want to relate must be the same.
Let’s say you have “Participatiewet, Requlier, Wsw” in “Vacature Mei 2021” Table
You also should have '“Participatiewet, Requlier, Wsw” in “Functiegroep” Table.

7

True, that is a solution as well to include the combinations,
less headache of having to copy the same offer.

Thanks again

1 Like
8

You can use the Template column to combine it

1 Like
9

Use a Split Text column to split you comma delimited list into an array. Then you can can create your relation between your array of categories and the the single category.

2 Likes
10

@Jeff_Hager Thank you kindly for your suggestion

1 Like