INNERJOIN in appsheet

[SyDyJo]

Hello,

I want to get a data in another table. it is possible in appsheet ?

exemple :

i have two tables : families and members

for one familly i have many members

in my members table i have one data which is "responsible".

I want to get first name and last name when responsible = yes and i want to get it in families table

[Swoopy]

AppSheet is a RDBMS like platform. The relation/join is called as 'ref' in AppSheet. You can learn how to join tables either from documentation or many Youtube.

[frankarv]

Just like @Swoopy  said, you will have to make that column a ref type, and link it to the table you want... 
you'll need to check where is the key and label values of the table you are extracting information.

The ref will search for the key and will return the label
If you want to bring another value from the same table you will deref that value likes this:

[First Name].[Family] or [Last Name].[Family] depending on what your column names are... **Notice the "." between each column

[SyDyJo]

I know i have use ref in my table member but I want to get the name column in my families table because I would like print name column if the member is a responsible in my view

[frankarv]

https://support.google.com/appsheet/answer/10107396?hl=en#:~:text=A%20dereference%20expression%20get....