desperately need LINE BREAK function or literal
William Porter
Functions library needs a lot of love, but this I think should be top priority: a way to insert a line break in the text result of a formula. Can be done in many ways, e.g. a LINEBREAK() function could work. FileMaker defines the pilcrow ("¶") as a literal with this value, but most people don't know how to type a pilcrow. Airtable uses "\n" and this is widely used elsewhere (e.g. in regular expressions). Given number of people coming to SmartSuite from Airtable, perhaps that's the best approach.
C
Colleen Deal
Anyone have an update on this? Even the ability to use CHAR(10) would be helpful. It seems kinda silly that everyone else can do it!
Kurt Titel
If you are using Document Designer, this issue now works as of today's update. I don't think it displays with the breaks in the formula itself but properly display's if you add to Document Designer.
Example:
CONCAT([Vendor].[Vendor Name],"\n",[Vendor].[Address],"\n",[Vendor].[Phone],"\n",[Vendor].[Email])
William Porter
Kurt Titel: Thanks for pointing that out. I don't need this in Doc Designer but, inspired by your response, I just tested in a formula field and it looks like it's working now. This formula
CONCAT([Name], "\n"," [Address])
returns this result for Mickey Mouse:
Mickey Mouse
Disneyland, Anaheim CA
which is what I want. Yay! (Thanks, Kurt.)
William Porter
William Porter Well, looks like I was mistaken. Six months later, I can't get this to work. Using "\n" inside a CONCAT() does NOT create a line break in the text result, as displayed in the field.