
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 06, 2022 05:27 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 06, 2022 07:02 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 06, 2022 07:03 AM
Hi @Kevyn_Levine and welcome to the community!
My first tought:
- create an new table and use a linked field to link 1 record to all records in the orginal table (use the fill handle in the new field in the original table)
- add a rollup field in that new table and use
MAX(values)
as a formula - set up an automation that triggers each day; looks for the record in your original table that has the same number as the 1 record in your new table; let it Tweet; let it update that record to 0 so the
MAX(value)
in the new table changes
