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:
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.
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.