Relation from multiple values (Data)

Would be great if we could, in Configuration of Relation, set multiple values from multiple columns !?(for “Matches the value in:”)


1 Like

You can if you set up your columns as an array. For example, name the headings ‘Item 1’, ‘Item 2’, ‘Item 3’, etc. This will create a single ‘Item’ column that can be used to set up a relation using all ‘Item’ columns.

Thank you for answering the question.
I am not sure if an array solves my problem.

I should have explained with an example.

Suppose that we have a datasets of football matches and there are two tables: Team and Match.

In Team, we have simply one column for Name.
In Match, we have match information such as Home Name, Away Name, Date, Venue, etc.

I want to use Match's relation in Team for showing coming matches for a team in the team’s detail view.

For now, I can only refer to either of home/away column, so I should create two relations separately: Home Relation and Away Relation.

Therefore, I would like to create a relation that shows matches without filtering by home/away.

I actually wanted to ask if it is possible to set two conditions (see highlighted)

Check out this thread:

1 Like

Oh, I did not realize that we could make an array as a part of table!

Thanks so much!

1 Like