The method shown in the video involves linking records together as you’ve already done, and then adding Lookup or Rollup fields with conditions applied to return the linked records with the highest value.
Hi! @Kamille_Parks thanks for the support.
I have a problem with linking fields.
What i want is know how to link the fields local_team_goals and visitant_team_goals to another table, something like i have in this table idea what i create:
Then i want to rollup them to add a formula and know which team was the winner. Something like:
So, in the example tables even i haven´t the fields linked right so again, what i don´t know and i want to know is how link my fields right.
Your first post seemed to have a perfectly acceptable linking structure, go back to what you showed there. Each [Event] record links to a record in [match_id]. [match_id] should have the following Rollup-type fields:
Thank you @Kamille_Parks! This really has been a lot of help, i still have a couple of questions though
1 - what is ‘values’? what exactly value should I put for this param, and if the ‘values’ params are the number coming in, for example from local_team_goals , so how could I refer to these data/param?
2 - How can I get the linked fields on a new table?
When linking fields with match_id they’re generated on the same table, but I’d like to get them on a different one.
Oh sure, i made that table just as reference to give an idea of what i look for. In theory that’s exactly what i mean but the fields are not linked of a right way.
Then, if i follow the steps that you describe i get something like:
so, in orange is remarked the field that is created in the same table, now my question is how i could send that new fields linked to match_id that are created there to other table as the reference table.