HTML Template in expression rule

Question

Hi Community, 
 i have a requirement to create a html template using expression rule to create a table. 
 i am able to create a table but i am unable to generate borders for each row and headers. please prefer below code snippet. 
 
 TIA 
 Stefan Helzle

Harsha Sharma · Accepted Answer

You can try the below a!localVariables( local!dataDict:{ { name:"ABCD", age:25, company:"AS" }, { name:"QWER", age:27, company:"AT" }, { name:"SDFG", age:28, company:"Ay" } }, local!columns:{ { column: "name", width: 10}, { column: "age", width: 20}, { column: "company", width: 40} }, "" & joinarray( a!forEach( local!columns, "" ), "" ) & "" & joinarray( a!forEach( items: local!dataDict, expression: "" ), "" )&"

" & fv!item.column & "
" & fv!item.name & "	" & fv!item.age & "	" & fv!item.company & "

" )

Shubham Aware · Answer

Try this Update values as per your need. a!localVariables( /* Sample data - replace with your actual data source */ local!dataDict: { {id: 1, name: "John Doe", department: "Engineering", salary: 75000}, {id: 2, name: "Jane Smith", department: "Marketing", salary: 65000}, {id: 3, name: "Bob Johnson", department: "Sales", salary: 70000}, {id: 4, name: "Alice Brown", department: "HR", salary: 60000} }, /* Column definitions */ local!columns: { {column: "ID", width: 10, field: "id"}, {column: "Employee Name", width: 30, field: "name"}, {column: "Department", width: 30, field: "department"}, {column: "Salary", width: 30, field: "salary"} }, /* Generate HTML Table - Choose one of the options below */ /* Option 1: Fixed width (800px) */ "" & /* Option 2: Maximum width with auto sizing */ /* "

" & fv!item.column & "
" & fv!item.name & "	" & fv!item.age & "	" & fv!item.company & "

" & */ /* Option 3: Percentage width (80% of container) */ /* "

" & */ /* Option 4: Full width (current behavior) */ /* "

" & */ /* Table Header */ "" & joinarray( a!forEach( local!columns, "" ), "" ) & "" & /* Table Body */ joinarray( a!forEach( items: local!dataDict, expression: "" & "" & "" & "" & "" & "" ), "" ) & "

" & fv!item.column & "
" & fv!item.id & "	" & fv!item.name & "	" & fv!item.department & "	" & "$" & text(fv!item.salary, "#,##0") & "

" )

Harsha Sharma · Answer

Just like you added style in table you can use border-bottom in the style tags of header (th) and row (tr). Below is an example

" & fv!item.column & "
" & fv!item.name & "	" & fv!item.age & "	" & fv!item.company & "

HTML Template in expression rule

Top Replies