Would be great if we could, in Configuration of Relation, set multiple values from multiple columns !?(for “Matches the value in:”)
thanks
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