Hi all! Newcomer here! I want to do something that I’m sure is pretty simple but there’s something I don’t grasp about ref/key/label and multi worksheet.
For my example, I have a table with 1 product worksheet and 1 images worksheet.
The key Id in the images worksheet is the ImageID column.
The images worksheet contains an ImageURL column where I store the URL.
I’d like to have a product view that shows the product’s name as well as the product’s image.
The reference has to come from a virtual column in the product worksheet as there is no shared ID column in the worksheets.
I’m not sure I’m clear, and I’m not sure I got it all right but I’m sure someone will help me get there eventually Thx!