Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Find Record with Highest Value in Formula Column

Topic Labels: Automations
3500 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kevyn_Levine
4 - Data Explorer
4 - Data Explorer

Hello!

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?

Thanks!

2 Replies 2
David_Solimini
6 - Interface Innovator
6 - Interface Innovator

A good example of a similar problem solved here: How to get the highest value out of a column - #2 by W_Vann_Hall

it’s a bit wonky, as AT doesn’t work like a regular spreadsheet, but the TLDR version is that by creating a linked record on all the tweet fields, you can use a MAX rollup to identify where MAX=Your Random Column and then automate tweeting it out.

Hi @Kevyn_Levine and welcome to the community!

My first tought: