How to create a relation which compares with multiple columns in other sheet

I need to solve this:

Sheet A (games) has 2 Columns with, “Home team ID” and "Away Team ID"

Sheet B (Teams) has a column with “ID of the team”

I want to relate Teams to the games their in in ONE list. So I need relate Teams to 2 colums of Games which both can contain the team ID.

Does anyone know a fix? Having a new sheet with a beast of an array-kind-of-formula is also good if this fixes it XD

To

SmartSelect_20191203-113729_Sheets

Here you go: https://psman.glideapp.io

For future consideration it would be great if you would create a spreadsheet with some sample data and share that spreadsheet when you ask the question. This way a responder doesn’t have to create test data and can just answer the question. It took me about the same time to create the spreadsheet as it did to create the relationships and the app. The two relationships were created in Glide in the Data section, not using spreadsheet formulas.

1 Like

You’re right, should have made some sample stuff! My Apologies!

What you have made is what i have right now. I need to somehow have these 2 inline lists to be just 1 containing all home AND away games (in one inline list :sweat_smile:)

Any ideas?

I have a couple thoughts.

  1. In your Games sheet create two columns named ‘Team 1’ and ‘Team 2’. This should create an array called ‘Team’. This should allow you to create a relation in the Teams sheet that points to the Teams array in the Games sheet.

  2. Just add two relations and two Inline Lists next to each other. It has the appearance of one list.

This is what I already have

These are 2 inline lists. For a game related to 2 teams it is good because these will always contain 2 items. Home and away.

BUT when on a team page I want people to see All games in one list (chronologically)

Right nog it looks like this splitted in home and away games :frowning:

Did you try my first suggestion? It would give you one list.

What do you mean with. “This should create an array called ‘Team’.”

Sequentially numbering column headings creates an array. This allows all columns to be treated as one column.

Whoah this works! The “array” looks like this. (While in the spreadsheet it is 2 columns “Team 1” and “Team 2”)

I KNEW it was possible because glide is powerfull💪🏽

Thanks Jeff! Did not find this anywhere (I looked XD)

1 Like

Good deal! Yeah, I don’t think all the potential uses with arrays are documented. There might be some documentation when using them with images for the image carousel or using them for an array of emails for per user data. As far as relations, you should be able to do the opposite direction as well, where you could create a relation using the Team column in the games sheet to link to the Teams sheet. I’m sure there’s other potential cases for arrays that I haven’t discovered yet, or have forgotten.

1 Like