HTML Table

Hi, 

i have a use case where we already showing table using HTML, but now the user required two more columns on one condition else show the old table only 

can anyone suggest me

  local!revRowItems: a!forEach(
    items: local!crGlobalRevAppLimit_cdt,
    expression: {
      if(
        fv!isLast,
        "<tr>
<th class=""left"">Total Revolving Not to Exceed</th>
<td class=""left"">" & fv!item.currencyId_txt & "</td>
<td class=""center""> </td>
<td class=""center""> </td>
<td class=""center""><b>" & rule!CR_FN_setDecimalValues(
          value_dec: fv!item.limitAmount_0,
          decPlace_int: 2
        ) & "</b></td>
<td class=""center""> </td>
<td class=""left""> </td>
</tr>",
        "<tr>
<td class=""left"">" & rule!CR_APP_FN_LSS_getFormattedLimitAmountBasedOnFilters(
          crRefLimit_cdt: local!crRefLimit_cdt,
          limitName_bool: true(),
          crProductLimitCode_int: fv!item.crProductLimitCode_int
        ) & "</td>
<td class=""left"">" & fv!item.currencyId_txt & "</td>
<td class=""center""> </td>
<td class=""center""> </td>
<td class=""center"">" & rule!CR_APP_FN_LSS_getFormattedLimitAmountBasedOnFilters(
          crRefLimit_cdt: local!crRefLimit_cdt,
          limitAmount_dec: fv!item.limitAmount_0,
          crProductLimitCode_int: fv!item.crProductLimitCode_int
        ) & "</td>
<td class=""center"">" & fv!item.tenor_dec & "</td>
<td class=""left"">" & rule!CR_APP_FOL_FN_formatLSSPricingColumn(
          crAppLimit_cdt: fv!item,
          crRefIntRateKey_cdt: ri!crRefIntRateKey_cdt
        ) & "</td>
</tr>"
      )
    }
  ),
  local!nonRevRowItems: a!forEach(
    items: local!crGlobalNonRevAppLimit_cdt,
    expression: {
      if(
        fv!isLast,
        "<tr>
<th class=""left"">Total Non-Revolving Not to Exceed</th>
<td class=""left"">" & fv!item.currencyId_txt & "</td>
<td class=""center""> </td>
<td class=""center""> </td>
<td class=""center""><b>" & rule!CR_FN_setDecimalValues(
          value_dec: fv!item.limitAmount_0,
          decPlace_int: 2
        ) & "</b></td>
<td class=""center""> </td>
<td class=""left""> </td>
</tr>",
        "<tr>
<td class=""left"">" & rule!CR_APP_FN_LSS_getFormattedLimitAmountBasedOnFilters(
          crRefLimit_cdt: local!crRefLimit_cdt,
          limitName_bool: true(),
          crProductLimitCode_int: fv!item.crProductLimitCode_int
        ) & "</td>
<td class=""left"">" & fv!item.currencyId_txt & "</td>
<td class=""left""></td>
<td class=""left""></td>
<td class=""center"">" & rule!CR_APP_FN_LSS_getFormattedLimitAmountBasedOnFilters(
          crRefLimit_cdt: local!crRefLimit_cdt,
          limitAmount_dec: fv!item.limitAmount_0,
          crProductLimitCode_int: fv!item.crProductLimitCode_int
        ) & "</td>
<td class=""center"">" & fv!item.tenor_dec & "</td>
<td class=""left"">" & rule!CR_APP_FOL_FN_formatLSSPricingColumn(
          crAppLimit_cdt: fv!item,
          crRefIntRateKey_cdt: ri!crRefIntRateKey_cdt
        ) & "</td>
</tr>"
      )
    }
  ),
  /*Project Name - HTML Row*/
  local!projectNameRow_txt: "<tr>
<th class=""left"">" & ri!crAppProject_cdt.projectName_txt & " </th>
<td class=""left""> </td>
<td class=""left""> </td>
<td class=""left""> </td>
<td class=""left""> </td>
<td class=""left""> </td>
<td class=""left""> </td>
<td class=""left""> </td>
</tr>",
  /*Revolving HTML Row*/
  local!revolvingFacilityRow_txt: joinarray(
    {
      local!revRowItems
    },
    char(
      10
    )
  ),
  /*Non-Revolving HTML Row*/
  local!nonRevolvingFacilityRow_txt: joinarray(
    {
      local!nonRevRowItems
    },
    char(
      10
    )
  ),
  /*Total Project Amount HTML Row*/
  local!totalProjectAmountRow_txt: "<tr>
<th class=""left""> Total " & ri!crAppProject_cdt.projectName_txt & " Not to Exceed</th>
<td class=""left"">" & ri!crAppProject_cdt.currencyId_txt & "</td>
<td class=""left""> </td>
<td class=""left""> </td>
<td class=""center""><b>" & rule!CR_FN_setDecimalValues(
    value_dec: ri!crAppProject_cdt.proposedLimit_dec,
    decPlace_int: 2
  ) & "</b></td>
<td class=""left""> </td>
<td class=""left""> </td>
</tr>",
  /*Single LSS HTML Table*/
  local!facilityTable_t24: "<br></br><table id=""facilityTable"" style=""width:100%"">
<tr>
<th style=""width:40%"" class=""center"">Facility Type</th>
<th style=""width:5%"" class=""center"">CCY</th>
<th style=""width:30%"" class=""center"">Approved Limit (in '000)</th>
<th style=""width:30%"" class=""center"">Borrower Name</th>
<th style=""width:15%"" class=""center"">Allocated Limit (in '000)</th>
<th style=""width:10%"" class=""center"">Tenor/Validity (Months)</th>
<th style=""width:30%"" class=""center"">Pricing</th>
</tr>" & local!projectNameRow_txt & local!revolvingFacilityRow_txt & local!nonRevolvingFacilityRow_txt & local!totalProjectAmountRow_txt & "</table>",
  local!facilityTable_t24
 

  Discussion posts and replies are publicly visible

  • What have you tried so far? I think generally the approaches I'd suggest would be either to:

    • Create a copy of this whole table and add the new columns to the copy. Then create an if statement at the top level that decides whether to show the old table or the new table.
    • Include an if() statement within each row that decides whether or not to show the additional columns or not.

    I also don't know how you're using this, but you could consider if there are other ways to do this that don't involve HTML tables (e.g create an Appian interface that shows this data, which would be a lot easier to configure).