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?
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.
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
That doesn't work. I get the error: ERR("Symbol expected: "")""")
Use this code:
First Name + " " + Last Name
'First Name' + " " + 'Last Name'
Strange. All three work for me and the last one (with quotes) gets corrected to no quotes.
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
Does your suffix field comes from a dropdown selection? Then you must use: text(Suffix)
Great! That worked. Many thanks! Is there handy-dandy quick reference guide to all of the calculation functions and their syntax?