Calculation Field not inserting space in update

Tap Forms – Organizer Database App for Mac, iPhone, and iPad Forums Using Tap Forms Calculation Field not inserting space in update

Viewing 2 reply threads
  • Author
    Posts
  • September 23, 2016 at 1:26 AM #19753

    Neil Alecock
    Participant

    In the new update I have created a new form and used the calculation field to combine first and 2nd names to make a full name field. However, since the update this field does not insert a space when the calculation is complete as in the screen shot attached.

    Can you advise please?

    Thanks

    Attachments:
    You must be logged in to view attached files.
    September 23, 2016 at 3:40 AM #19755

    Leo
    Participant

    Just make the formula <first name> + ” ” + <last name>

    September 23, 2016 at 10:40 AM #19760

    Brendan
    Keymaster

    Neil, it does this because spaces within the formula have no bearing on the result of the calculation. So Leo is correct that you have to explicitly add a space with + ” ” + into your formula to get a space in the result.

    September 23, 2016 at 12:09 PM #19761

    Neil Alecock
    Participant

    Thanks to you both for your help. I was adding in the + when just needed the ” ”

    Cheers

Viewing 2 reply threads

You must be logged in to reply to this topic.