Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 15, 2018 01:55 PM
I want to have a simple dashboard record that can summarise information from one (or more) other tables. I want to count the records and total some fields. I have managed to make this work by including a field that I can use the rollup on, but this means in each new detail record I create, I have to link it to the summary record in the dashboard table.
Is there a way I can simply and automatically summarise data into may dashboard table which I want to have just the one summary record in?
Eg
Dashboard Table: 1 summary record
Columns: Total games played, Total time played, Total goals scored
Game Table: 1 record for every game
Columns: Date Played, Start Time, End Time, Time Played (date diff…), Goals Scored, Goals against, etc etc.
Jan 15, 2018 02:06 PM
Are you on a Pro plan - if so you can get access to the Blocks features which are still in beta. This has pivot table, graph and other features which offer quite a lot of things you will find useful.
Otherwise you are probably on the right track - but don’t forget the option to summarise with grouped views.
Another thing you could consider is to use Zapier to fill in the linked fields for you automatically when the record is created.
Jan 16, 2018 11:25 AM
Three comments:
{Key}
field, pressing Ctrl-C
to copy the value, clicking in or Right-Arrow
ing to the linked records field, and pressing Ctrl-V
to paste the value. Airtable responds by creating the applicable linked record with a minimum of fuss. The ‘completely’ solution uses Zapier to do essentially the same thing.)Jan 16, 2018 12:19 PM
Great ideas, thank you.
:grinning:
Nice dashboard btw… :grinning: