CONCAT Joining a # and a $

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › CONCAT Joining a # and a $

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
  • January 30, 2022 at 2:34 AM #46530

    Yvette M
    Participant

    Hi. I want to join two items using the calcuLation field.

    Order ID- Text field
    &
    Total- Number field -Currency style with 2 decimal places

    Using Tap Forms calculation field that allows you to pick the fields and put a space between them got me this result:

    9175444000-215.66265

    Is there a way for me to keep the formatting in my calculated field?

    I want to get this result:

    917644000 – $215.67

    Thanks in advance!
    Yvette

    January 30, 2022 at 3:29 AM #46531

    Brendan
    Keymaster

    Hi Yvette,

    Yes you can do this. Use the FORMAT() function for that around your Total field.

    Order ID + "-" + FORMAT(Total; "$0.00")

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.