+3Hi Airtable Community,
We are using the “enable rich text formatting” on a “long text” field, using bullet points to indicate points of attention or statuses. Is there any way to use this rich text and do the following:
Screen shot attached where I’m looking if I can filter out basis eg. “Week 13” or filter on bold.
Many thanks!
Best answer by TheTimeSavingCo
@Vivid-Squid thanks for the swift response, indeed the input is manual as these are often comments put in by various people. I’ve thought of improving the input which would help - indeed. Filtering would come in handy if possible, although I realise this might not be the case.
If you’re open to going down the rabbit hole of regex you could try that out if you’d like?
I’ve put something together here for you
To view the formulas, you can duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button
+16Hi @J_V,
I do not think you can filter based on the Markdown in rich text fields.
Maybe there is a better way of laying out your data or the base. How does the text get into Airtable?
+3@Vivid-Squid thanks for the swift response, indeed the input is manual as these are often comments put in by various people. I’ve thought of improving the input which would help - indeed. Filtering would come in handy if possible, although I realise this might not be the case.
+31@Vivid-Squid thanks for the swift response, indeed the input is manual as these are often comments put in by various people. I’ve thought of improving the input which would help - indeed. Filtering would come in handy if possible, although I realise this might not be the case.
If you’re open to going down the rabbit hole of regex you could try that out if you’d like?
I’ve put something together here for you
To view the formulas, you can duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button
+25@Vivid-Squid thanks for the swift response, indeed the input is manual as these are often comments put in by various people. I’ve thought of improving the input which would help - indeed. Filtering would come in handy if possible, although I realise this might not be the case.
It’s possible to get first three, or other number. for example,
REPLACE(Notes,
FIND('cutHere',
SUBSTITUTE(Notes,'\n- ','cutHere',3)),
LEN(Notes),'')
you may wrap this into IF( … ) clause if you have values with less than 3 bullet points
get last 3 is harder.
but that’s a wrong way. if you want to manage array of separate comments, you should store them as separated values, not as a joined text
+21Welcome to the community, @J_V! :grinning_face_with_big_eyes: Airtable formulas will only give you a bare-bones version of the markdown, and in this case it only identifies the bullet points. It doesn’t retain markdown for bold text. Retrieving the field value in a script does give you more markdown, but I’m not sure how much that will help in your use case. Running a script just to tweak a filter isn’t exactly convenient.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.