I want to use automation to send a tweet when a date field is a day after today. But I don’t want all records that match that condition to trigger sending the tweet at exactly the same time.
The actual time could be any random time during the day or spread out at fixed intervals. The important thing is that they go out on the correct date but don’t go out at exactly the same time as there can be any number of them and that would be poor form on Twitter.
My thinking is that I can have two conditions, one for the date and another that matches the current time with a sequenced or randomly generated timeslot. But I cannot quite work out how to do that second part…