Formula self-converts the field name to “New Field”

Tap Forms – Organizer Database App for Mac, iPhone, and iPad Forums Using Tap Forms Formula self-converts the field name to “New Field”

This topic contains 4 replies, has 2 voices, and was last updated by  Tarkan Fenerci 2 months, 2 weeks ago.

  • Author
    Posts
  • January 5, 2019 at 2:29 AM #33182

    Tarkan Fenerci
    Participant

    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.
    January 5, 2019 at 11:14 AM #33200

    Brendan
    Keymaster

    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?

    January 5, 2019 at 11:31 AM #33205

    Tarkan Fenerci
    Participant

    Thanks. I’m using version 5.3.3
    I suppose your email is support@tapforms.com??

    I have just sent you the email. Thanks :)

    January 5, 2019 at 6:32 PM #33211

    Brendan
    Keymaster

    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

    Tarkan Fenerci
    Participant

    Yes. That worked perfectly well. Thanks for your time. :))

You must be logged in to reply to this topic.