Comparing Data In The Same Field In Two Records of Same Table
Is there a method to compare the same field in two different records in a table to end up with a calculated result in both records.
Forum Discussion
I'm well, still having fun with Quick Base.
I think that there is an easy answer to Skins. I will describe in once and you can repeat 17 more times
I assume that the setup is that 1 Skins Competition has many Players.
Make a Summary of the Minimum of the score on the field [Hole 1 score]. Let's say for example that the low score on hole 1 was a 3.
Next Make a Report Link field on the Skins Competition record. On the left side select that summary field. ON the right side navigate back to your app, and to the fields for the players and select [Hole 1 score].
Put that [Report Link Hole 1 field] field on the Skins Competition record and show the player records on the form. That will be a little report of all the player(s) who git the low score of 3.
Then just repeat 17 more times by copying and adjusting that summary field and copying and adjusting that report link field.
Then you will be able to look at the Skins Competition record and see 18 little embedded reports of who got the low score on each of the 18 holes.
I think that there is an easy answer to Skins. I will describe in once and you can repeat 17 more times
I assume that the setup is that 1 Skins Competition has many Players.
Make a Summary of the Minimum of the score on the field [Hole 1 score]. Let's say for example that the low score on hole 1 was a 3.
Next Make a Report Link field on the Skins Competition record. On the left side select that summary field. ON the right side navigate back to your app, and to the fields for the players and select [Hole 1 score].
Put that [Report Link Hole 1 field] field on the Skins Competition record and show the player records on the form. That will be a little report of all the player(s) who git the low score of 3.
Then just repeat 17 more times by copying and adjusting that summary field and copying and adjusting that report link field.
Then you will be able to look at the Skins Competition record and see 18 little embedded reports of who got the low score on each of the 18 holes.