Start template result blank

[Thales_Taranto]

I'm stuck at a stage of my app that needs a template report from a work order (generating a quote PDF), everything is showing except the Service description. My data structure and it relationships are described bellow:

Order Table

Order ID

(etc)...

WorkOrder Table

WorkOrder ID

Order ID (ref - Order Table)

(etc)...

WorkOrderDetails Table

WorkOrderDetails ID

Work Order ID (ref - Work Order Table)

(etc)...

Quote Table

Quote ID

Order ID (ref - Order Table)

(etc...)

My bot is associated to Quote's table. And i'm not being able to get the WorkOrder Details on the report, it is blank. My start expression is:

<<Start:SELECT(WorkOrder[WorkOrder ID],[Order ID]=[_THISROW].[Order ID)>><<[Related WorkOrderDetails]>><<End>>

[Steve]

Please post a screenshot of your template.

[Thales_Taranto]

Okay, the data i told was in portuguese ans i transleted for better comprehension in the question. But i can create a English template for the purpose of better understanding.  Also i just changed Order ID ref in Quote to ENUM ref column. (i needed this change to stablish another type of relationship when the type of order changes)

Here are all the columns used structure and location:

Proposta - Quote Table

Data_Proposta - Quote Table

Emails - Quote Table (Virtual Column)

Valor _Proposta - Quote Table

Forma_Pagamento- Quote Table

Validade_Proposta- Quote Table

UserName- Users Table

Related Descrição_Manutençãos - WorkOrderDetail Table

Descricao_Equipamento_Inst- Equipament Table

Nome - Client Table

[Steve]

Could you also post a screenshot of a generated report that demonstrates the problem?

[Thales_Taranto]

Ok. Here it is: 

[Steve]

Thanks!

You need to configure your template to explicitly include all the data you want. If you want individual column values from Related Descrição_Manutençãos, you'll need to reference them as you have other column values in your template already.

Also, Related Descrição_Manutençãos is a list of Ref values. To access the column values of each of those rows, you'll need to use another <<Start>>/<<End>> block. In this:

Replace <<[Related Descrição_Manutençãos]>> with <<Start: [Related Descrição_Manutençãos]>><<End>>, then reference the column values you want displayed within that block.

[Thales_Taranto]

Hey Steve, I managed to get what i wanted but now the list are retuning in a single line and togethe even if i put them inside a table it still returns a single line list as bellow.

This is the actual start formula 

<<Start: Filter(“Orders”,Contains([Related Quotes][ID_Order],[ID_Order]))>><<Start:[Related WorkOrder]>><<Start: [Related DetailWorkOrder]>><<[WorkDescription]>><<End>><<End>><<End>>

[Steve · Accepted solution]

Try putting line breaks in your expression where you'd want them to occur in the output.

[Thales_Taranto]

Thank you Steve!!! Everything looks fine now.

[bolognesiedalla]

hi Steve. I have the same problem of displaying the enumlist in a template (ie I see all the values ​​in a row stuck). My Enumlist in Appsheet uses this list separator "|", where should it be placed in the expression to generate the right display with rows below each other?

this is my expression ([OBIETTIVI] IS THE ENUMLIST TYPE REF):

<<IF: isnotblank([OBIETTIVI])>><<Start: [OBIETTIVI]>><<[NOME]>><<End>><<EndIF>>

[Steve]

Try this:

<<IF: isnotblank([OBIETTIVI])>><<Start: [OBIETTIVI]>>
<<[NOME]>><<End>><<EndIF>>

[bolognesiedalla]

Thanks Steve.  Works perfectly!!