Sending email template

Hi,

Please help with this. I tried to create an email template, upon adding it, it will automatically send an email to the recipient. My problem is the second table(reference table) on my template did not show on the email content that the recipient has been received. Please suggest what would be the correct formula/expression for this.

image

I m not sure your table schema, but this expression is causing an issue.

This expression should be returning NULL value for the moment, even your expression is “valid”

1 Like

Yes, it returns a null value for now.

P3 Demand - Child table that links to Demand table that’s why column name is “Related P3 Demands”

I want to get the value of the child table (Related P3 Demands) and reflect it on the email content.

Could you please suggest the correct expression?

Could you share the screenshot for that table, where we see the column configs.

1 Like

Please see attached image.

Sorry , what i mean was P3 demands table.

1 Like

1 Like

On your original expression, what do you want to do with 5 at the end?
Top 5 or so?

1 Like

For Controlling Record Order . to display 5 items only.

how do you define “5 only”?
Just display 5 rows max?

i m puzzled as well, “Record Order”

1 Like

yes, to display 5 rows max

For example I have 10 rows on my P3 Demands table, only 5 rows will reflect on the email.

The most latestly added 5 rows or something like that?

1 Like

yes, the most latest added 5 rows if it is possible

You need to define how you decide how to judge 5 rows based on your conditions.
Based on some dates, or max values etc. Your are missing that definition to get the rows out.

1 Like

On your screenshot, there is no column to hold date or datetime values, so you can rely on only row_number field.

1 Like

how about this expression:
<<Start:TOP(ORDERBY([Related P3 Demands],[_RowNumber],TRUE),5)>>

is it correct?

Try it out now with it.

1 Like

If it does not work then try this.

<<Start:TOP(ORDERBY(Select([Related P3 demands][P3 Demand ID],TRUE)),[_RowNumber]),5)>>

1 Like

It’s not working :frowning:

After I posted, i amended my typo, so

<<Start:TOP(ORDERBY(Select([Related P3 demands][P3 Demand ID],TRUE)),[_RowNumber]),5)>>

is what you tried?

1 Like