I am trying to automate posting a random record to twitter.
I have an automation set up already that whenever i check a box on the record it will send out the tweet - this is working fine. I want to automate that step though so i made a column with “random” values.
Now I want to set an automation that each day, it finds a record with the highest value from that “random” value column and updated the record to check the box that will then trigger the twitter automation.
How can I set up an automation to find the highest value and then update that record by checking the box?