Rollup field in a table twice removed from source data through linked fields
Hi,
I have a question related to linked fields.
I have 3 tables:
- Store table (list of stores in my marketplace)
- Products table (my inventory) - one of the fields in my products table is a linked field to the store table (indicating which store each product belongs to)
- Order table - here I gather my orders. One of the field is a linked field to the products table. Through that linked field, I lookup the store linked field from the Product table. And it appears as a linked field in the Order Table.
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
