Weekly Summary with new rows/columns in Slack

Hey Coda Community,
Looking for a help with Coda - Slack automatisation.

Is there any chance to send a message to Slack on a weekly basis that will contain all new rows with data created in the table within a previous week period?

Dear @Nurzhan_Ospanov,
yes it can be done.

Have a look at this basic - and hopefully self explaining - example:

I implemented it with a Notify(), but you can simply change with a Slack::Message() function once you integrate the pack.
What I always suggest is to build up all the logic outside the automation (usually within a button).

This is useful for two reasons:

  1. you control the overall logic within a formula
  2. you can test/debug it more easily.

Please, let me know if you need further help.


Hi Federico,
Thanks so much for your answer and for providing this example.

I’ve tried to replicate it, but getting just Slack message that contains text “external” tho I’ve chosen the whole table .
I guess the issue is in formatting. Any hints here? which part of your formula wraps table to the text that can be sent as a Slack message once you press the button?

Hi @Nurzhan_Ospanov,
Maybe sharing your doc (or a sample of it) would help to actually dig into the problem and potentially solve it on the field: would you mind sharing it?

e.g. it’s not clear to me what you mean with:

Hi Federico,
That would be great and much appreciated. I’ve just embedded it. Thanks so much for all your help.

We’re almost there… you should give me permissions… :slight_smile:

I have just provided the permissions, Federico. Apologize, I’m slightly new to Coda so thought that my embed would be enough.

@Nurzhan_Ospanov, no need to apologise: every new tool require some time to get used to :wink:

I provided you some inline comments and examples.
Let me know if this helps

OP, I would love to dig into this doc more but I can’t see the formulas in the buttons since it’s view only. I’ve requested Edit access. If you still have access, could you approve that?

Hey @Izzi_Herman ! Are you talking about @Federico_Stefanato 's example doc above?