How to trigger Automation on first day of month

Hi guys,

I’m working on a use case where I need to update a table with specific information on the first day of each month. However, I haven’t found a way to trigger the automation for this scenario with the current options available.

Could any Tulip wizard help me figure out how to handle this?

Regards,

Hi @OlgaStroilova I saw on a different entry that you work as a Product Manager at Tulip, taking over the team responsible for logic - including triggers, arrays, automations, etc.

Do you have a solution on how to handle this requirement? I have been exploring the On A Schedule trigger but the options available does not fulfill what I need.

I was able to create a workaround (trigger the automation daily and extract the day from the execution date and use a decision to ask if is equal to 01) but I was wondering if there is another way to handle this.

Thank you in advance for your help

Hi @DaniloArtavia -

I apologize for the delay here! I am checking with the Tulip Team to see what they may suggest. Will report back :slight_smile:

1 Like

Should be pretty straightforward to set up an Automation that runs every day, but does nothing if it is not the first day of the month. Here is one expression which would work, on a decision node immediately when the Automation starts.

DATETIMETOTEXT(@Automation Info.Current Date And Time, 'DD') = '01'

Happy Tulip-ing

Hi @DaniloArtavia , yes I’m the PM for Automations and other logic like Triggers! Great to meet you here, and would love to set up a time to chat live as well if you have other feedback or want to discuss further.

For this case - @danielpomeranz is right that we don’t yet have the ability to schedule for a day/week of month. We have a backlog item to explore scheduling from a datetime in the database or a day of month/week. The cases we’ve been asked for here are quite diverse, so we’re still figuring out what to start with. Likely a first step would be some time in 2025. In the interim, would the workaround Daniel suggested work for your case?

  • Olga

Hello guys,

Thank you for your responses, for the moment I will follow the proposed workaround to handle this specific scenario.

Looking forward for the new features on 2025.

Regards,

1 Like