Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Feb 07, 2022 12:31 PM
Hi,
I have a question related to linked fields.
I have 3 tables:
The problem is that I would like to create a rollup field within the store table that relate to the Order Table but for some reason it doesn`t look like Airtable is following the relationship when there’s two table distance?
Here is a simplified view (much more complex in reality, with integration into Adalo through API)
Store table
Product table
order table
In this case for instance, I cannot calculate on the Store table how many orders each store has… And given my setup it`s not really possible for me to directly link Order Table and Store Table.
In the rollup field, I can only select the Product table, not the Order table
Let me know if you can think of a solution!
Many thanks,
Capucine
Feb 07, 2022 02:15 PM
Welcome to the community, @Capucine_Codron!
Unfortunately, Airtable only lets you pull data from one table away — and no more.
So you would have to repeatedly push your data from table to table using lookup/rollup fields, until your desired data is just one table away.