Help - e-mail body / related detail order

[Jf_Hermanns]

Hello !

I created an application to take orders by phone.

In the confirmation email, in the order summary table, I can’t find the “order details” information.

See attach

Thx a lot !!

[Suvrutt_Gurjar]

Please try with

<<START:SELECT([Related Order Details], [Order Status]=“Open”)>>

(But this assumes that [Order Status] column is in “Order Details” table. )

instead of

<<START:SELECT([Related Order Details][Order Detail ID], [Order Status]=“Open”)>>

[Suvrutt_Gurjar]

Suvrutt_Gurjar:

( But this assumes that [Order Status] column is in “Order Details” table. )

Could you please respond on this assumption?

[Jf_Hermanns]

• Error 1 : ‘Handle new Orders record’ task ‘Send an email 2’ Body template. Expression ‘SELECT([Related Order Details], [Order Status]=“Open”)’ is invalid due to: SELECT has invalid inputs.

• Error 2 : ‘Handle new Orders record’ task ‘Send an email 2’ Body template. Start expression ‘SELECT([Related Order Details], [Order Status]=“Open”)’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.

[Jf_Hermanns]

Sorry, no the question, order status is in the orders table.

[Suvrutt_Gurjar]

Then please simply use

<<START:[Related Order Details]>>

Your template has only one [Order ID] , so having [Order Status]=“Open” makes no sense. The status of all “Order Details” will be based on parent Order.

[Jf_Hermanns]

Thx, it works for orders with “complete” status;

But for “open” orders, it’s still empty :

Thank you so much for your help !

[Jf_Hermanns]

I’ve 2 status :

& 2 different types of e-mails :

& don’t understand why the confirmation order works, but the table in “open” order does’nt…

[Suvrutt_Gurjar]

Sorry to know that, I believe that will depend upon some more aspects such as how the bot is set up and column settings, etc.

In general, such troubleshooting could take longer but please feel free to ask in the community if you face in specific issue (meaning any error displayed, etc.)

[Suvrutt_Gurjar]

If you are having a slice for ‘Open Orders" and if your “Orders” table is having a rev ref column something like [Open Order Details], then please use <<START: [Open Order Details] >> in that particular’ BOT’s template.

[Suvrutt_Gurjar]

Suvrutt_Gurjar:

if your “Orders” table is having a rev ref column something like [Open Order Details],

Do you have this rev reference column in the “Orders” table? Then please use it in the START expression as suggested.

[Jf_Hermanns]

Indeed, I’ve a slice table for open orders :