Create List in Automation Email Template

[MM_Group]

Hi All

I need to place a list of parts outstanding in an email template, I know what information I need but don't know how to filter it and display it in the template. So below is the crux of what it required.

List parts from table "Parts" where the 'Status' = ORDERED  and the JOBID = JOBID

This is the template the script needs to be put so it returns the values. Ideally the list will be one column ( example 😞

Nut

Scew

Bolt

Can anyone assist with the syntax to acheive this?

EDIT: This nearly works but returns a date stamp also :

<<IFS(
ISNOTBLANK([JobID]),
FILTER(
"Recalls",
([_THISROW].[JobID] = [JobID])
)
)>>

Result:

09/05/2023 07/06/2023 12:23:44 L/R DOOR MOULDING , 09/05/2023 07/06/2023 12:23:44 L/R DOOR FOIL

Can the expression be changed to omit the date stamp?

Many Thanks

[Marc_Dillon]

https://help.appsheet.com/en/articles/961746-template-start-expressions

[MM_Group]

Thanks @Marc_Dillon 

I used this:

<<Start:Filter(Recalls,[JobID=[_THISROW].[JobID]>><<[Description]>><<End>>

And it breaks the App, any ideas?

[scott192]

<<Start:Filter(Recalls,[JobID=[_THISROW].[JobID]>><<[Description]>><<End>>

Close your bracket after the first mention of JobID and before the =

[MM_Group]

Yes I noticed: @scott192 

<<Start: Filter(Recalls, [JobID]=[_THISROW].[JobID])>><<[Description]>> -#- <<End>>

Is there a way of putting a carriage return after [Description] so each item is forced to a new line?

Screw

Clip

Bracket

etc

[Marc_Dillon]

Add the line break in your template.

[MM_Group · Accepted solution]

👍

<<Start: Filter(Recalls, [JobID]=[_THISROW].[JobID])>>
<<[Status]>> :<<[Description]>><<End>>