Hi, I'm facing a challenge when trying to create an app to track how the members of my sports team perform over time.

What I'm trying to do is to record all the games and the players involved in the game and how they perform in that game (goals scored, goals conceded, etc.)

So far I have managed to create the "Players" form as well as the "Game Report" form, in which we include the goal scorer(s) as well as the number of goal(s) attributed to the respective player(s). I do this by creating a Sub-Form in the "Game Report" form in which I put in a Lookup field to look for the player's name and a number field to record how many goal(s) that respective player scored. However, since every record is treated as a separate record, in my report section, under one player's name, there will be multiple entries (along with the number of goal(s) the respective player scored in that particular game/entry).

What I would like to do is:

1. Sum up the total number of goal(s) scored by a certain player, which would then be called up by a dashboard page. The report in Zoho Creator doesn't seem to have a sum or aggregate function (or I haven't found it yet).

2. Return the number of goal(s) scored by that respective player into the player's record (preferably in the "Players" form).

Please help!