Table/(Grid with read only data) with coloring in email notification

Question

Can some suggest what is the best way to display a tabular data with coloring on rows in email body via a notification ? 
 Currently using ncolumntable() for table formation and used default html template in send email smart service for email body. 
 As the current requirement is to show the data in rows different color based on one of the column data (have some validations ) .I have tried using Ncoulmnstyledtable) , its not working . 
 Appian version is 16.3.

aloks0189 · Accepted Answer

Hi Soujanya B (soujanyab0001) i have tried to build a similar type of rule as yours to generate the template having table structure with dynamic data into their cells by considering apply() instead of a!forEach() as you are working with Appian 16.3, please find the source code below: Parent rule, which is needed to be invoke inside Email body: " "&apply( rule!PRTRR_CreateEmailBodySectionTable( PRTRR_PipelineList: ri!PRTRR_PipelineList, index: _ ), if( rule!APN_isEmpty(ri!PRTRR_PipelineList), {}, enumerate(1 + length(ri!PRTRR_PipelineList)) ) )&"

License Number	Line Number	Last Producing UWI	Activity Type	LastProduction Date	Date of Non-Compliance	Days to Non-Compliance

YELLOW -> Inactive Lines Requiring a Decision

ORANGE -> Non-Compliance Imminent

ORANGE-> Non-Compliant Pipelines " let's consider the rule input: PRTRR_PipelineList is of type CDT (Array) or Any Type here. The Child rule which is responsible to form having dynamic content for it's cell let's say: PRTRR_CreateEmailBodySectionTable concat( "", ""&index(index(ri!PRTRR_PipelineList, "lineNumber", null()), ri!index, null())&"", ""&index(index(ri!PRTRR_PipelineList, "uwi", null()), ri!index, null())&"", ""&index(index(ri!PRTRR_PipelineList, "activity", null()), ri!index, null())&"", ""&index(index(ri!PRTRR_PipelineList, "lastprod", null()), ri!index, null())&"", ""&index(index(ri!PRTRR_PipelineList, "nonComp", null()), ri!index, null())&"", ""&index(index(ri!PRTRR_PipelineList, "daysTo", null()), ri!index, null())&"", ""&index(index(ri!PRTRR_PipelineList, "daysToNonCompliance", null()), ri!index, null())&"", "" ) here we have 2 rule inputs: ri!index -> Type -> Number(Integer) ri!PRTRR_PipelineList -> Type -> CDT (Array) or Any Type You can modify the property names inside this Child rule as per your cdt properties such as: ActivityType, LastProductionDate etc.. and also you can have any conditional pre-check if required as per your business requirement. in my case: following is the input for the Parent rule, for demo: { { lineNumber: 123, uwi: "abc", activity: "test", lastprod: today(), nonComp: today()+1, daysTo: 2, daysToNonCompliance: 6 }, { lineNumber: 456, uwi: "def", activity: "test1", lastprod: today()+5, nonComp: today()+6, daysTo: 6, daysToNonCompliance: 17 } } which you need to change with your data, at later point of time. So at the end, when the parent rule executes, this generates your required response as shown below: Hope this will help you in building Dynamic Email Body for your scenario.

aloks0189 · Answer

Hi @Soujanya Soujanya B as per my understanding, you can create an expression rule(The Parent Rule) which returns the &

License Number	Line Number	Last Producing UWI	Activity Type	LastProduction Date	Date of Non-Compliance	Days to Non-Compliance

aloks0189 · Answer

Hi Rohan, as I can see, you are trying to perform string concatenation and also you are using if else conditions along with string concatenation, which might be causing you this issue where your conditional statements are also getting printed on the web page. 
 Also I believe, you might be missing the double quotes and html tag closure in order, which might be also one of the root cause. 
 I strongly suggest, use concat() instead of using &""& for string concatenation, this improves the readability and you can trace out root cause easily. 
 Hope it will help you

Alok Patro · Answer

You can create and use and HTML template to achieve your objective. 
You can define the colors and formats using the HTML and CSS and using them wherever applicable.

Alok Patro · Answer

in the CSS you can make the colors as parameter and do some R&D. I would be happy to see if that works. Not very sure though. 
Just a suggestion for you to try.

Table/(Grid with read only data) with coloring in email notification

Top Replies