Trying to find the LAST card in a multi-card related order to send an update email to a customer

Hi ​@khlevin 

Solution will likely involve some custom code.
 

Try these Zap actions:

• Action: Trello - Find Card
  • CONFIG
    • Keyword
      • Map the common Card value to search
      • Put in double quotes
        • See screenshot below
    • If multiple search results are found = Return all results as line items.
      • See screenshot below
• Action: Code (JavaScript)
  • Inputs
    • RAW
      • See screenshot below
  • Code
    • See code below

CODE

// Zapier Code Step: Find the card with the latest due date

const raw = inputData.RAW;

if (!raw) {
  throw new Error("RAW is required.");
}

const data = JSON.parse(raw);
const cards = data.results || data.cards || data;

const cardsWithDueDates = cards.filter(card => card.due);

if (cardsWithDueDates.length === 0) {
  return {
    found: false,
    message: "No cards with due dates found."
  };
}

cardsWithDueDates.sort((a, b) => new Date(b.due) - new Date(a.due));

const card = cardsWithDueDates[0];

return {
  found: true,
  card_name: card.name,
  card_due: card.due,
  card_url: card.url,
  card_id: card.id
};

Other Options:

1. Try creating a Trello Custom Action with the help of AI
   1. Help: https://help.zapier.com/hc/en-us/articles/16277139110157-Create-a-custom-action
2. Try using the Trello API
   1. App: API by Zapier
      1. Help: https://zapier.com/apps/api-by-zapier/integrations#help
   2. App: Webhooks by Zapier
      1. Help: https://zapier.com/apps/webhook/integrations#help
3. Try using custom Code
   1. Help: https://zapier.com/apps/code/integrations#help
4. Try working with a Zapier Solution Partner
   1. https://zapier.com/partnerdirectory

Hey ​@khlevin,

Yes, it’s possible to achieve using Zapier. Your workflow will look something like this-

• Card moved to list trigger
• Formatter by Zapier(Extract the base order number)
• Find Card by Custom Query action
• Code by Zapier for finding the longest timeline card
• Filter
• Send Customer Email

Here is a helpful article about Code in Zapier- https://help.zapier.com/hc/en-us/articles/8496310939021-Use-JavaScript-code-in-Zaps

I know this is a bit more complex and technical that you would have liked but if it’s important for you, you can give this approach a try. Hope it helps!

PS: If you need more active help, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn

Hi there ​@khlevin 👋 Have you had a chance to test out the approaches Troy and Sparsh suggested yet?

Let us know how it goes when you do! 🙂