LIST EXPRESSION

[astroboy1970]

Hi,

I have a table COURSES (columns : id_course | description)

example

00000001 | "Math1"

00000002 | "Math2"

00000003 | "Robotics 1"

in my app I have some expression that give me a List of some id_course's. It may be for example 

example

example  1: Result of expression ="00000001","00000003"

Example 2: Result of expression = "000000002"

My problem is, I need the description's and not the id_courses's

in the previously example I need the result

example 1: "Math1, Robotics 1" 

example 2 " Robotics"

How could I achieve this?

Thanks

[dbaum]

Are you already using the following features?

• Add row labels - AppSheet Help to govern which of a table's column(s) displays instead of the key column in many situations
• Use Dereference expressions - AppSheet Help to obtain values from a parent table using the key column that links it to a child table
• Use virtual columns - AppSheet Help to add columns in a table that directly contain values from other tables