Lookup and rollup field pointing to a formula field in a related table | Voters

Lookup and rollup field pointing to a formula field in a related table

Tobias Milz

My use case is to track co2e in different fields. So there is a table for fleets, a table for business travels, for electricity and so on... Now I would like to have a table which rolls up all the co2e of the tables and puts it together in a new table.

Like an overview

January 11, 2023

Adrien Jorge

This can be achieved with Airtable Sync, just sync 2 tables to 1: https://www.airtable.com/guides/scale/sync-data-into-airtable

Tobias Milz

Adrien Jorge: Hi Adrien, thanks for the hint. Can I use synced airtable with Stacker tables or do I have to move all my tabels to airtable?

Adrien Jorge

Tobias Milz: Synced Airtable tables is for Airtables tables only. I don't think Stacker tables can do that yet but Stacker would know best (I'm just a customer using mostly Airtable Tables).

Tobias Milz

Alright! Thanks for your help. I think I have to stick to stacker tables due to the permissions.