Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Random Lookup to Attachment

Topic Labels: Formulas
108 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey,

I’m looking for a solution to choose the random row from another table.

Here’s my scenario:
2 tables. One has text data, the other has just two columns: ID and Attachment (in this case it’s a png file). I want to create a lookup filed to pull the attachment, but I want this lookup to pull the RANDOM ID out of finite number of rows (like 10 in my example).

I could do that in Excel by combining VLOOKUP with RANDBETWEEN functions, but how to I do that in Airtable?

Thanks!

0 Replies 0