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.

Best answer

Reformatted text not being sent from Formatter to Airtable

  • 20 August 2021
  • 4 replies
  • 70 views
M
Userlevel 1

I’m trying to set up a Zap that will take a new to-do item (or message would work too) from Basecamp 3 and create a record in an Airtable table. The trigger works fine, but I’m having trouble getting the correct information to translate into Airtable. When I map the fields for the action, the Basecamp input for the “Description” field spits out HTML coded text and a non-active link to an image that was in the “Notes” field of the Basecamp task. I tried adding a format step to remove the HTML tags, and the test of this step worked, but when I test the action, I still get all the code showing up in the Airtable record.

Is there a way to set this up or map the fields so I only get text? And is there a way to separate out the image posted in the Basecamp to-do and make it go to a different field in the Airtable record?

icon

Best answer by Troy Tessalone 20 August 2021, 02:46

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @manifestcreative 

Make sure you’ve mapped the output from the Formatter step to the Airtable step.

Please provide screenshots of how your Zap steps are configured, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M
Userlevel 1

@Troy Tessalone 

Ah! Missed that, I didn’t realize the format step created a whole new output. Thanks! That worked perfectly.

Is there a way to pull out an image that is saved in Basecamp and drop it (or at least a direct link) into its own column in the Airtable record? The only place I see the image file referenced at all is in all that code from the description text that gets reformatted, but it’s not a live link, just the file name from the code. 

 

 

Troy Tessalone
Userlevel 7
Badge +14

@manifestcreative 

You’d need the file object or full file url in order to upload to an Attachments column in Airtable.

How to use files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M
Userlevel 1

@Troy Tessalone 

Thanks!

Terms & Conditions