I just spend a bit of time writing a custom condition for to filter based on Easy Digital Downloads subscription status.

I've tested the queries directly and get what I'm after, but no matter how I hook these filter queries into the CRM Query builder I get issues due to the default {property} {operator} ? that seems to be added to the query irellevant to what we do.

So my proper subquery gets added, but the query errors due to unknown column {property}

Please help. We have a ton of ideas for custom rules, but can't get this one to work.

We have a working Tracking Event special condition that handles querying for JSON event properties, but I think its only working because we are effectively querying on an existing relationship of trackingEvent.

This new one does not use the same relationship as there are no relationships in the QueryBuilder for this by default, but it does add one for a non-existant property (our rule name).

1. How can we properly filter based on a simple subquery. Subquery can be any variation of a query on subs like so.

id IN (

SELECT fc.subscriber_id FROM wp_edd_subscriptions as sub
LEFT JOIN wp_edd_customers as cust on cust.id = sub.customer_id
LEFT JOIN wp_fc_contact_relations as fc ON fc.provider = 'edd' AND cust.user_id = fc.provider_id
WHERE sub.product_id IN (38995) AND sub.status = 'active';

I've tested adding queries directly to it or via a relationship, neither can work from my tests without some part I must be missing.

https://gist.github.com/danieliser/50d35a2a40b6bedeb5ed635a2df3ed5b2

Rough WIP, tried about 100 ways of querying, using your builder, raw query for the sub Ids to us in a simple query builder IN compare, nothing seems to work.

2 Alternatively, how can we add a custom relationship under the hood, so that we can map our work here to such relationship?

Hello

Is it a bug ? {{other.date_format.Y}} works on my email sequence "2025" for today's date. But it doesn't work for my contact Property Value as you can see it doesn't populated the the value but keeps the tag only...

I want to add "Alumni" Year property... Any other idea to deal with that ?

Regards

And by the way, that's not all!

Rest API Status
get_request_status: Not Working. Please make sure your server has this request type enabled
post_request_status: Not Working. Please make sure your server has this request type enabled
put_request_status: OK
delete_request_status: Not Working. Please make sure your server has this request type enabled

Hi everyone,

I’m currently looking for a way to customize the "Manage Email Preferences" and "Unsubscribe" pages in Fluent-CRM. Unfortunately, I couldn’t find any obvious settings or options within Fluent-CRM to do this.

My goal is to make these pages visually and content-wise more aligned with the design and requirements of my website. Has anyone here had experience with this or any idea how to achieve it?

I’d really appreciate your tips and suggestions! Thanks in advance! 😊

It would be great to have frontend portal for fluent crm. We dont want to give backend access to all of our marketing colleagues

Looking through all the bounce notifications on my list...

Fluent CRM appears to change contact status to "bounced" for ALL bounces (hard & soft) whereas most providers would have a method for retrying soft bounces before determining if they should or should not be mailed any longer.

For example:

I use Post Mark as my SMTP provider, and Post Mark suppresses sending to all hard bounces on their end, regardless of whether I try to mail them on my end or not.

But on my end...

A soft bounce such as "temporarily undeliverable" will change the contact status to "bounced" in fluent CRM and treat them as "unsubscribed".

Is there a plan to improve conditional bounce handling?

• It would be wonderful to be able to import custom fields in bulk, rather than type them in one-by-one. I'm transitioning from another platform and have almost 100 custom fields. With every other CRM/email system I've used, I've been able to import my list, and for any field that isn't already input in the system, I can just have it use the header row custom field name and then I just have to choose the field type. Having to copy and paste them in one by one is the most tedious thing I've ever done and making this transition really difficult.

Trigger system based on user behavior

Is it Google Tag Manager that I should read more about? Or should I go in a different and better/right direction?

In my online anxiety course, I need to be able to follow the client so that I can better guide them through the course. Something very simple is that if the client does not log in or visit pages in a given period, it can trigger an action from me. For example, an email if there is anything extra they need and then a lot of motivation.

So to be able to do that, I need to be able to create a system that begs action based on user behavior.

Do you have any good ideas, thoughts or possible solutions?

Using
FluentCRM/FORM/Support/ect..
Thrive Suite. And Thrive Apprentice for my online course.

Question for those who are dev-minded… what would be a good approach to coding a solution for this outcome?

I have an automation that send custom emails, and I would like to end the automation when the user replies to any of those emails.

Just trying to wrap my head around how I might go about it.