calculation field

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › calculation field

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
  • November 22, 2015 at 10:51 AM #15288

    Sascha Schaab
    Participant

    hello all,

    sorry for my request but i did not find anything about my problem:
    i created a database for all my assurances incl. two fields:
    the one (field name: “payment terms”) shows me how often i have to pay the fee (monthly, quarterly, half a year, yearly) the other one the value of the fee (field name: “value”). is there the possibility to calculate in another field the total amount with a formula like: if “payment terms” = monthly then value *12 ?

    November 22, 2015 at 6:41 PM #15289

    Brendan
    Keymaster

    Hi Sascha,

    You could do this, but your “payment terms” field will need to be a number containing the number of months. So 1, 3, 6, and 12. Then in your Calculation field you can do [Payment Term] * [Fee Amount].

    Thanks,

    Brendan

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.