Skip to main content
Best answer

Pick multiple random items from a list (Formatter)

  • September 16, 2020
  • 2 replies
  • 806 views

Hello!

 

I’m currently trying to set up a zap that picks 3 different and random times from a list and sends them to another app. The way I set this up so far is I have 3 different “Pick from List” formatter steps, with each step pulling a different number (Since from what I can tell there isn’t an option to pick more than one random list item at a time).

 

The issue I have is figuring out how to make sure that those three numbers are unique. For example, what’s stopping two of the three formatter steps from randomly choosing the same time?

 

All help is appreciated, thanks!

Best answer by Troy Tessalone

You can do this in 1 Step using a GSheet.

The GSheet formulas can be constructed to randomly pick 3 unique values.

Action: GSheet - Update Row

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31356 replies
  • Answer
  • September 16, 2020

You can do this in 1 Step using a GSheet.

The GSheet formulas can be constructed to randomly pick 3 unique values.

Action: GSheet - Update Row


Liz_Roberts
Forum|alt.badge.img+8
  • Zapier Staff
  • 1366 replies
  • December 9, 2020

Hi @tmarcus96 ,

Circling back to see if you were able to try out Troy’s suggestions above! Let us know if you’re squared away with this Zap!