xlsx attachment file related

[Mark_Pathfinder]

Hi, i made an app for to prepare the orders and i need to send file xlsx only with the list of products.

I have 2 tables, ORDERS and DETAILS ORDERS, than i need to send the DETAILS related

At the moment i’ve a bots to send pdf file (WHEN NEW ROW CREATED IN ORDERS TABLE)

, i tried to change the kind of file to generate, but i receive only the order file without the relatives products. How can i do to resolve it?

@AleksiAlkio

[AleksiAlkio]

Did you generate the Bot/File right after the Parent with child records were saved? What happens when you try it again with existing records?

[Mark_Pathfinder]

it send a ORDERS TABLE

[Mark_Pathfinder]

i need products list (RELATIVES PRODUCTS) not ORDERS TABLE

[AleksiAlkio]

So.. what is your template? Please take a screenshot from it.

[Mark_Pathfinder]

This is the template

but it is the ORDERS LIST not the ORDER DETAILS, i used CREATE TEMPLATE.

[Mark_Pathfinder]

can you help me @AleksiAlkio please

[AleksiAlkio]

What is your START: expression in your Excel template?

[Mark_Pathfinder]

what do you mean? i attach all screen shot

When is update a row in ORDERS TABLE, send the file xlsx about the ORDER DETAILS.

In the first case it work with the pdf file correctly, in the second case a receive a list of all ORDERS

Wh0

[AleksiAlkio]

In your screenshot from the Excel template, it doesn’t show what that START: expression is. It shows just the beginning of it.

[Mark_Pathfinder]

I SOLVED:

The system don’t prepare the correct file: In START it autogenerate this code:

<<Start: Filter(Orders Table, true)>><<[Id Order]>>

The correct Sting is:

<<Start: SELECT(Order Detail[Id Detail], [Id Ordine] = [_THISROW].[Id Detail])>><<[Id Order]>>