Help

Multiple lookup result into Markdown format

Topic Labels: Formulas
1891 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastian_Muri2
4 - Data Explorer
4 - Data Explorer

Hi guys!

I am looking to transform a lookup result into a Markdown format. Doing this will allow me -I think- to then export that field via Integromat into Webflow and displaying it in a bulleted format. In Webflow, I am using what is called a “Rich Text field”.

My guess is if I do a formula that takes the info I am looking up and then transforms into a Markdown or even HTML-kinda format this should be possible.

Has anyone done this before? Any ideas?

I am attaching a photo of the lookup field in Airtable, the rich field in Webflow, and how its supposed to display in the end.

Thanks!

2020-10-22_16h18_27
2020-10-22_16h18_43
2020-10-22_16h19_02

3 Replies 3

Your plan is fine until this statement -

… a formula that takes the info I am looking up and then transforms into a Markdown or even HTML-kinda format

Let’s be clear - you want a formula that takes a field with comma-separated lookup strings and makes it into a format that will be bulleted list items in WebFlow, right? If true, there is no way to create a formula to write text into a rick-text field the likes of which is the only feature able to render a bulleted list ready for WebFlow’s rich-text field.

However, you can create a formula field with text formatting markers that WebFlow will use. Just create a formula that reads the lookup strings and parses and arranges them in a manner that WebFlow will appreciate.

Alternatively, simply let Integromat perform the transformation before it writes the data into WebFlow.

Thanks a lot, Bill! That sounds right.

I want to try the Airtable native solution before jumping intro Integromat. Have you seen any example like the one you are describing? I am not sure how to solve the parsing and arranging part and about the format that Webflow can use.

Thanks for any tips!

Yeah, this is easier to say than to know the answer. I think you just start experimenting to see how the content is interpreted by Webflow.