Re: Html text Help

dandandsan · ‎03-02-2020

Hello,

Me Again!

I have created some Html text which is displaying data from multiple data sources, however, the first two tables are not display all the data and the only way it will is if I first select the gallery which is very strange!

Am I missing something?

"
<!DOCTYPE html>
<html>

<head>
  <style>
    Table {
      font-family: arial, sans-serif;
      border-collapse: collapse;
      width: 100%;
    }

    td,
    th {
      border: 1px solid #dddddd;
      text-align: left;
      padding: 8px;
    }

    tr:nth-child(even) {
      background-color: #dddddd;
    }
  </style>
</head>

<body>
  <h2>Dan's Stock Levels</h2>
  <h2>Toner</h2>
  <table>
    <tr>
      <th>Description</th>
      <th>Current Stock Level</th>

    </tr>" & Concat(
    BrowseGallery1.AllItems,
    "<tr>
      <td>" & Title1 & "</td>
      <td>" & Body1 & "</td>
    </tr>"
    ) & "
  </Table>
  <h2>Drum</h2>
  <table>
    <tr>
      <th>Description</th>
      <th>Current Stock Level</th>
    </tr>" & Concat(
    BrowseGallery2.AllItems,
    "<tr>
      <td>" & Title3 & "</td>
      <td>" & Body2 & "</td>
    </tr>"
    ) & "
  </Table>
  <h2>Chip</h2>
  <table>
    <tr>
      <th>Description</th>
      <th>Current Stock Level</th>
    </tr>" & Concat(
    BrowseGallery4.AllItems,
    "<tr>
      <td>" & Title6 & "</td>
      <td>" & Body4 & "</td>
    </tr>"
    ) & "
  </Table>
  <h2>Roller</h2>
  <table>
    <tr>
      <th>Description</th>
      <th>Current Stock Level</th>
    </tr>" & Concat(
    BrowseGallery3.AllItems,
    "<tr>
      <td>" & Title4 & "</td>
      <td>" & Body3 & "</td>
    </tr>"
    ) & "
  </Table>
  <h2>Fuser</h2>
  <table>
    <tr>
      <th>Description</th>
      <th>Current Stock Level</th>
    </tr>" & Concat(
    BrowseGallery5.AllItems,
    "<tr>
      <td>" & Title8 & "</td>
      <td>" & Body5 & "</td>
    </tr>"
    ) & "
  </Table>
  <h2>ITB</h2>
  <table>
    <tr>
      <th>Description</th>
      <th>Current Stock Level</th>
    </tr>" & Concat(
    BrowseGallery6.AllItems,
    "<tr>
      <td>" & Title5 & "</td>
      <td>" & Body6 & "</td>
    </tr>"
    ) & "
  </Table>
  <h2>Network</h2>
  <table>
    <tr>
      <th>Description</th>
      <th>Current Stock Level</th>
    </tr>" & Concat(
    BrowseGallery7.AllItems,
    "<tr>
      <td>" & Title10 & "</td>
      <td>" & Subtitle10 & "</td>
    </tr>"
    ) & "
  </Table>
  <h2>Misc</h2>
  <table>
    <tr>
      <th>Description</th>
      <th>Current Stock Level</th>
    </tr>" & Concat(
    BrowseGallery8.AllItems,
    "<tr>
      <td>" & Title12 & "</td>
      <td>" & Body8 & "</td>
    </tr>"
    ) & "
  </Table>
</body>

</html>"

jKell · ‎03-02-2020

Without knowing more of your data structure It is hard to say exactly what is going on. Your HTML is using the Gallery.AllItems instead of actual source data. It might be better to use the data source that is populating the gallery and just running a filter for your Concat(DatasourceForToner, "HTML STRING").

Maybe there is a delay in the gallery content loading so by clicking on it, it is refreshed and available to make the HTML Text. (Just a guess)

dandandsan · ‎03-03-2020

@jKell

Thank you for your reply.

I've changed the Html text to use the data source and now using the code which seems more stable, thank you!

The thing I'm struggling to do now is to add another table into the Html code, eventually, I would like the code to display four different tables from different data sources, can you help?

"<h3>Data Table HTML Email</h3>" &
"<strong> Items: </strong>" &
"<table width='100%' 
border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
     "<tr style='background-color:#efefef'>
         <th>Description</th> <th> Current Stock </th>
     </tr>
     <tr>" &
         Concat('Dan Toner Stock',
             "<td>" & Description  & " </td>
              <td>" & 'Current Stock Level' & " </td>","</tr><tr>") &


                
              
"</table>"

jKell · ‎03-03-2020

To make multiple tables, you can just repeat your code with different data sources. I noticed you may want to re-structure your Concat() so that it has paired Table Row statements. You will have an orphan opening tag with your existing implementation. But you can start with <TR> tag and end with </TR> tag.

//TABLE 1
"<h3>Data Table HTML Email</h3>" &
"<strong> Items: </strong>" &
"<table width='100%' 
border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
     "<tr style='background-color:#efefef'>
         <th>Description</th> <th> Current Stock </th>
     </tr>" &
         Concat('Dan Toner Stock',
             "<tr><td>" & Description  & " </td>
              <td>" & 'Current Stock Level' & " </td></tr>") &            
"</table>"
//TABLE 2
"<h3>Data Table 2 HTML Email</h3>" &
"<strong> Items 2: </strong>" &
"<table width='100%' 
border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
     "<tr style='background-color:#efefef'>
         <th>Description</th> <th> Current Stock </th>
     </tr>" &
         Concat('Dan Drum Stock',
             "<tr><td>" & Description  & " </td>
              <td>" & 'Current Stock Level' & " </td></tr>") &            
"</table>"

dandandsan · ‎03-04-2020

@jKell

Thank you once again.

I've tried copying and pasting the same code and this works fine when duplicating the same data table but when I change the data table for the second table it fails. It;s really starting to get personal now so I'm hoping you or someone can help!

This one works

"<h2>Dan's Car Stock</h2>
<strong>TONER</strong>
<table>
    <tr><th>Description</th><th>Current Level</th></tr>
    "&Concat('Dan Toner Stock',                                                                                                                                                            "<tr>
        <td>"&Description&"</td>
        <td>"&'Current Stock Level'&"</td>
 
    </tr>"                                                                                                                                                                              
    )&"
    
</Table>                                                                                                                                                                              
<strong>TONER</strong>
<table>
    <tr><th>Description</th><th>Current Level</th></tr>
    "&Concat('Dan Toner Stock',                                                                                                                                                            "<tr>
        <td>"&Description&"</td>
        <td>"&'Current Stock Level'&"</td>
 
    </tr>"                                                                                                                                                                              
    )&"
    
</Table>"

This one fails

"<h2>Dan's Car Stock</h2>
<strong>TONER</strong>
<table>
    <tr><th>Description</th><th>Current Level</th></tr>
    "&Concat('Dan Toner Stock',                                                                                                                                                            "<tr>
        <td>"&Description&"</td>
        <td>"&'Current Stock Level'&"</td>
 
    </tr>"                                                                                                                                                                              
    )&"
    
</Table>                                                                                                                                                                              
<strong>TONER</strong>
<table>
    <tr><th>Description</th><th>Current Level</th></tr>
    "&Concat('Dan Drum Stock',                                                                                                                                                            "<tr>
        <td>"&Description&"</td>
        <td>"&'Current Stock Level'&"</td>
 
    </tr>"                                                                                                                                                                              
    )&"
    
</Table>"

jKell · ‎03-04-2020

@dandandsan does the 'Dan Drum Stock' work by itself? I am not sure your data structure but each table would need to have the same column names "Description" and "Current Stock Level" or else it would break.

If the Drum Stock is working by itself, and the Toner Stock is also working by itself... I can't understand why they wouldn't work together.

Joel