Concatention Formula

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Concatention Formula

Viewing 3 reply threads
  • Author
    Posts
  • March 11, 2018 at 11:08 AM #27725

    John Scoble
    Participant

    Hi Brendan

    I think there appears to be an error in the Function Description for the Concat formula.

    The description indicates that the difference parameters should be linked by a semi-colon “;”. However, this does not work.

    The on-line Help file says the parameters should be linked with a plus sign “+”. This does work.

    With best wishes

    John

    March 12, 2018 at 9:00 AM #27750

    Brendan
    Keymaster

    There’s a CONCAT(A;B;C;...Z) function which is the function version of the regular Field A + " " + Field B operator.

    So the CONCAT() function should use a semi-colon between the parameters.

    If you send me a copy of the form template that wasn’t working I can look into it for you.

    March 12, 2018 at 9:36 AM #27752

    John Scoble
    Participant

    Brendan

    My turn to be embarrassed! I don’t have a copy of the original formula, which apparently wasn’t working, and when I tried it again, following your response above, it worked!

    Really sorry to have wasted your time.

    March 12, 2018 at 1:18 PM #27762

    Brendan
    Keymaster

    Hi John,

    No worries. I’m glad that it’s working for you now.

    Thanks!

    Brendan

  • Author
    Posts
Viewing 3 reply threads

You must be logged in to reply to this topic.