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:
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).