connecting two tables

AppSheet AppSheet Q&A
1

I have two tables, one listing my products and the other one listing my suppliers of these products, how can I make a field at each supplier that shows the group of orders they deliver ?

2

https://support.google.com/appsheet/topic/10101919?hl=en&ref_topic=10099793

Reference is used to accomplish what you want to do.

1 Like
3

Thank you for your Answer, I tried this before but what I wanna do is not just link these two tables but also have a field by each supplier that shows what products they do deliver

4

By default the records of the child table are displayed as ref_rows but you can customize this list with the use of select() using a virtual column called for example [Related_Custom]. In the parent table you add the virtual column and put this expression:

select(Child Table[id_chlidtable],

[idcolumn searched in table]=[_thisrow].[ idcolumn searched in table]).

This will appear as inline view.

I hope I was able to help.