Concatenate REF_ROWS List

AppSheet AppSheet Q&A
1

Hi!

I have the following situation:
Table 1: Products
Table 2: Recipes
Table 3: connects products and recipes in a many to many relation

In a products table view, I need to display a text collumn with all the recipes each product is related, delimited by “,”

I guess this involves using the Related Table3 virtual collumn, that has the REF_ROWS formula, but I’m not sure.

2

If I were building this, Table3 would have one Ref column [Product], and a second Ref column [Recipe]. This would auto-create the [Related…] VC in Product table. Then you can get all Recipes for a Product with [Related…][Recipe]

https://help.appsheet.com/en/articles/4575708-list-dereference

2 Likes