Hi, I’m not new to Airtable but I’m still very novice. I’m sure there is a way to do this but I can’t figure it out.
I run a horse show association where our members earn points. They can earn awards in 3 different areas, all are captured within our Airtable bases. I figured out groups and then adding the sum to the summary row. But how do I get an output for this, into a report or html I can insert into our website? Here is an example of what I’m trying to do:
Name - Class - Division - Points
John - Apples - Fruit - 5
John - Oranges - Fruit - 4
John - Green Beans - Vegetables - 3
John - Asparagus - Vegetables - 2
So I need to be about to output 3 things - total points (all points added together) so for John this would be 14 points. Then I need John’s points by Division - so for John this would be Fruit - 9 and Vegetables 5. Then I need it for each Class - so Apples - 5; Oranges - 4; etc.
I can get my bases sorted/grouped to give me the sums correctly, but then I don’t know what the next step is to produce a report that is usable and postable for our website.
Thanks in advance for all help!