Skip to main content

Carry column from one table to another

  • September 11, 2020
  • 2 replies
  • 29 views

I have a table a that has a column with a paid field. I want another table column to bring over that paid field column only if it is filled. Not empty.

2 replies

  • Author
  • New Participant
  • September 14, 2020

So tomorrow I will look out for this.

It seems simple to be able to sum one column from one table and roll it up or view that total in a field in another table.


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • September 14, 2020

The sum of a column (as displayed in the summary bar) is not available outside of the summary bar. This is one of the ways that Airtable is different from a spreadsheet.

However, you can calculate the sum of linked records using a rollup field. If you want a record to use the sum of all the records in another table, that record needs to to link to all of the records in the other table.