Latest Contributions by Joshua-Young

We are working through implementing this solution as well, and we also found that the way the solution is designed to work is you enter the running total in the spending table each time you have a payout. We did not want it to work that way either and you have to change the actcost to use the Sum function in each of the different maps that has the Spending/Expenditures information. You can also update the embedded HTML in Arcade to update the table element to show the category field. Here is one example from the Capital Project Tracker web map. if (count(related)>0){ final = `<span style="font-size:18px;"><b>Expenditures</b></span><br><table style="width:100%;border-spacing: .5rem;"><tr><td><table style="width:100%;border-collapse: collapse;"> <tr style="border-collapse: collapse; font-size:15px;"><th style="text-align:left;width:30%">Date</th><th style="text-align:center">Category</th><th style="text-align:right">Amount</th></tr> ` var counter =0 var x = 0 for (var i in related) { var amount = Text(i.costamount,'###,###,###') var color = iif(x % 2==0,"#D6D6D6","#FFFFFF") var spentDate = text(i.datespent, "MM/DD/YYYY") var category = i.category final += `<tr style="border-collapse: collapse;"><td style="text-align:left;width:30%;background-color:${color}">${spentDate}</td><td style="text-align:center;background-color:${color}">${category}</td><td style="text-align:right;background-color:${color}">$${amount}</td></tr>` x++ counter++ } final += '</table></td></tr></table>'; }    ... View more