Forum Discussion

RickLindner's avatar
RickLindner
Qrew Trainee
6 years ago

Odd text formatting / substitution on connected table

I have a connected table in Quick Base that is pulling tickets from Zendesk.  One of the Zendesk fields is a long text field (description).   When records are pulled into Quick Base,  apostrophes are ...
App builders
Data import and export
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
i would sit tight until the February 24th release and then take advantage of the new functions we will get on that date.  See the previous thread in this forum and Harrison's response.

https://community.quickbase.com/quickbase/topics/custom-deliminator-for-multiselect-text-field

ie the idea is you get what you get on the data feed, but rename that field to be [description (raw import)] and then have a new formula field called [Description], with that new SearchandReplace() function.