0

How do I do a text calculation (e.g., First Name & " " & Last Name)

How do I do a text calculation (e.g., First Name & " " & Last Name)? So, if the contact's first name is "John" and his last name is "Doe", I want to  create a Full Name calculation that yields the result "John Doe" (e.g., First Name & " " & Last Name). I can do this in Filemaker and Excel... can I do it in Ninox?

11replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Mconneen
    • Mconneen
    • 2 yrs ago
    • Reported - view

    The easy way..   See https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

    and search for "concat".. 

    let fullName := 'First Name' + " " + 'Last Name';

    I there is a concat function but that is not what you want here.. as it puts a comma space ", " in between the values. 

    Like
  • Hi,

    Of course you can. The formula to enter in the Full Name field is: text(First Name) + " " + (Last Name)

    or using the visual composer: as text[First Name]+" "+Last Name

    John

    Like
  • That doesn't work. I get the error: ERR("Symbol expected: "")""")

    Like
    • Nick
    • Nick
    • 2 yrs ago
    • Reported - view

    Use this code:

    First Name + " " + Last Name

    Like
    • Nick
    • Nick
    • 2 yrs ago
    • Reported - view

    sorry...

    'First Name' + " " + 'Last Name'

    Like
  • Strange. All three work for me and the last one (with quotes) gets corrected to no quotes.

    Like
  • Okay, using 'First Name' + " " + 'Last Name' worked (John + Doe = John Doe), so then I added to it  + " " + 'Suffix' (suffix is a fields the contains endings like Jr., Sr., Esq., etc)... and my results was the error "UNDEFINED" 

    Further, it removes the single quotes from 'Suffix' turning it into Suffix

    Like
  • Does your suffix field comes from a dropdown selection? Then you must use: text(Suffix)

    Like
  • Great! That worked. Many thanks! Is there handy-dandy quick reference guide to all of the calculation functions and their syntax?

    Like
  • Context: I am considering converting a membership database currently maintain in Filemaker Pro; about 200 fields, and dozens of calculations (primarily text, but some COUNT and SUM functions). I have used FMPro since 1987, and am familiar with its scripting protocols (which is probably what is screwing me up with Ninox). How does Ninox compare to FMPro... is this a reasonable transition, or am I asking to much of Ninox?

    Like
  • Hi,

    You will find our Reference of functions and language here in our User Manual.
    https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

    Best, Jörg

    Like
Like Follow
  • 2 yrs agoLast active
  • 11Replies
  • 2677Views