Trello/Butler -- set custom field dates based on due date

[Tal Alexander]

Very new Trello user here. I'd like to create a staged due date automation that sets a date in a custom field based on due date vs current date (three days before due date, two days before due date, etc). It looks like custom date field automation is limited to a relationship with either the present or static time ("two days from now" or "Jan 4 2025"). It looks like this was super-solvable in previous Butler interfaces but now the rules aren't editable in the same way.

 

Is there a workaround? An automation to set a date on checklist items would also work. 

[Nathan Smith]

Hey @Tal Alexander 

If you change your Custom Field type to be a plain text field, you can use a combination of Butler variables and arithmetic to do what you're looking for. Once you're custom field is a plain text field you can use Butler to set it to something like the below which will make the date 3 days before the cards due date:

{cardduedate-3d}

You can find out more about this on this page here - https://support.atlassian.com/trello/docs/arithmetic-and-formatting-in-date-variables/