Trigger every Wednesday only in even calendar weeks (for Active Campaign)

[ollidoetsch]

I have a slightly more complex requirement. I want to send an automation email in Active Campaign that sends every Wednesday, but only in even calendar weeks.
Unfortunately, this is not possible with Active Campaign itself. Hence the question, can I somehow create a trigger with Pabbly Connect that takes the calendar weeks into account and triggers automation in Active Campaign? Unfortunately, I couldn't find any corresponding modules myself and hope that I may have simply overlooked something.

I would be very happy about some support.
Thank you in advance!

 

[ArshilAhmad]

Hi @ollidoetsch,

You can add these steps to your workflow as a workaround. Even though this workflow will trigger every Wednesday, the action step after the Filter will be executed only if Wednesday falls on an even week.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

function getWeekParity(inputDate) {
    // Convert input string to Date object
    const dateObject = new Date(inputDate);

    // Calculate the ISO week number
    const isoWeekNumber = getISOWeek(dateObject);

    // Determine if the week is odd or even
    const weekParity = isoWeekNumber % 2 === 0 ? "Even" : "Odd";

    return weekParity;
}

// Function to calculate ISO week number
function getISOWeek(date) {
    const startOfYear = new Date(date.getFullYear(), 0, 1);
    const diff = date - startOfYear;
    const oneWeek = 604800000; // milliseconds in a week
    return Math.ceil(diff / oneWeek);
}

// Example usage with a hardcoded date
const inputDate = "2024-01-24"; // Specify the date directly
const parityResult = getWeekParity(inputDate);
console.log(`The week for ${inputDate} is ${parityResult}.`);

 

[ollidoetsch]

Hi Arshil, oh wow, thank you very much for your great support and the fast reply. This is really really a big help!