I know that you need quotation marks around any text in a calculation that’s not a field. But what do I do if I want quotation marks to show with some text.
Here’s an example:
I have three fields: First Name, Nickname and Last Name
I want a calculation that shows all three with Nickname in quotation marks.
to get the spaces between the fields I would put +” “+
but what do I put to get quotation marks? I tried +”+ and +”””+
nothing worked. I am sure that’s possible though.
Hi Thomas,
Hmm… Unfortunately that’s a scenario I have not tested yet and I don’t think the algorithm is smart enough to allow that. I’ll have to do some investigations with that. Because all it’s doing is looking for quotation marks and then scanning ahead to find the next quotation mark and treating everything else as either a field value or part of the mathematical formula. So there was no special consideration for embedding quotation marks within the quotation marks in the formula.
Thanks,
Brendan
How about using single quote marks
Single quotation marks will work since they’re not double-quotes. :-)
.
