Template <<Start>> Expression

[scott192]

I have a problem with a template start expression that gives errors about not being able to find column names if I move the <<End>>

Here is a screenshot of what works fine :-

Works

Yet if I move the <<End>> so that I could insert a subview of those records into the blank table at a later time, the Editor tells me it cannot find any of the fields.

Won't work

What's going on?  

[scott192 · Accepted solution]

I seem to have solved my own problem 🙂

I moved the <<Start:[Related ProjectItems]>>  part outside the table rather than being inside the first cell.  Now there are no problems with the expression!

[Suvrutt_Gurjar]

Could you mention what you mean by subview? Are those columns belonging to the same record or child records?

[scott192]

Haven't even compiled a subview yet @Suvrutt_Gurjar .  I just cannot understand why moving the <<End>> makes the whole expression fail?

[scott192 · Accepted solution]

I seem to have solved my own problem 🙂

I moved the <<Start:[Related ProjectItems]>>  part outside the table rather than being inside the first cell.  Now there are no problems with the expression!

[Suvrutt_Gurjar]

Nice. Excellent to know you solved it, I was essentially recommending the same approach( Moving START outside. ) I tried to be elaborate in compiling the entire template and hence the response took time. Many times these template responses need to be very accurate as even one misplaced START or END can cause an issue. 🙂

[scott192]

Totally!  And I've forgotten the amount of times a left out ')' has foiled me for hours!

[finkployd]

This is the issue im facing right now.

From AppSheet's original documentation, it taught differently, meaning the start expression was in the table of their examples.

But now since its not updated, I've been led with un-updated formulas and guidance to follow.

[Steve]

Please start a new topic for help with this.

[Suvrutt_Gurjar · Accepted solution]

Thank you. Please try a template something like below.

I think templates expect the <<START:... >> and <<END>> pair either both within the same table columns or both outside.

Please also note the overall one cell table within which the entire template is included. I think that one cell you will need if you have some other ( say parent table's ) template expressions also included. Those parent table expressions can be outside this one cell table.

 <<START : [RelatedItems]>>

Amount	Name	Individual Cost	Cost
<<[Amount]>>	<<[Name]>>	<<[IndividualCost]>>	<<[Total Cost]>>

Sub Item	Unit Cost	Unit	Amount	Length	Workers	Cost

 <<END>>

[scott192]

Thank you @Suvrutt_Gurjar .  We both came to the same solution 😀