Use URL image from other worksheet

[JM_P]

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!

[Steve (Steve Coile)]

@JM_P

For my example, I have a table with 1 product worksheet and 1 images worksheet.

Why are they in separate worksheets?

[JM_P]

Hi @Steve,

Because in my final project that’s how the data is exported from Shopify products through a third-party app, I have no control over that.

[Steve (Steve Coile)]

So what isn’t happening that you want to happen?

[JM_P]

Well, in the products view I would like to have both the product’s name as well as its picture, which comes from the images worksheet. I’m probably missing something simple but I don’t get the pictures displayed!

[Steve (Steve Coile)]

Please post a screenshot of the configuration of the “products view”.

[JM_P]

Here we go:

[JM_P]

And the bottom of the screen:

[Steve (Steve Coile)]

[JM_P]

I tried that but I still see the warning sign instead of the image

[Steve (Steve Coile)]

Then your image URL is probably bad. What is an example image URL?

[JM_P]

The image URL looks ok as when I add an Image view they show up without problem, the issue is only when I want to display them from the products view.

(https://upload.wikimedia.org/wikipedia/commons/thumb/e/e1/FullMoon2010.jpg/420px-FullMoon2010.jpg)

[JM_P]

In my first message there is an error, the Image_ID isn’t supposed to be created from the table as it’s not present in the products Worksheet, I did forget to re-generate the columns after modifying the worksheet.

So the REF column must come from a virtual column, and I’m not sure what to put in the expression, any help would be appreciated, looks like that’s where I’m having troubles ?!

[Steve (Steve Coile)]

@JM_P

In my first message there is an error

Please post a screenshot from the app editor of the corrected column list. Please also post a screenshot from the app editor of the column list of the images table.

[JM_P]

Here’s the table with the updated columns, including the REF type virtual one which I’m not confident filling the formula field:

And here’s the Images table, which I think is pretty straight-forward unless I’m missing something else:

Thanks in advance for your help!

[Steve (Steve Coile)]

How do you know which image goes with which product?

[JM_P]

Hmm Good point! In some way I assumed the row numbers were inherently connected and image at line 2 would match product at line 2, I realize now that’s not a wise assumption!
In the data exported from the Shopify store by the 3rd party app I assumed the same and it’s not the case neither, plus I don’t see a field in that exported GoogleSheet that could help me link them together!

I’m going to ask the Shopify Sheets app developer for details and come back if I’m still stuck with this.
Anyways thank you very much for your ongoing support on this, I really appreciate!

JM

[JM_P]

Alright! In the end I found out that they provide unique IDs (product ID) in the worksheet, they were the first columns and were hidden but they show up in Appsheet anyways!
So I’ve set that product ID in the Images worksheet as key value, and the product ID in the products worksheet as a Ref, with images worksheet as source.

I then created an Image virtual column, with the expression [product ID].[ImageURL], set it as label, and voilà!

Thank you very much for the support! I still need to really grasp the concepts and differences between all the appsheet terms and especially how to build relationships between tables/worksheet in a clean way that makes sense, but I’m now on track!

Have a good day!