Setting up automated weekly email notifications for upcoming tasks?

1

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)

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

If

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

Then

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

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?

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