Is there a way using a check box to trigger or add to a calculation?
Any suggestion on how accomplish this?
I am building a purchase order form that needs to have sales tax option. I would like it to where I would select check box to add a calculation of sales tax to a total value. If the order was untaxable, I could leave the box uncheck and let total add up as a running total.
Hi Jason,
You bet. All you need to do is multiply your tax amount that you’re adding by the value of your checkmark field. If a checkmark field is ON, then the value is 1. If it’s off, the value is 0.
So for example:
[Product Price] + [Product Price] * [Tax Amount] * [Apply Tax]
So if the value of the Apply Tax checkmark field is 0, then no tax would be applied. And if it is taxable, then the value of Apply Tax will be 1.
Hope that helps!
Brendan
Thanks! Works like a charm. I come from a FileMaker Pro background, so I was overthinking the calculation. I just need to get a better handle on tapforms calculation syntax.
.
