I have linked two data collections with a relation field and the column name. Following this, I can’t seem to link the data in another field into another column. I have used another relation field but this comes up blank.
Do you have screenshots? Do you have matching values in both tables for the relation to work?
Thats the first db called CCF 2
i want the data from the column session delivery: technical detail to pull through to the same column on this db -
As you can see the name pulls through but not the data for the other column
I’d be curious to see how you are attempting to configure the Session relation, but I think you are approaching it wrong.
First of all, relations do not bring back a specific column. Relations create a link to entire rows of data that have a matching value in a single column.
I don’t think you need a relation in your CCF 2 table unless you have a specific reason to have it there.
You have your relation in the Master table, which is returning matching rows from the CCF 2 table, so that is good.
If you want a specific column from those related rows, then you need a Lookup column that gets a specific column out of the relation.
Now, it appears that your relation in the Master table would be a one to many relation to the CCF 2 table. If your relation is set up to match multiple, then the Lookup will return an array? If it’s an array, how do you intend to use it, because arrays contain multiple values instead of a single value and can’t be used in places that only expect a single value. If the multiple checkbox is not selected in your relation, then likewise the lookup will be a single value containing the column value from the first match in the relation.
Depending on your end goal, maybe a Lookup is not the best choice and you should use a Joined List column instead. Really hard to say without knowing what your intentions are.
1 Like
I have used the joined list option. The scores showing are all the scores that a related to Ray
Redmond CCF. Joe Blogs is showing the scorees for Ray Redmond as well and not Joe Blogs Scores. Why is this?
I think your New Column joined list is being configured incorrectly. Can you show us how you are configuring it?
1 Like