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!
Why are they in separate worksheets?
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.
So what isnโt happening that you want to happen?
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!
Please post a screenshot of the configuration of the โproducts viewโ.
Here we go:
And the bottom of the screen:
I tried that but I still see the warning sign instead of the image
Then your image URL is probably bad. What is an example image URL?
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)
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 ?!
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.
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!
How do you know which image goes with which product?
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
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!
Hey there,
how can i display image using a Image-URL from another File ref to [Product-ID] for example?
For Text iยดm using Following expression for initial-value:
[Product-ID This Table].[Productdescription Ref Table] - for example
But for Image there is no way to insert any initial-value and i canยดt find solution to get it done by App-Formula
Thanks a lot!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |