
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 04, 2020 06:37 PM
I’ve searched this topic but I’m obviously missing something because it seems too simple …
I have a table of parts, each of the parts have a cost so the table has a Total column.
I want to have that Total value appear in another table (then I’ll be deducting that value from corresponding columns to generate another figure.
How do I simply reflect the value from a column in 1 table, in another table?
Like I said, it seems crazy simple…

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 04, 2020 08:44 PM
Hi @Herbshirt
You have to link every record from the {Parts} table to a single record (a summary record) in your other table where you want the Total to show up. Then, in the {Totals} table you’ll need to use a Rollup function to get the total from all the linked {Parts} records.
It looks something like this:

Airtable: Organize anything you can imagine
Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 05, 2020 01:42 AM
When you say 'link every record" - what if I have a hundred rows??

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 05, 2020 02:54 AM
You can copy the value from one and paste in the others (select full column clicking the header and paste).
