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?