The FormConnect Pro app allows you to create an invoice form and also the ability to sum rows and columns and calculate the tax. You do this by entering a formula in the field setting for where you want the total to appear, similar to the way you enter a formula in a spreadsheet. In the example below, you enter a formula in the “Materials” field on the bottom of the form that sums the individual Material rows on the top of the form. Then you calculate the tax for the Material by multiplying it by the local jurisdiction’s tax rate.
