Hello everyone! I'm at my first try using Ap...

Hello everyone!

Iโ€™m at my first try using AppSheet. Studying every project and tutorial I prepared a Google Sheet table with the required table sheets, every table have a relation by ID that is an eight chars alphanumeric unique ID. Then I linked every foreign key in tables with the corresponding โ€˜primaryโ€™ key in related table. I didnโ€™t like much to repeat entire text fields in every table, so I thought it could be simple to create virtual fields

or anyway to display linked fields in related table, but until now Iโ€™m stuck with fails and trials without any success. The problem I was not able to find tutorials that face up with a full related database made of random 8 characters unique keys and foreign keys and can wiew or edit related fields. Can anyone help me? Thank you!

0 1 300
1 REPLY 1

Check out this article about Dereferencing; in other words ability to access and display those fields from related tables via their foriegn key in the referring table:

intercom.help - Dereference Expressions Dereference Expressions intercom.help

Top Labels in this Space