_BR_ENCODED_ markers are not replaced for text formula values used by Apex/Flow/Process when those values are populated in other text/text area fields
  • Log In

Known Issues · Scheduled

_BR_ENCODED_ markers are not replaced for text formula values used by Apex/Flow/Process when those values are populated in other text/text area fields

Last updated Today ·Reference W-2586676 ·Reported By 970 users

Scheduled - Summer '19

Summary
When users attempt to use a text formula value which contains the BR() function for newline characters, the _BR_ENCODED_ markers are not being replaced with new lines as expected.

Currently, if an Apex Trigger or Flow/Process attempts to use the formula value as the value for another text/text area field, the _BR_ENCODED_ markers are displayed and stored within that new field.

Repro
1. Create a formula field ("Text_Formula__c") which returns multiple lines of text using the BR() function. Example syntax:
-----
"Line 1"+BR()+"Line 2"+BR()+"Line 3"
-----

This syntax displays in the formula field as
-----
Line 1
Line 2
Line 3
-----

2. Create a Text Area field ("Text_Area__c") on the same object.

3. Create a Process (using Process Builder) on that Object. Add a Record Update action to update "Text_Area__c" with "Text_Formula__c". Activate this Process.

4. Trigger the Process on a new or existing record.


Expected Result: "Text_Area__c" is populated with the value of "Text_Formula__c" including the line breaks -- i.e.
-----
Line 1
Line 2
Line 3
-----

Actual Result: "Text_Area__c" is populated with the value of "Text_Formula__c", but _BR_ENCODED_ markers are not replaced with actual line breaks -- i.e.
-----
Line 1_BR_ENCODED_Line 2_BR_ENCODED_Line 3
-----

Workaround
Avoid using Apex/Flow/Process to populate a text/text area field with the value of a Formula that contains BR() functions. You could use workflow rules for the same.


Another option is to create an additional formula field that reflects the contents of the text area updated by the Process. That formula will display the value as expected. >>> e.g. Continuing the example above, you could create a formula like "Text Area Mirror" with syntax Text_Area__c, and place that formula on the layout.

Reported By (970)

Anne Nuguid Jason Hoult Takuma Ogura Mark Mogridge Dylan Stai brandon Walton Erik Burton Nobuaki Hayashi Sam Floyd Melissa De Pau Bill Hoke Kris DeTrano Laura Gomez Peter Premier Eric AMIEL Jaroslavas Karmazinas James Goerke Chris Forsha Matt Bingham Brandon Chang Patrick McNeal Christopher Magnell Nagraj Gornalli Evaldas Micius David Bruce Michael Grandel Richard Wasserman Arnt Haering Matt Hagey Greg Althoff Patrick Pilvines Marta Paddeo Taha Syed Mayank Sharma Robert Méndez Adam Steinhoff Sujay Kothapalli Rachel Sellers Richard Hensley Harmen Korfage Annie Waddill Orest Skoropad Edgar Sampson Andrey Klyuyev Denis O'Leary Neil Scott Yoann Beurier Ben McLeod Glenn Lehner Gavin O'Brien Jonatan Adebäck Thomas Fursdon Stephen Rathjen Ram Pratap(UPI_L1)_TBSS Amr Khalil Sohei Uotani Will Joice Impact Box Shadé Loggenberg Stephen Cormier Wim van Strien Chloe Aiani Casey Bomar Giulia Mosca Lyubov Sherkunova Jon Kraybill Jon Sweet Eszter Huszar Christina Whitfield Jeff Battles Paul Rebman Bradley Haines Elisa Pelegrina Dean De-Viell Dorel Nasso Ben Falter Carl DeCecchis Samantha Reilly Remy d'Arras Lorenzo Alali Admin NTT Leonardo Sasounian Bongiovanni Gary Davis Christen Bejar John Smith Hannu Holopainen Craig Berko Per Eric Johansen 風也 三輪 John Assheton John Shea Rabel Racka Stas Dunayev Maciej Sobkowicz Paweł Fronczak Andrew Mondy Patrick Pilvines Alexis Kasperavičius suyu xie Simon Lafont Dan Kamins Stuart Smith Felipe Kuninory Akitaya Ben Wells Ursula Schreiner Ralph Blanco Sri Vidya Bommineni Isabella Pellegrino Michelle Lavalette Isabella Thompson Jason Terrell Tommy Strickland Tracy Gibbs Amber Venzke Tsuyoshi Miyake AVS ADMIN Hannah Hoersting Wendy Bouman Ray Mallaire Samuel Frost Jennifer Dunn Dmitry Borisov Matt Kent Karsten Maaß Anupam Jaishwal Akihiro Aizawa Coline Ludwig Arjun Gupta Kris Ryan Olga Loza Bernard Verhoeven Camille Lambert hikaru kurono Yidan Wang Damian Kowalski Ryosuke Kawamura Bertie O'Brien Adrian Camua Juri Hizume Adam Burns Parker Edelmann Dimitris Mitsios Joshua Troglia Chelsea Feltham Ariel Litman Benedikt Eping Matthew Danna Ramesh Varatharaj Jacob Landis Tony Kayyali Yelena Slobard Sarah Chen Brandon Baldwin Luke Osmundson Dan Donin Scott Eng Flore Meric Kamran Khan Sandra Cameron Jean Jaenicke Christine Hearn Ciaran Roe Chris Vickery Ken King Arpit Gupta RJ Palombo Angela Day-Keith Christopher Blachowski Juan Hernandez Daniel Morgan Matt Edmonds Stephen Clayton Friendly Tester Sam Mohyee Paul Hardacre Rob Evans Piers Anderson Mark Pieter Shruti Bhiwapurkar 昌美 小澤 Mendy Ezagui AppSolve Team Brian Runyan Derrick Abbey Alastair Batchelor Nathan McMahon Masaru Tanaka 毅 髙橋 r t Alex Ekblad Michael Wehner Virginia Lux Lawson Teo Chris Gooding Alastair Dinning Phil Medina dan hopkins Katie Nix Matt LaMond YUKI MORIUCHI Gaurav Bhardwaj Marc Lehmberg Starrdata Admin sanchit Kaushal Michael Torchedlo Guilherme Tuacek Summa Admin Bernd Claßen Amy Gorham Dan Moore Leslie Waters sergio Alvarez Alonso Richard Thompson Charlton Hua Mark Seifert Bala krishnan Maraike Stein Matthew Sai Mohammad Housaini Bill Miller Jessica Puckett Marina Shuman Esti Gershonowitz Douglas Burkhart Oliver Khan Hui Newnham Andy Nguyen Kyle McKay Alain Anterieux Stephen Burgess Sravanthi Yarava Caden Reiman Korhan Mulcar Katharine Anderson Aaron Allport Brenden Burkinshaw Cameron Cohran Nele Depraetere Ross Dickson Chris Fezza Nayana Suresh Marja Yli-Karhula Stephanie Boggs Erik Wintrich Peter Doten Cory Bennett Sai Inavolu Jon Brewer developr'"><script>alert()</script> asda Mike Hyer Jennifer Buck Joe Mitchell Kevin Liu Marketo Sync William McLaughlin Jesse Wolff Admin User Pamela Barrios John Flaherty Guylaine Gauthier Zev Grunsweig Mohd Hafizi Khiruddin Hector Cabrera Diaz Hunter Kim Kyle Corsaro Brian Mathews RE RETEam Sabrina Trampal-Bertolero Ed Pashkin Nicole Edwards Devin Rhoades Shane Jensen Alicia Rozeboom Breeonah K Mike Bogunov Anthony TRINH Isaac Lewis Christian Fritz Louise OBrien Dennis Welter Natalie Davis vijay gangani Bonita Elevario Kamilia Bouraoui Brent N James Underwood Joe Englert Christine Blakeney Julie Bond Elle Regan Steve Kellenyi Jeffrey Wong Kim Jenkins AVS Monica Thornton Venkat Kali Danny Abdeljabbar Geetha Kandukuri Janise Dismuke Yann Seddik Peter Sinka Sean Etherington Anna Loughnan Steve MunLeeuw Sri Lakshmanan Matt Elstad Jason Walke Kayla Greenberger Lauren Kamrad Susan Nordquist Igor Tenyuta Raksha Meanger Jason Vance shailendra singhai Anna Freund Mark Bailey James McVicar Ambrose Alward Admin Support Daisuke Akaza Graham Hopgood Prateek Kumar Alberto Minardi Marko Stankovic Radhika Kollepalli Sam Howle Oliver Preuschl Raghavendra Akunapuram Desarae McColley Prakash Sriram Eva Mooney Alon Waisman Martin Krchnak Jericho Ruan Mattias Nordin Jim Clifton IT Admin Hugues Beaurivage Braden Perry Robert Howell Sam Fenn Kannan Raju Carolina Röller Ben Prozinski Brad Mampe Mike Mikula Jennifer Bower Cate Schlarman AGS Admin mandy ensign Kalue Her Luke Fitzwater Stephen Eaton Itzik Winograd Erik Nejman Jacob Marshall Bernhard Leitner Brad Gross Dominique Wallace Saket Kolhapure NK TW Jacob Marshall Michael M Gabriel ESSEMINI haritha peddireddy gari CopperHill Consulting Valli Gopalakrishnan Joseph Buege Joe Buege Raz Yogev Federico Segundo Rubio Jeanette Hagan Manas Mishra Nana Gregg Andrew Blair Carl Herman Gorav Seth Daniel Morán Christoffer Andersson Chris Lightley 昭弘 相澤 Morten Justesen Eric Smith Jeffrey Malin Terry Miller Karen Brown Pierre Crouzet Alan Faubel Tim Lomison karen brown Padam Sharma Liat Erez Charlotte Koocheki Anthony Mealand Jamie Buck-Tomek John Graf Natali Stratieva Chris Kilburne (ext.) Bud Heaton Nate Bunker Audrey Marlow Neil Kim Laurence Taylor Carlos Frias Seth Partridge Ram Efe Cameron Aiello Christian Sack Rachel Dew Jack Linstead Jon Casey Rajasekhar vemula Renan Moreira Tawfik El-Sarrag Bill Ramsay Grace Anderson Gillian Reynolds Jim Weldy Will Rus Jodi Jenkins Kid Jansen Donovan Kruger brett thompson Muhammad Bilal Martin Vyskocil Steve Blackwell Amanda McKellar Crystal Karanovich Brian Bacharz Elizabeth Akerman Carl Anderson Paarth Jolly John Thiltgen Stephanie Foerst Marc D Behr Ruth Whincup David Poynter Christian Reichert Wai Keong Wong Nur Husnidha Hussain Theodore Blagg Kurtis Teel Adam Braxton Vinny Poliseno Amanda Kohser Matt Denault Constance T Jack Hammond Matt Young Megan Brooks Vinu Vijayan Ed Castillo Ashwini Natarajan Philippe Labat Charlotte Noordsy Kendall Newby Adrianna Carlesimo Sadahiro Suzuki Tanya Woods Alexandre Mendes Martijn Reekmans Ian Brown Ralf Wittenberger Antonio Torres Kristopher Estrada Nigel Le Brett Morgan K R Ben Bromberg Jeff Honnold Wilfredo Morillo Cody Kindschuh Mike Elms Anna Bilevskaya Judy Tang Andrew Barash Anurag Joshi Nick Petersohn Andy Lavelle Grant Garrigan Lindsay Holmes Josh Sangster Chuck Tomlinson Nicolas Devillierre Stephen Long Jim Delaney Stacy Hyatt Laura Naselli Alex Maier Adam Saal James Winter Christopher Shade Balaji Sai Pavan Ayta Lars Nielsen Patrick Nylen John McElroy Chris Lance Chad Harris Evan Arbeitman Jason Gladstone Erin Yamaoka Chris Govett Dan Howell Arturo Rodriguez Martinez Benjy Hunt Deepthi Kudrathaya Aziz L Hilary Henderson Virginia Giraut Adam Moreno Michelle Mallo Joe Smith Santosh Dantuluri Tee Yong Lim Lisa Walker Carena Ng JULIEN HILD Chris Appels Manisha Palsana Jake Harrison John Paul Dantanus Krishna Kanth David Smith Mark Lester Cabrera Brian Shor Tim Shores Rob Crossley Brian McKenzie Sam Satterfield Alex Packard Eric Hoskote Emma Henderson Brian Strack Jake Romphf Mary Tagler Trinh Harrison Janelle Gardner John Alexander Constance HUA Jeff Chan Jhomann Carreon Fabian Peters Kenneth Dillon Daniel Dynon Rob Cowell Lisa Mashkouri Ross Collinson Jay Jordan Shaun Bridges Miho Kaizuka Kimberly Dy Tim Meehan Matthew Gladman Data Ops Julie Force Jan Griesgraber Candice Allen Sandi Zellner Michael Tombrello Louise Summers Salesforce Admin Ralf Hamester IsochronixMind isochronix Milena Voronkin Kyle Broeckel Chris Kellie Carissa Crittenden Michael Torchedlo Scott Rosemary Melissa Frievalt Mohammad Asim Ali Rob Rung Mark Dodgshun Steve Rosner Rohith Raj Chenna Ben Johnstone Mark Brown Alex Townsend Kit Shepetys Blueprint Wealth Lawson Teo Emma Henderson Admin Manpower Admin Chattry Meas Tim Slijp Service Account Frank Reed Ian Womack Brian Zehnle Gloria Gutierrez Pattie Heintz Leanne Ardley Joseph P. Smith Dominic Ionadi Zac Otero Alexander Schätzle Kari Abbott James Foxon Leslie Tilton Olivia Nixon Erin Sherrell Samuel Lau Liz Vokolek Lisa Clossey Mapfre RE Derek Anderson Mondaycall Consultant Fabian Peters akshay kumar Stephen Wood Agustin Bruno demo user Matthew Steiner Jen Bowen Elena King lauren lorberbaum Daniel Richards 康志 大網 Noris Pasic Nick Cafarchio Dong Zhao Craig Zelley Brian Fey Litify Services+PLSG Albert Martí Vance Miller Robert Spielman Kevin Kneip Igor Corti Cloudreach Admin Jack Lish Krisztian Pozsa SF Admin Matthew Wolfe Rachide Ibrahim Kerry Desberg Matt Garnett Chris Benoit Corey Hayden Tyler Carey Ivan Todorov Reda Benhemmouche Margaret Fleischaker Adam Erskine Alek Gokiert Daniel Quisdorf Shane Steele Bruce Morgan Pamela DuPont Andy Jimenez Kelly Strauch Gabriel Csanalosi Doug Ayers Robert Peck Virginie Chevalier Kristen Roberts Frazer Lewis Peter Lai Kenny Clark Eric Schubert Sidhant Agarwal Gustavo Tavares Marçon Canpango Support Stacie Davis Ron Langtiw Kevin Hart Wyatt Spielman Harmen Korfage Richard Sweetnam Bob Morrison Jennifer Dunn A.J. Seo Julia Gachet Guilaume Bougel Quentin Dalmazir Kaamil Siddiqui Vegard Østhagen Fabrice Cathala Dan Barrett Lori Smith Jason Herforth Lauren Wild Martin Topiwala Seth Turman Spencer Foreman Dan Grossberg loic maxwell Daniel Clemente Dustin Strickler Allison Letts Fred Squires Pablo Martinez Ben Van Zee Brad Currier Dan Ervin Alessandro Iaconi Luke Thackray Tobias Brand Joe Mellott David Banda Marcel Becher Shaun Pendrigh Dev Ops Eric Vaanholt Rob Howe Salesforce Admin Tas Ranson Antoine PEYTAVIN DE GARAM Ellen Taussig Adam Kebeck Edgar Sampson Jonathan Mercier Anil Madithati Jaimin Patel Ben Brenner Daniel White Murad Al-Yasin Ragnar Thurén BioSpine Institute Nicholas Labrada Pavan Kumar Tina Hill Eric Schubert Mike S Claire Jones Bhavana Singh Ofri Heffetz B. A. Baracus Vincent Lippens Mary Johnson Brett Gilbert 忠 下之段 David Speck Geoffrey Flynn Clever Admin Jacqueline Simony Edgar Sampson Matthew Souther M M Jenna Berkowitz Allanah San Miguel Christopher Cook Takashi Ueno Shilpa ADMIN Joe Nagy Peter Bender Marjorie Marcus Travis Arnold FERNANDO DOMINGUES David Brenner Chris Evans Romain Lhez Irene S Kim Galant Delinda Tinkey System Administrator Christian Eichhorn Tom Blamire Justin Burgard Trefor Williams Wenda McMahan Alexander Placidi Jennifer Wisner Emilio Perez 和男 大越 Jackie Travieso Susanne Mcgregor Eric Su Dave Masom Maxim Rydlev Rob Burkett Denver Greene Lee Yakiwchuk Admin User Jason Cookman Mike Reynolds Ellie Matthewman Vincent Drader Peter Kim Serguei Zoubak Carla Llewellyn Nicole Guerra Alexander Shumski Azfer Pervaiz Phillip Front Mark Bruso Patrick Maxwell Andrew Halim Sjef Wijnen Terrence Blindauer System Architect Mark Guilday Jenny Mosunova Katie Timmerman Michelle Martin Michal Skara Richard Kao Jeff Hagopian Hanno Verweij Sean Wohlfert Barry Clark Rafal Bolimowski Johan Yu Ryan Morgan James Sweeney Cassie Supilowski Chad Kelly Brian Collins Nicholas Brownell Joshua Lenton Brent Downey Julia Smetanina Jon LaRosa Antonia Trasatti Robin Wijnen Sneha Bhatkande Sneha Bhatkande Chris Uttley Kristin Hasna Daniel Kimball Jim Marous David Kemp Jeanne Leon Samtest Taylor Michael Cullen Holly Lee Erica Dean Kelly Allen Julian Miksch Jennifer Vigran Andrew Sample Michael Hupe Sara Herrera Justin Edelstein Holly Ryall Roger Mitchell Ted Todorov Ted Todorov Daniel Fard Ferdie Klok Rich Englhard Michiel Verwater Admin Admin Rosalind Holland William Young Luke McKenzie 講平 覚野 Mostafa Younis Marcus Nielsen Nick Lindberg Christian Carter Tim Roake Curtis Aliff Scott Johnson Ido Greenbaum Damien Owen Christopher Shackleton Ryan Butters Daniel Ebel Kevin Light Dermot Kirwan Ella  Bernachik Kyle Haver Stephen Wood Radha Rodriguez Eric Mack Terry Cole Lihod Rachmilevitch Michelle Schlies Richard Cave Graham Callaghan Joe Stolz Eric van Horssen Stephanie Powell Auguste Slekyte Aaron Lokey Jaymie Woodhouse Kerry Proksel NexGen Jordan Easley Mark Erdeljac Tsvety Nikolova Ahmad Helal Kathryn Bondi Chris Norton Michael Rebak Doug Hill Steven Bontenbal Ben Patterson Sean Book JQ Liao Marques Hollie Alper Tovi Eric Nelson Jesse Bragalone John Stevens Mark Ellis Jules Faligot Jiri Karpisek Bruce Moulton Linda Moore Cheryl King Jonathan Green Chris Marcis Mary Lorch Rajendra Rathore Andrew Hess 裕之 遠藤 Ilya Popov Dan Morris Chris McMackin Matt Nesci Cloud4Good Consultant Boris Lindauer Rafi Bin-Nun IW Ana Cardenas Brian Warren Ben Gottesman Robert Degraffenreaidt Scott Peterson Gillian Puffer Trey Hoffman Gillian Puffer Chris Reynolds Charles Koppleman Brad Herman Itay Sinuani Chandler Anderson Jonathan Dobbs Object Consulting Tricia Igoe אילה קרקש Benjamin Bolopue Angela Sobrepena Edward Yerke-Robins Missy Lowery Missy Lowery Justin Petrillo Adam Rademacher Adam Gaber Silvina T. Vince Carr Jessica Jones Mark Vermaat Kira Tubo Brian Oconnell Admin User John Vester Autumn Breese John Reighard Neil Jamison Jeremiah Dohn Michael Kolodner Alex Jacobi JQ Liao Rakesh Gupta Shannon Van Essen Software Developer bc once 葉子 前田 Jared Usrey Tim Parker 祐子 川上 Matt (Tyco WW) Tuomala Bailey Rudd Patrick Flint Megan Moody Stephen Belleau Chris Edwards George Weilenmann

Is it Fixed?

AP0 AP3 AP4 AP5 AP6 AP7 AP8 AP9 AP14 AP15 CS1 CS2 CS3 CS4 CS5 CS6 CS7 CS8 CS9 CS10 CS109 CS108 CS107 CS106 CS105 CS102 CS101 CS100 CS115 CS110 CS11 CS116 CS12 CS137 CS138 CS13 CS14 CS15 CS16 CS17 CS18 CS19 CS20 CS21 CS22 CS23 CS24 CS25 CS26 CS27 CS28 CS30 CS31 CS32 CS33 CS40 CS41 CS42 CS43 CS44 CS45 CS47 CS50 CS51 CS52 CS53 CS54 CS57 CS58 CS59 CS60 CS61 CS62 CS63 CS64 CS65 CS66 CS67 CS68 CS69 CS70 CS71 CS72 CS73 CS74 CS75 CS76 CS77 CS78 CS79 CS80 CS81 CS82 CS83 CS84 CS85 CS86 CS87 CS88 CS89 CS90 CS91 CS92 CS93 CS94 CS95 CS96 CS97 CS98 CS99 EU7 EU8 EU9 EU10 EU12 EU13 EU14 EU15 EU16 EU17 EU18 EU19 EU25 EU26 NA8 NA21 NA29 NA32 NA33 NA34 NA37 NA38 NA39 NA40 NA42 NA44 NA45 NA46 NA47 NA48 NA49 NA50 NA51 NA52 NA53 NA54 NA55 NA56 NA57 NA58 NA59 NA60 NA61 NA62 NA63 NA64 NA65 NA66 NA67 NA68 NA69 NA70 NA71 NA72 NA73 NA74 NA75 NA76 NA77 NA78 NA79 NA80 NA81 NA82 NA83 NA84 NA85 NA86 NA87 NA88 NA89 NA90 NA91 NA92 NA93 NA94 NA95 NA96 NA99 UM1 UM2 UM3 UM4 UM5

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.