Solved: How do i slect multiple columns - Page 2

Neil_Turner · 12-30-2019 05:48 AM

Hi
I have created a behaviour that emails me a report of unbilled hours for a customer.
I would like the body of the email to contain a table with 3 columns (date, notes, hours) for every row from my TASKS table.

The SELECT function only seems to be able to return values from one column

How can I get the values from 3 columns in my table into the body of my email?

Steve

AppSheet’s SELECT() function will only return a single column’s value from each matching row.

In this case, your email template will need a <<Start>>/<<End>> pair that uses FILTER() or SELECT() to gather the desired rows from the table or slice that has the desired columns. Between the <<Start>> & <<End>> tags, you can reference the columns individually as normal (e.g., [hours]). @Jonathan_S shared a good example of this above.