Related records not showing up as linked to parent table - Appsheet <> Airtable

Problem

Related records to a table don't show up as "linked" to its parent table. The creation of the records and the "linking" to the parent record in Airtable both work well. 

Nonetheless, even if they are all correctly linked in Airtable, the relation doesn't show up in AppSheet.

Context & structure

I have 4 tables:

Screenshot_2022-09-07_at_10_29_18.png

 

 

 

Incoming: where the incoming item is registered when it's received. Refs to Manufacturers and Unit are in place to select  the respective linked records in the tables (in Airtable).

Components: Table that "is part of" Incoming. Basically, they are the components of which an item in Incoming is made of. 

Screenshot 2022-09-07 at 10.30.14.png

 

 

 

 

 

 

It is connected to the Incoming via the "Incoming Link" column. These are the settings for the field/column

 

Screenshot 2022-09-07 at 10.30.24.png

 

 

 

 

 

 

 

As mentioned above, when creating an "Incoming record" and its components with the Incoming_From, everything works well. All the rows are created in Airtable, respectively the main record in the "Incoming" table and the related components in the "Components" table. All the records are correctly linked together:

 

Screenshot 2022-09-07 at 10.32.05.png Screenshot 2022-09-07 at 10.32.48.png

 

 

 

Nonetheless, even if AppSheet manages to create and link everything, the relationship doesn't show up in AppSheet.The Related Components are always 0:

 

Screenshot_2022-09-07_at_09_58_38-2.png

 

These are the relevant column settings in the "Incoming" table:

 

Screenshot 2022-09-07 at 10.29.44.pngScreenshot 2022-09-07 at 10.30.01.png

 

 

Any idea about why AppSheet doesn't see them as linked? Is there anything I'm missing?

Thanks!

0 11 400
11 REPLIES 11
Top Labels in this Space