ContributionsMost RecentMost LikesSolutionsPipeline - 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 ------------------------------ Re: Pipeline triggered by checkbox Thank you! Oh Thank you!! I was copying some of the imported pipelines that had that advanced query!!! ------------------------------ Consuelo Viramonte ------------------------------ Pipeline triggered by checkbox I would like to trigger a pipeline when a checkbox is ticked. This is how I did it: I'm not sure why it's not working. Thanks! Consuelo ------------------------------ Consuelo Viramonte ------------------------------ Checkbox Look up field as a condition for Dynamic Rule Hi there, I have a checkbox field "Info Intake Reviewed" in my Projects Table. I have another table for Uploaded Files. The Table to Table relationship between them is 1 Project to Many Files. In the Uploaded Files Table I have a lookup field to to the Info Intake Reviewed checkbox. I want to set up a Dynamic rule that whenever I check the Info Intake Reviewed Checkbox in Projects, a "Reviewed" checkbox field in the Uploaded Files Table is automatically check (only when the checkbox changes from False to True). So I set it up as follows: What am I doing wrong? Thanks! Counting log edits in a text fieldI have a multi-line text field named [Client's referrals] that logs the edits to the field with Date, time and user. We keep track of the people a client has referred to us. I would like to know how many people a client referred to us each month. Is there a way I can count each edit and catch the date? Thanks! Consuelo ------------------------------ Consuelo Viramonte ------------------------------ Re: IF condition in Text fieldThanks! it has worked! ------------------------------ Consuelo Viramonte ------------------------------ IF condition in Text field Hi there, I have a [B!T Client Rating] Text field, it can contain numbers 1 to 5 or it can contain stars, so *, **, ***, ****, or *****. So I want to unify and convert the stars to numbers. I created a Formula text field and I put the following: if([B!T Client Rating] = "*",1, [B!T Client Rating]) if([B!T Client Rating] = "**",2, [B!T Client Rating]) if([B!T Client Rating] = "***",3, [B!T Client Rating]) if([B!T Client Rating] = "****",4, [B!T Client Rating]) if([B!T Client Rating] = "*****",5, [B!T Client Rating]) It doesn't like the = in the first line. It says: "The operator "=" can't be applied on type numbers, text". Any ideas? Thanks!! ------------------------------ Consuelo Viramonte ------------------------------ Dynamic rules not working with Grid EditHi there! I have a [Assigned to] user field, I have another field [Assigned To Converted to Text] which converts to text the [Assigned to] field. I also have a [Most recent Assigned to] text field (this filed appends information and with user and timestamp). Then I have a rule that "When [Most Recent Previous Assigned to]is not equal tothe value in [Assigned To Converted to Text],change [Most Recent Assigned to]tothe value in [Assigned To Converted to Text]". The idea is to track changes in time of the [Assigned to] field. My problem is that when I do a bulk update of the [Assigned to] field using Grid Edit, the rule doesn't work the field [Most recent Assigned to] does not update. How can I solve this? Thank you in advance for any help! ------------------------------ Consuelo Viramonte ------------------------------ Basing a Calendar report on two different event fieldsHi there, I have Calendar report that is base on a Date field called Start Date. It shows all the projects I have scheduled to start each day. I have another Calendar report based on a Date field called Initial Appointment. I shows all projects have scheduled to hold calls each day. Both these fields are on the same table. I would like to have just one Calendar that shows both, schedule calls and Projects I need to start each day. I would then color code them to distinguish between them. Is this possible? Thanks! ------------------------------ Consuelo Viramonte ------------------------------ Future date, formatted weekday, Month, dayHi there, I'm a complete beginner, so please bear with me. I need a field that shows Weekday, Month and day, with seven days in advance, except for Sundays and Saturdays. So if today is Monday, Jan 1st, I need it to show Monday, Jan 8th. If today is Saturday, Jan 6th, I need it to show Monday, Jan 8th. I know I need a date/Formula field, but I'm not sure what to put in the Formula. Thanks in advance! ------------------------------ Consuelo Viramonte ------------------------------