Hello,
Whenever we get a new transaction in Bloomerang, I want Zapier to take the value in the Fee Amount field and subtract it from the Amount field. The trigger is a new transaction in Bloomerang, and for the action I’m currently using Zapier Formatter and getting errors. What am I doing wrong?
Thanks!
+14Hi
If you want to do a formula, then use this Zap action: Formatter > Numbers > Spreadsheet Style Formula
For the Zap action: Formatter - Numbers - Perform Math Operation
You need to map 1 input variable per input field instead of trying to configure a formula in 1 input field.
So 2 inputs means 2 input fields, each with 1 variable mapped.
Logic is top minus bottom.
+11Hi there
Did Troy’s suggestion of mapping the Amount and Fee Amount fields into a separate input fields get it working? Or did you switch to use a Formatter (Numbers > Spreadsheet-Style Formula) action instead?
Let us know how it went—want to make sure you’ve got this sorted! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
