Hi,\u00a0
(Not a developer, but tasked to develop)
I’m trying to create a programble email module that displays all the associated deals to the recipient that meet a few filter criteria. It doesn’t need to look super nice, but all I need is a table that shows the deal claim number in one column and a hyperlink to a form with some of the fields dyncamically filled in the other column.\u00a0
This is what I have so far, but nothing is rendering in the email tests I send myself. The fallback message is not even displaying. Hoping someone can please tell me what is wrong\/missing, or if this can’t work in email.
In the design manager I’m seeing this warning:\u00a0
Warning: 9:1 DEAL objects can only be retrieved on membership or password-restricted pages
I asked support about this and they ensured it should work in email and my code is the issue.
<\/P>
\n
{% set deal_ids = crm_associations(contact.hs_object_id, “HUBSPOT_DEFINED”, 4) %}<\/P>
\n
{% set matching_deals = [] %}
{% set cutoff_date = 1745020800000 %} {# 2025-04-19 in ms since epoch #}<\/P>
\n
{% for deal_id in deal_ids %}
{% set deal = crm_object(“deal”, deal_id,
“dealname,hubspot_auto_msa_trigger,referral_date,status,dyn365_opportunity_id,claim_number”)
%}<\/P>
\n
{# Ensure referral_date exists and is BEFORE cutoff #}
{% if deal.hubspot_auto_msa_trigger == “Auto-MSA Start”
and deal.status == “Open”
and deal.referral_date and deal.referral_date|int < cutoff_date %}
{% do matching_deals.append(deal) %}
{% endif %}<\/P>
\n
{% if matching_deals|length >= 10 %}
{% break %}
{% endif %}
{% endfor %}<\/P>
\n
{% if matching_deals|length > 0 %}
<\/P><\/p>\n