Forum Discussion

ConsueloViramon's avatar
ConsueloViramon
Qrew Member
8 months ago

Pipeline - removing unsupported tags in a text field

Hi there, 

I have a pipeline that gets triggered when a new email is received in a Gmail inbox. Then the pipeline creates a record in a QB table with the following fields, Date, subject, From and body. The pipeline gets errors and then disconnects because it doesn't support HTLM tags, Javascript, etc. 

So I tried the following:

1- change the Body field to a Text rich type 

2- I tried adding a step before the Record is created using the Text channel, and using the following RegEx: (?:(?<=>)|^)[^<]+ (I got this idea from here: How to match text and skip HTML tags using a regular expression?

Stack Overflow remove preview
How to match text and skip HTML tags using a regular expression?
I have a bunch of records in a QuickBase table that contain a rich text field. In other words, they each contain some paragraphs of text intermingled with HTML tags like <p>, <strong>, ...
View this on Stack Overflow >

3- Using the following expression in the body field: {{a.body|text}} This idea I took from here: Discussions

Quickbase remove preview
Discussions
Hello,I am trying to play around with the Outlook channel in Pipelines. I am creating a record in QB anytime an email is received in a particular folder. Everyt
View this on Quickbase >

I'm still getting the errors. What am I not doing correctly?

Thank you in advance.



------------------------------
Consuelo Viramonte
------------------------------
No RepliesBe the first to reply