Skip to main content
New Idea

Allowing Rich Text Fields in the Filters in Rules Engine, JO Query Builder

Related products:None
  • November 17, 2020
  • 3 replies
  • 153 views

krishna_reddy_k
Forum|alt.badge.img+1

I do not know wny are we not allowing Rich Text fields in Filter conditions in Rules Engine, JO Query Builder, Data Designer features.

 

I think this is required to achieve the below sample use-cases:

Use-case 1:

We are sending a NPS Survey to Customers. If we receive any comments, we would like to create CTA. If not, we would like to automate “Thank you” email using JO.

 

Use-case 2:

We are trying to push the Scorecard Comments from Scorecard to another place in salesforce. We would like to retain most recent comments. If anyone removed comments, we should not push NULL to Salesforce.

 

In these cases, it will be helpful. alternatively we can build an extra MDA Object(As we are als onot allowing to create new fields in NPS Survey Responses Object) but it requires another extra rule to push the data from original object. This will become a complex process for these simple use-cases.

3 replies

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • November 18, 2020

@krishna_reddy_k thanks for sharing your thoughts here! 

I suspect there might be technical limitations because it is the same behaviour across the product( Rules Engine, JO Query Builder, Data Designer features). 

I am also sharing this with the product team to know more about this. 


sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • November 18, 2020

Before this hit the product team I want to see how many customers are interested in this functionality. 

@All, I would request all the customers to leave your vote or add +1 in the comments. 

 


john_apple
Forum|alt.badge.img+5
  • Expert ⭐️
  • November 19, 2020

If you use a transformation task, you can filter on the rich-text field (equals Null/not Null). A little trickier in JO since you would need a Calculated Field and Conditional Wait -- I would probably have a CTA created via Rules instead of JO but that’s a preference.