Solved: Issue with Template using <<Start>> and <<End>>

Caden_Davis · 10-22-2021 06:45 AM

I am using a form with a header/lines setup and upon additions to the header table, I’m sending the data through to a task (based on some conditions) to email the submitted information out.

I wanted to change the reply-to address so I’m using a non-default output configuration and I chose to let AppSheet create the output body template for me:

However, when I get the email, I’m missing all of the “lines” and only get the header information even though the lines are referenced exactly as this document lines out:
Using Start expressions in templates | AppSheet Help Center

When I look at the event monitor, the referenced lines (VC) just shows: “” even though there are lines which reference the header.

Event Monitor

Data source (showing a line w/ the same header ID)

It seems like a bug, but maybe I’m using the wrong approach?

Steve

View solution in original post

1minManager

Your START formula is missing the key column e.g.

<<START: [Related PO Request Lines][Key Column]>>

Steve

The original <<Start>> expression was fine: [Related PO Request Lines] is already a list of Ref.

Caden_Davis

@1minManager thanks for your reply!

I added that and I’m still getting the same results.

1minManager

Check that this column is not actually empty in the App

Also try this as well <<START: Select([Related PO Request Lines][Key Column],TRUE)>>

Caden_Davis

@1minManager well, the column “Related PO Request Lines” is a Virtual Column with the formula REF_ROWS(“PO Request Lines”, “Header ID”)

To clarify, am I supposed to be using the key column of the reference table (“PO Request Lines”) or the header table (“PO Request Header”)?

Here’s what I have:

Steve

Caden_Davis

Thanks Steve!

This worked!