Good day,
I’m using tap forms on ipad pro. I have one main form and it’s linked to two other forms, namely purchases and sales (with several entries)
What I want to do is to;
1. Get the total of one field from “purchases”
2. Get the total of another field from “sales”.
3. Substract the result of (1)-(2) and see the result.
The problem is that the formula I enter for (1) is working fine
SUM([TOTAL::PURCHASES::Quantity])
Quantity being the name of the field
…whereas the same formula for (2) converts the name of the field to “new field” upon saving and doesn’t do the calculation (please see attached files)
Where am I doing wrong?
Thanks in advance for any help.
Attachments:
You must be
logged in to view attached files.
Hi Tarkan,
One issue is that you don’t need SUM()
around the field value at all. The [TOTAL::Form::Field]
function will already return the total without having it within the SUM()
function.
But that shouldn’t be the problem causing the New Field name to appear;.
Can you please email me your form template (.tff file) so I can investigate this further? You can do that by using the Email Form function on the Customize Form screen when you tap the action menu button.
And which version of Tap Forms are you using?
Thanks. I’m using version 5.3.3
I suppose your email is support@tapforms.com??
I have just sent you the email. Thanks :)
FYI, for anyone who sees this thread (I’ve responded directly to Tarkan via email), the problem was with having a duplicate field name in the form that confused the formula editor on the iOS version of Tap Forms. It’s best if field names are unique in this case if using one in a formula.
Yes. That worked perfectly well. Thanks for your time. :))