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…
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 works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.
When you say 'link every record" - what if I have a hundred rows??
You can copy the value from one and paste in the others (select full column clicking the header and paste).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
