I have a table with 5K+ rows of data as such:table1Date - Year(formula of date) - Month(formula of date) - DataPoint1/1/2020 2020 01 5461/2/2020 2020 ...
Well, despite hunting a lot before I posted, I'm finding many answer after I posted. This seems a relevant answer with an example base (and basically what I am already doing). https://community.airtable.com/t5/base-design/totaling-multiple-fields-bas...
This seems a relavant previous discussion from a few years ago - https://community.airtable.com/t5/development-apis/how-can-i-get-a-grouped-record-with-api/td-p/120118 - idk if there are better solutions now then I have laid out above.
I just put in an automation to populate the linked field so it will pull in each new entry to my summary table2 and add new years as time goes on. It seems to work. Still feels very clunky, but since I'm not relying on interfaces or record grouping c...