Setting up automated weekly email notifications for upcoming tasks?

Hi all,

My team and I use Coda as a social media calendar and I’d like to set up automated weekly email notifications of upcoming posts. Thus far, I’d like to set it up so that Mondays at 8 a.m. PST, everyone receives their email, but have been having trouble:

Your content (table title)
Publish Date (due date)
Posts (title)
Poster (assignee)

This rule is triggered every Monday at 8:00 AM PST


[Your content]
    Published = false AND
      [Publish Date] >= Today() AND
      [Publish Date] <= Today() + 7
  .Count() >


[Your content].Posts
    [Your content].[Publish Date] >= Today() AND
      [Your content].[Publish Date] <= (Today() + 7)
    true, [Your content].[Publish Date]
        [Your content].Poster,
          "Due soon: {1} on {2}",
          [Your content].Posts,
          [Your content].[Publish Date]

Hi @Greenbelt_CODA , and welcome to the community!

This doesn’t look right:

CleanShot 2024-02-15 at 10.53.21@2x

I expected to see the AND() function with parens and each of the conditions. Is CFL able to process serial booleans?

  Published = false,
  [Publish Date] >= Today(),
  [Publish Date] <= Today() + 7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.