Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Formula self-converts the field name to “New Field”
January 5, 2019 at 2:29 AM #33182
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
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.
- This topic was modified 4 months, 2 weeks ago by Tarkan Fenerci.
Attachments:You must be logged in to view attached files.January 5, 2019 at 11:14 AM #33200
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
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?January 5, 2019 at 11:31 AM #33205
Thanks. I’m using version 5.3.3
I suppose your email is email@example.com??
I have just sent you the email. Thanks :)January 5, 2019 at 6:32 PM #33211
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.January 5, 2019 at 8:16 PM #33219
Yes. That worked perfectly well. Thanks for your time. :))
You must be logged in to reply to this topic.