Hello Guyz :grinning:, Do you know if there is anyway to additionate two relation like : [image] In order to have something like : [image]

You match it to only one column, what I mentioned was an array column.

I would imagine to have something like you want you must structure it like “Marble color - Race posiiton 1 - Race position 2” and match the marble color together.

In a Rule Tab? or Leaderboard Tab?

Match the marble color in Leaderboard sheet to the marble color in the the sheet where you store the race results (do you structure it like Marble color, Race number, Race position?). Set it to match multiple. In the sheet where you store the race results, relate the race position to the Rule sheet…

I don’t get it. Leaderboard tab is where i store all data. Room / marble colors choosen per room etc… Rule tab, is where i store result (i shoul hve called it “result” :rofl: ) [image] Each result race will be a new column. (example : Race 3) With that cofiguration do you have an idea …

Can you match a marble color to an array column (the races)? I guess not?

[image] ThinhDinh: array It is what i did no :thinking: [TEST3]

It works !!! thanks a lot ThinhDinh, again :fireworks:

Oh I learned something new as well, I have not tried this lol.

Okay so i am close to my goal. Now i have thoses data in my leaderboard tab, and i would like to have the same one in my user pofil tab I tried with a simple look up from my user pofil tab , but i can’t, it would be too easyer… [TEST3]

Why can’t you make a relation for that? In the Leaderboard tab you have the email of the user as well right?

Addition of two Relations (match simple)

Ask for Help

Jeff_Hager July 24, 2020, 5:00pm 23

If your lookup is to an array column, it won’t pull back all of the values. I requested for an array to load into a lookup array awhile back, but I don’t think anything was ever resolved with that.

Topic		Replies	Views
Relation bug? Ask for Help	19	454	July 23, 2020
Create a leaderboard Ask for Help	3	501	November 30, 2021
Relation from multiple values (Data) Feature Requests	5	690	May 19, 2024
Adding a rankings - set column - relations Ask for Help	1	262	September 24, 2021
Create leaderboard Ask for Help	6	361	December 5, 2021

Addition of two Relations (match simple)

Related topics