concatenating the result of a calculation and a text

Tap Forms – Organizer Database App for Mac, iPhone, and iPad Forums Using Tap Forms concatenating the result of a calculation and a text

Viewing 1 reply thread
  • Author
    Posts
  • December 7, 2018 at 5:07 AM #32473

    Karl Reed
    Participant

    I think I need to convert the result of a calculation in to a text, but, can’t see how to do this.. Also, I assume that in CONCAT, the results of a calculation need to be converted to a string. I also think that a string of characters needs to be “abc”.
    But, I cannot find a function that converts a number to s string.

    December 7, 2018 at 12:42 PM #32480

    Brendan
    Keymaster

    Hi Karl,

    You can use the FORMAT() function with a pattern to convert a number to a string. Then you can either use the CONCAT() function or just add them together with a + operator.

    E.g. Full Name:

    First Name + " " + Last Name

    Or you can do:

    CONCAT(First Name; Last Name)

    It’s up to you.

    Set the result type to Text.

Viewing 1 reply thread

You must be logged in to reply to this topic.