How to Join two tables in one view

Rehan_Ahmed_Kha · 07-30-2020 12:32 AM

LeventK

Unfortunately you can’t join tables in one view

Rehan_Ahmed_Kha

How to compose email in appsheet when i select the multiple table rows?

Maple_Aikon

You can merge 2 table in google sheet, and then display the merged table in AppSheet
Follow this link to know how to merge 2 table: https://infoinspired.com/google-docs/spreadsheet/merge-two-tables-in-google-sheets/

LongingToProgra

My workaround with this has been with virtual columns.

So in my example I have a master table and a child table and I want to show the information from both in one view. On the Child table I created virtual fields that reference the columns from the master table.

Then I create a slice for the child table that only includes child records and use that for the places that I don’t want to use the merged info. Then I create another slice that includes both the child records plus the new virtual columns to the master table. Then create your view based on the merged slice and voila you have a “merged” table.

Sheldon_Lee-Wen

What was the expression you used to do this? Can you post something that will help the rest of us reference something in another table and bring it in to the other?

Steve

makrand17

Can you tell in detail- how do you create that reference to the other table column?
Is a query needed in expression of new virtual column ?