Email me CSV with Order details from all related tables

Filip_Kuna
Participant II

Hi,

I am developing the app where I can create an order after that I can add work and material from another two tables. I would like to get an email with csv that contains all the data related to that order. So also all the data from related tables. Right now, what I can do is just an email with csv with data just from order. Is there a way to include related data from another tables also? In every table I have just one row connected to that specific order.

Thanks for your help guys.

0 5 220
5 REPLIES 5

JuneCorpuz
Participant V

You can check this article:

Filip_Kuna
Participant II

Thank you, it helped but I need still a little bit of help.
I use this code in my template <<Work[Realizators]>> where work is table, realizators is a column. Now I need to specify that I want to send values just related to my order. This code right now print all values in that column, but I need value just from one row depending on reference. Could you please help me with making my code better please?

Hi @Filip_Kuna,

Did you try to use the:

  • Behavior/workflow/New Workflow Rule/Task : Send an email/untick โ€œUse default contentโ€,
  • then click on Attachment Template, then click on the โ€œCreateโ€ button
    to generate a template from your related items ?

You can try a similar process through the Behavior/Reports/New Report/etcโ€ฆ to achieve the same purpose.

Yes that creates template with values just from order table, but not from related ones.

Can you try, from table Work:

<<[Realizators]>>
<<[Adresa]>>
<<Start:[Related Movies]>><<[Movies]>><<End>>

Where [Movies] is the column you can to report from your detail table.
This assumes the [Related Movies] column is a โ€œchildโ€ from the โ€œworkโ€ table, i.e. a list of ref with formula REF_ROWS("โ€ฆ")

Top Labels in this Space