When we Reference another Table trough a “Ref” Column, a “Virtual Column” is created on the target Table named “Related Rows”…
How can I make those Referenced items, appear as a List, separated by “commas”, on a “regular” column from my sheet ? I just want to be able to “export” the database and have those referenced items appears in a cell…
I tried with the “REF_Rows” formula from VC, Appsheet doesnt allow me to use a “LIST” type column if not virtual..
I tried with “text” Column which reference that VC. But not working also…
Yep, ran into the same thing. AppSheet doesn’t support non-virtual list-type columns, so you’ll need a workaround. What worked for me: create a Text column (not List), then use a virtual column with TEXT(REF_ROWS(…)) to generate the comma-separated string, and finally copy that value into the regular Text column using an automation (bot or action). That way it’s stored and exportable. Not super elegant, but it works.
In your regular column, use the same REF_ROWS() expression, but set the column type to EnumList with a base type of Ref and set the table appropriately.