I think I just figured out a way to improve rich text from airtable to webflow. If you're having issues displaying rich text correctly (line breaks, bullets not displaying, etc.) check this out:
I'm sorry in advance if this was already common knowledge somewhere. I've been fighting this problem for months and haven't been able to crack it.
The issue: for every new line in your rich text field, airtable adds a "\\n" character to the markdown. Somewhere along the way, this newline character doesn't get translated properly and keeps rich text formatting from displaying correctly (or at all) in Webflow.
You can't see these characters unless you get an unparsed response from the API. I checked my troublesome entries using Postman
Even if we use Integromat's Markdown to HTML module, we get poor results. Sometimes your lines will be combined into one, bulleted and numbered lists rarely display correctly (if at all), and more issues
The solution: it's is a little wasteful, but using Integromat we can remove the \\n characters and replace them with an EMPTYSTRING. (1) First you have to push the rich text to webflow. (2) Then you need an unparsed response from the api using the HTTP module (PATCH or GET)
(3) Save that response into a plaintext string. (4) Modify the string and remove the "\\n" characters. (5) Finally, pass the string into a JSON parser module so we can use the values again, and (6) update back to webflow
Now all of our rich text formatting displays properly
I'm sure there's a better way to go about this so we don't have to push the text twice, but I couldn't figure out a way to manipulate the raw rich text from Airtable otherwise.
Edgaras was able to simplify the flow down. Definitely use this! https://twitter.com/edgarasben/status/1306331762541424640
You can follow @heymicahh.
Tip: mention @twtextapp on a Twitter thread with the keyword “unroll” to get a link to it.

Latest Threads Unrolled: