Random Lookup to Attachment


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?


This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.