Lookup field with rich text?

I feel like I’m possibly missing something but it appears there’s no way to get markdown/rich text out of the field/table that it’s in? If I add a LOOKUP field that references a rich text field, the text comes through but all formatting is stripped. Is there a way around this?


Unfortunately, this is a very big limitation of Airtable. I would highly recommend sending an email to support@airtable.com and ask them to please support this functionality. This would be very useful for many of my Airtable consulting clients.

Airtable is a “platform of limitations”, and we have to come up with all sorts of workarounds on a regular basis. Probably the best thing you can do here is to create an automation, but I don’t think that Airtable currently gives us any way to do this with the built-in automation actions (which are also extremely limited).

So I’m pretty sure that you would need to write your own custom JavaScript to automate this, or you could turn to a low-code/no-code automation platform like Integromat to automate this for you.

In essence, the automation that you would want to create would look something like this:

When you’re done editing your rich text field in the original table, you would check a checkbox which then triggers an automation to copy & paste the RTF value from the original table into a RTF field in your other table. This is definitely not ideal & comes with its own set of problems (for example, what if somebody edits the RTF value in the new table?), but it could be a feasible solution.

I’m also not 100% sure that this will work, but I’m pretty sure that it will. I’m pretty sure that you can copy & paste from one RTF field into another RTF field, and it should retain the rich text formatting.

Maybe somebody else will come up with some better ideas.

p.s. I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link above contains my personal referral code.


This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.