Hi Team,

See attached screenshot, I have a field called "contract renewal date" and a formula on the "contract renewal status" as per the below. How can I ensure the email only sends once? I was trying to update my "contract email sent" toggle field but appears I cannot update this from within the formula

let Date2 := 'Contract Renewal Date';
let Date1 := today();
let daysBetween := days(Date2, Date1) * -1;
if daysBetween = 90 then
    let userEmail := "david@platform81.com";
    sendEmail({
        from: "gary@platform81.com",
        to: userEmail,
        subject: "Thank you for your email",
        text: "We received your request to get another copy of your invoice",
        html: "Some text with markup"
    });
end;
if daysBetween <= 0 then
    styled("", "#cb2010", "")
else
    if daysBetween <= 90 then
        styled("", "#ffb452", "")
    else
        styled("", "#43d682", "")
    end
end