HTML table concat

[Broly123]

Hello! I used tabular data for the HTML code and On the Concat I inserted my own values. However, The table is still showing the previous information from the original table, probably because I didn't do something right.

This is what I have in my formula.

Concat(Gallery3.AllItems,
             "<td>" & ID  & " </td>
              <td>" & Description & " </td>
              <td>" & Qty & " </td>","</tr><tr>") &
"</table>"

Do the values have to be exactly what's named in my collection?

Or do they have to be what's named in the gallery? (ex. Text=ThisItem.ID)

thank you to whomever can help!

[madlad]

The code looks correct here to display a table with all items of your gallery; what exactly do you mean by showing information from the original table?

What's the extra info that you have that you want to not show up, and what's the rest of your html look like?

[timl]

@Broly123 

Did you add text input controls to your gallery to allow the user to modify the collection values and is this what you want to show in your HTML? Is this what you you mean when you refer to the HTML showing 'origianl' data?

If that's the case, you can reference the content of the gallery controls like so:

Concat(Gallery3.AllItems,
             "<td>" & ID  & " </td>
              <td>" & txtDescription.Text & " </td>
              <td>" & txtQty.Text & " </td>","</tr><tr>") &
"</table>"

[Broly123]

@madlad @timl  Thanks for coming in again to help! This is the original code I used and the original concat is at the bottom. Even though I changed it to my values, its still reading the original concat information

This is what I have in my formula.

"<h3>Invenory Order</h3>" &

"<table width='100%'> " &
     "<tr>
     <td> Order ID: </td> <td>" & varRecordOrderID.'Order ID' & "</td>" &
     "</tr>" &
     "<tr>
         <td> User: </td> <td>" & TitleTxt.Text & "</td>" &
     "</tr>" &
     "<tr>
         <td> Date: </td> <td>" & Today() & "</td>
     </tr>" &
     "<tr>
         <td> Date Needed: </td> <td>" & DatePicker1 & "</td>
     </tr>" &
"</table> <br>" &

"<strong> Items: </strong>" &
"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
     "<tr style='background-color:#efefef'>
         <th>Id</th> <th> Name </th> <th> Description </th><th> Accessories </th>
     </tr>
     <tr>" &
         Concat(Gallery3.AllItems,
             "<td>" & ID  & " </td>
              <td>" & Description & " </td>
              <td>" & Qty & " </td>","</tr><tr>") &
"</table>"
              

And the this is what I get back in email. The original concat info

 

[Broly123]

@timl @madlad I figured it out the table. I have to change the table names in the html code smh Thank you!