html escaping issue with picklist values that contain apostrophe

  • 1
  • Problem
  • Updated 1 week ago
  • Solved
I've tried on a few different themes, and I've upgraded to 11.2.10 but the issue persists.


As displayed on Skuid page...



Salesforce picklist values...
Photo of Conlan O'Rourke

Conlan O'Rourke

  • 3,270 Points 3k badge 2x thumb

Posted 4 weeks ago

  • 1
Photo of Mike Dwyer

Mike Dwyer

  • 3,390 Points 3k badge 2x thumb
Is that column a template field, displaying {{Service_Location__c}}? If so, try {{{Service_Location__c}}}.

[It's nice to see data I can relate to, from what looks like the justice system!]

Photo of Conlan O'Rourke

Conlan O'Rourke

  • 3,270 Points 3k badge 2x thumb
Hi Mike, 

No not a template field, just a regular old field. I tried your suggestion using the template field with 3 curly brackets, but the issue is persisting even in the template field.

[Yes, building out Case Management, Residential Services, and Legal Services applications for an human services agency]
Photo of Mike Dwyer

Mike Dwyer

  • 3,390 Points 3k badge 2x thumb
I'm thinking theme or css then, which are not my expertise. I can't duplicate the display with any of the culprits I can come up with.
Photo of Conlan O'Rourke

Conlan O'Rourke

  • 3,270 Points 3k badge 2x thumb
Bump
Photo of Louis Skelton

Louis Skelton

  • 4,786 Points 4k badge 2x thumb
Just a thought - what happens if you edit the picklist value in Salesforce and insert the inverted comma using your keyboard - i.e. manually type in the picklist value - could be an artefact from a copy/paste into the picklist value?
(Edited)
Photo of Conlan O'Rourke

Conlan O'Rourke

  • 3,270 Points 3k badge 2x thumb
Louis - thanks, this in fact was a result of a copy/paste artefact as you said. However, I was a bit of an idiot here because I had previously solved this issue, but only de-activated the bad value instead of deleting and replacing with the valid value. So those records were still just referencing the de-activated (bad) value.

My bad... :/