Unfortunately, those summary bar numbers are not usable anywhere within Airtable. They are only available visually onscreen for cosmetic purposes only. You may want to email support@airtable.com to ask them to please make those numbers usable elsewhere in the product.
Your only 3 options are:
- link records & use rollup fields
- write custom JavaScripts, or
- use an external low-code automation tool like Make.com.
Hi Jan. I think your question illustrates one of the most common challenges people (with a spreadsheet background) have, when getting used to Airtable. It helps me to remember that, in Airtable, going “long” vs. “wide” in table design, gives more flexibility.
In your case, I would make the Investments table have 3 basic fields:
- Name - short text
- Quarter Ending - link field to your “Period summary”
- Value - Currency
I would simplify your “Period summary” table to remove the “Period” column (single select) and take the word “Period” out of your primary field.
Now, in “Period summary” you will have one row per year/qtr, the linked field to “Investments” (holding multiple values), and a rollup field for the total value that you want.
Make sense?
Thanks @augmented. It does make sense, thank you. I will see if I can implement it. :thumbs_up: