Sintax of Calculation Field

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Sintax of Calculation Field

Viewing 2 reply threads
  • Author
    Posts
  • November 12, 2013 at 4:16 PM #7576

    Antonio Lage
    Participant

    Hi, I’m trying to port a Bento (Mac) database to Tap Forms.
    One field that on Bento displayed time in HH:SS format now is showing seconds (ex: 1800s instead of 30 minutes)
    How can I make the field display the correct format?
    Do I need to re-enter all the values?

    Thanks

    November 12, 2013 at 4:27 PM #7577

    Brendan
    Keymaster

    Hello Antonio,

    As long as the value is a number field (that doesn’t include the letter s), then you can use the HH:MM number formatter or hrs, mins number formatter. Just go to the Field Properties tab on the Edit form screen, click on your number field, then click on Number Format and choose HH:MM.

    Thanks!

    Brendan

    November 13, 2013 at 6:46 PM #7610

    Antonio Lage
    Participant

    Thanks Brendan, problem solved.

  • Author
    Posts
Viewing 2 reply threads

You must be logged in to reply to this topic.