Get Ref Rows in email template

AppSheet AppSheet Q&A
, ,
1

Hello,

i have an app with 2 tables. Warehouse table with all items and orders table with all orders.

I’ve setup an action where i setup a unique number to selected rows in the warehouse and also the same action creates a row in the orders table where one of columns is set with the same unique number. Then in the order row that was created i have a ref_rows to the rows with the same unique number from the warehouse rows.

Now i am trying to generate an email from the data in the newly created row in the orders table, however i am not able to get the ref_rows values in the email template.

How can i do that?

2

This makes no sense. Using plain language, explain what you want to accomplish.

3

Post an screenshoot of the template as well as the columns of your tables

1 Like
4

sorry

In my orders table i have a ref_rows to the warehouse table. I want to generate an email which includes these ref_rows

This is what i want to get in an email - i used the template that appsheet is automatically generating

dpavlov_1-1646229059436.png
dpavlov_1-1646229059436.png751×714 32.6 KB

Orders Table

dpavlov_0-1646228941948.png
dpavlov_0-1646228941948.png895×612 47.1 KB

5

You need to post an screenshot of the template, showing it’s expressions.

Anyway, that “ref_rows” is a virtual column, probably called something like “Related blabla”

It’s a list of key values.

You need a Start: expression to show them as a table or list

https://help.appsheet.com/en/articles/961746-template-start-expressions

1 Like
6

below is the template - not getting any of the ref rows info

the ref_rows column is called Артикули

https://docs.google.com/document/d/1AJgk38ToVvPvtOMcJybZXQHuxIrB335ivJ9_8eYo1SQ/edit

7

Since you are using just one column of the other table, you could try:

<<SUBSTITUTE(
  CONCATENATE([Артикули][Status]),
  " , ",
  "
"
)>>
1 Like