Hello Teams.
I have a collection to put on HTML text:
ClearCollect(
ItemforHTML,
AddColumns(
Filter(
[@EvenList],
Text(
TglEvent,
"dd/mm/yyyy"
) in Text(
varNewDate,
"dd/mm/yyyy"
)
),"NumberRows",0
)
);
Set(VarNumber, VarNumber + 1)
This is the HTML text:
"<table style='background-color: lightgray; border: 1px solid black;'>
<tr>
<th style='background-color: gray; border: 1px solid black; text-align: center;'>Number</th>
<th style='background-color: gray; border: 1px solid black; text-align: center;'>Title</th>
<th style='background-color: gray; border: 1px solid black;text-align: center;'>Description</th>
<th style='background-color: gray; border: 1px solid black;text-align: center;'>Location ($)</th>
<th style='background-color: gray; border: 1px solid black;text-align: center;'>Tag</th>
<th style='background-color: gray; border: 1px solid black;text-align: center;'>Picture</th>
</tr>" &
Concat(
ForAll(
ItemforHTML, // Collection Name
"<tr>
<td style='border: 1px solid black;text-align: center;'>" & VarNumber &"</td>
<td style='border: 1px solid black;text-align: center;'>" & JudulEvent &"</td>
<td style='border: 1px solid black;text-align: center;'>" & KeteranganEvent &"</td>
<td style='border: 1px solid black;text-align: center;'>" & EventsKM &"</td>
<td style='border: 1px solid black;text-align: center;'>" & TagEvent &"</td>
<td style='border: 1px solid black;text-align: center;'><img src='" & LookUp(EVENTS,Substitute('File name with extension',Right('File name with extension',6),"")=IdEvent,'Gambar mini'.Large)
&"' alt='Image' style='width:300px; height:200px;'/></td>
</tr>"
), Value
)
& "</table>"
I need to have a column that numbers all the items in the table automatically starting from 1 till the end of the table rows (1, 2, 3 and so on). I tried assigning the VarNumber for Number Header but it returns blank.
The image below showing items in Number column are still blank
HTML Table preview
How do I create that column?
Please help.
Thank you
