Skip to main content
Solved

Random record selection from results after "Find Record" automation

J

Hello everyone! Thank you for taking the time to review my question.

I am using the Airtable “Find Record” automation feature to find records based on certain conditions. Once the feature finds multiple records, it selects the “Top” or “First” record that meets the condition criteria. I am trying to have it randomly select from the results, rather than default selecting the same record that was on top or first. Does anyone know the direction to look in or the process to make this possible?

Thank you kindly in advance!

Best answer by Justin_Barrett

Welcome to the community, @Jonathon! :grinning_face_with_big_eyes: Without using scripting, there’s no way to make a random selection from a collection of records. If your base is in a Pro-plan workspace or higher, you can use scripting actions in automations, and this would be doable with the help of JavaScript’s Math.random() method.

View original
    Did this topic help you find an answer to your question?

    5 replies

    Justin_Barrett
    Forum|alt.badge.img+20

    Welcome to the community, @Jonathon! :grinning_face_with_big_eyes: Without using scripting, there’s no way to make a random selection from a collection of records. If your base is in a Pro-plan workspace or higher, you can use scripting actions in automations, and this would be doable with the help of JavaScript’s Math.random() method.

    J
    • Jonathon
    • Author
    • New Participant
    • 2 replies
    • April 22, 2022
    Justin_Barrett wrote:

    Welcome to the community, @Jonathon! :grinning_face_with_big_eyes: Without using scripting, there’s no way to make a random selection from a collection of records. If your base is in a Pro-plan workspace or higher, you can use scripting actions in automations, and this would be doable with the help of JavaScript’s Math.random() method.


    Thank you! I am going to pursue that route and hopefully find success! I really appreciate your response

    kuovonne
    Forum|alt.badge.img+27
    • kuovonne
    • Brainy
    • 6004 replies
    • April 22, 2022
    Justin_Barrett wrote:

    Welcome to the community, @Jonathon! :grinning_face_with_big_eyes: Without using scripting, there’s no way to make a random selection from a collection of records. If your base is in a Pro-plan workspace or higher, you can use scripting actions in automations, and this would be doable with the help of JavaScript’s Math.random() method.


    Welcome to the Airtable community!

    What technique are you using to select the first record from the find results?

    There are techniques for getting pseudo-random values by doing things like looking at the record ID, created time, or last modified time of a record. However, in this case, I believe that a scripting solution is probably best.

    J
    • Jonathon
    • Author
    • New Participant
    • 2 replies
    • April 22, 2022
    kuovonne wrote:

    Welcome to the Airtable community!

    What technique are you using to select the first record from the find results?

    There are techniques for getting pseudo-random values by doing things like looking at the record ID, created time, or last modified time of a record. However, in this case, I believe that a scripting solution is probably best.


    Thank you so much for your feedback! Right now, the results are sorted by I.D. number, but I am trying to have the results randomly selected with no value being a determining factor for selection (Other than the conditions it uses to narrow the selection.) I am looking into running a script today.
    Thank you again for providing your information!

    W
    Forum|alt.badge.img+4
    • Webs
    • Inspiring
    • 8 replies
    • May 1, 2023

    Does anyone have a code sample to use that would achieve the result?  This is something Im also interested in.  

    Reply


    Most helpful members this week

    Terms & Conditions