Help

How to Copy & Paste "Sum" Values

898 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Francis_Carbone
4 - Data Explorer
4 - Data Explorer

I want to copy “Sum” values of grouped fields within a table, and a field’s “sum” value agnostic of groupings. The information exists, I can see it, but there doesn’t seem to be a way to copy the data for pasting into other fields and/or external applications. Currently, I have to visually reference and manually type the sum value to use the data. This is arduous and prone to errors.

I feel like I must be missing something obvious…Does anyone know how to perform this basic function?

Thanks in advance!

1 Reply 1

Welcome to the community, @Francis_Carbone!

Unfortunately, Airtable has given us no programmatic access to those values in the summary bar, which is a real bummer for everyone who uses Airtable.

Your only native option is to create another table, and then create a record which links to all the records that you want to summarize, and then create a rollup field that summarizes all the linked records.

There are some ways to automate this to make it easier, such as automating the linking from the first table (instead of the 2nd table).

Other non-native solutions include:

  • Writing a custom script.
  • Using an external automation tool such as Zapier or Make.com.