I have a problem that is very unique to me as it involves a custom integration that I had built for a developer. None the less, the problem is still quite simple and I am not sure if there is a solution or not. I was hoping there was.
The app developer who I won’t name is very poor with communication and I am not sure if I will hear back from them to tweak the app. So assume that isn’t an option for this scenario.
These are the columns I am working with.
The custom integrations sets the date to today if it is an incoming or outgoing communication in the respective column.
Then I have these 2 automations.
Pretty simple, I can then use the “customer awaiting response” status with the last inbound communication date to set up automated follow ups at set times and to move on items when they are non-responsive.
- When there is more than 1 incoming or outgoing message on the same day, it no longer triggers a change in the date column. So the “customer awaiting response” column gets stuck in 1 position.
I have tried:
- Making the automations push the date by 12 months, but this just creates a loop and keeps pushing the date.
- Making a second date column, and multiple “yes, YES, no, NO” statuses. but this just drags out the inevitable and still ends in a loop or just too many steps for the automations to calculate and it doesn’t get the whole way through.
It would be good if Monday had a “clear column” option as that would close the loop, but they don’t.
I was wondering if anyone can think of a nice simple automated solution to this dilemma.
Looking forward to hearing and trying out your ideas.