Solved: Reference unknown number of Images in a Form - Page 2

DarenJanes · 09-16-2022 05:27 PM

Ideally, I would like to have one virtual column that would retrieve images from a table for reference when completing a form. I can select one image with one virtual column. I could add multiple virtual columns, but I don't know how many images will exist. Hopefully what I'm asking is clear enough.

ANY(SELECT(Inventory Attachments[Attachment Image],AND([Type]="Image",1=1,TRUE)))

I try really hard to limit Virtual Columns, because I've read they are bad for performance.

Appreciate ideas, I played with REF_ROWS but didn't seem to work. I need the images to be decent size.

Thanks,

Daren

WillowMobileSys

Oops, sorry. That was my mistake. The SELECT() needs to change so that it returns the row keys. A Ref column means that you are supplying the "pointer" to a row or rows. You can then "dereference" any column on that row to use in expressions. But as in your case, it will be used to populate a view with a list of rows.

Slight modification to the expression like this:

SELECT(Inventory Attachments[Key column here],[Type]="Image")

Replace [Attachment Image] with the name of the column that is set as the key for the Inventory Attachments table.

View solution in original post