LinkedIn
Twitter
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:
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.
It is connected to the Incoming via the "Incoming Link" column. These are the settings for the field/column
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:
Nonetheless, even if AppSheet manages to create and link everything, the relationship doesn't show up in AppSheet.The Related Components are always 0:
These are the relevant column settings in the "Incoming" table:
Any idea about why AppSheet doesn't see them as linked? Is there anything I'm missing?
Thanks!
Hi Steve,
Thanks for the reply; I'll try to be more precise.
Starting from Airtable, I'm not using any special Airtable feature; it's a "normal" (for Airtable, at least) "Link record" field. It allows linking a record in a table to one in another hence creating a SQL-like relation. (here you can find out more https://www.airtable.com/guides/build/connect-data-with-linked-records)
In my case, a record in the Incoming table is linked to one or more (one-to-many) records in the Components table.
Airtable
Here's a better explanation of the Airtable's screenshots:
The Incoming Table is the one on top. As you can see, the Incoming record with EntryID: 14-90622 has 4 Components records linked to it. The one-to-many relationship between Incoming and Components records is shown in both tables with Incoming having the 4 Components records (their IDs) shown in the Components column and each component record having the "Incoming Link" populated with their "parent" Incoming record ID. Again these relation columns are a core feature of Airtable, nothing special.
Appsheet
The Components table column structure is the following:
It is linked to the Incoming table via the "Incoming Link" column. Here are the column's settings details:
As you can see Components "Is part of" Incoming.
The Ref relation works correctly both in Appsheet and Airtable. This means that in the Incoming creation form I can add as many Components as I wish and when I submit the form Appsheet is going to create one record in the Incoming table (in Airtable) and as many Components records as I've added in form in the Components table (in Airtable). Here you see the experience of adding a couple components in the Incoming Form:
As you can see, there's a warning sign but there's no mention anywhere (not even in Info > Errors) regarding what might be causing it. Anyway, the sign doesn't prevent from saving everything correctly as mentioned above.
The only missing piece of the puzzle is the Incoming table column structure. There are a lot of columns but the relevant ones are the Refs and the key/label. Here are three screenshots that shows the columns settings of pertinent columns of the Incoming table:
The Refs to Manufactures and Units refer to the two other tables as I mentioned in the original message and are most likely irrelevant in this matter. There's more than one field that refers to the Manufactures table but that is normal and non-problematic.
Conclusion
To quickly restate the issue: everything seems to be set up right and the creation of the records and the construction of their relation works. Nonetheless, when I go to the details of an Incoming record I always see "0 Related Components" even for the ones that I've just created successfully via the Incoming Form.
Hope it's clear now ๐ It might be related to the warning sign I've mentioned above but I don't have any error messages of any kind.
I appreciate the help!
Thanks
Hi @SkrOYC ,
Thanks for the reply.
If you mean changed anything in the [Related Components] column settings, I'd say no. Here you have the formula:
REF_ROWS("Components", "Incoming Link")The records appear both in Incoming view and in the Components one. Nonetheless, if I click on a component detail the Incoming Link field has a warning and its ID is shown instead of the label.
Clearly the issue is related to the relationship between the fields but I don't see how.
Cheers
