About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

What format is Airtable Rich Text Formatting texts are in?

  • 2 April 2024
  • 3 replies
  • 29 views
F
Userlevel 1
Badge

I am facing an issue and been at it for a few days.

 

Essentially the Airtable text that I wanna convert to HTML text isn’t being properly converted into one.

The end output isn’t the same as what’s on Airtable after I format them on Zapier using the “markdown to html” formatter or using some custom codes to do them.

 

I tested numerous variations of formatting code but nothing worked, if I can know what format the Airtable rich text is in, I can find some way to format that type to HTML using some code on Zapier.

Could anyone help in this regard

 

3 replies

ken.a
Userlevel 7
Badge +6

Hi there @Fahad.S,

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please share a screenshot of the “Action” section of the action steps that shows all of its fields. Like so:

46dd6c0979e3d815d621b8da43084ef1.png
(view larger)

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!

F
Userlevel 1
Badge

Surem

Hi there @Fahad.S,

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please share a screenshot of the “Action” section of the action steps that shows all of its fields. Like so:

46dd6c0979e3d815d621b8da43084ef1.png
(view larger)

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!

Sure, here’s the screenshot of the overall zap
 

This is what the input data looks like that I would like to convert to html


 

SamB
Rank
Userlevel 7
Badge +11

Hi @Fahad.S 👋

Thanks for sharing those screenshots here. Hope you don’t mind me jumping in to lend a hand with this! 🙂

Is step 3 of the Zap (named “Update Automation Status”) the action that should be updating the Airtable record with the HTML?

If so, that’ll need to be moved down to run after the Code action that’s been set up to reformat the markdown to HTML:
15bf81bfa8dee96af6a22715f8889a6a.png

The steps in a Zap will run in the order which they appear in the Zap so it needs to first change the markdown to HTML before it can be added to the Airtable record. Then in the Update Automation Status action you’d select the output from the Code action for the Fields Event Description About Event field.

That said, if that Code action doesn’t correctly convert the markdown text into the HTML correctly then I’d recommend changing it back to a Formatter (Text > Convert Markdown to HTML) action as that should be able to convert the markdown correctly.

Can you give that a try and let me know if that works as hoped? 

Reply


Terms & Conditions