How do i slect multiple columns

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?

Solved Solved
0 4 910
1 ACCEPTED SOLUTION

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.

See also:



View solution in original post

4 REPLIES 4

Would you please take a printscreen from your template so we could see what you have tried already, thanks.

To be honest I havenโ€™t got a clue how to create a select statement that will return multiple rows with 4 columns.
Just knowing that would probably be enough to get me started.
Can you help?

Not sure if this thread is solved or not but I think you still seem to be having issues,

Again, not sure If Iโ€™m understanding your question correctly,

I would make a template like this, and use this as your email bodyโ€ฆ something along these lines. I personally am fond of just using slices wherever I can. Donโ€™t know whats more efficient. So i would make a slice that capture only the unpaid rows for the customer and only include the columns you need.

Template: You can also just make the borders white if thats more of what your looking for. Below should give you an idea.
2X_e_e6d0ebabc0e0610e6342ca8a44ebd968093b99b9.png

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.

See also:



Top Labels in this Space