Deck with a virtual column

[Cannone_Cannone]

Hi everyone
I would like to create a deck with a virtual column.
the image of the view must be loaded from another table and insert an image based on the value of a column.
example :
if column “op” = a “ty” insert image ty.pnj
thank you

[MultiTech]

try a formula like this:

select(Image_Table[Key], and([_thisrow].[op] = “ty”, [Image] = “ty.pnj”))

Where

• Image_Table - is the table holding the images
• Key - is the column marked as the key for the image table
• [_thisrow].[op] - this is the column IN THE TABLE HOLDING THE VIRTUAL COLUMN that you’re pulling data from
• [Image] - this is the column that holds the actual image file name; most likely you’ll need to update this to the actual value for the image you want (look in the spreadsheet)

[Cannone_Cannone]

Okay, thanks, I’ll try.
But if I have to have more variable how do I do?
Example if in the column instead of “ty” I have the value “Tz”

[MultiTech]

MultiTech_Visions:

select(Image_Table[Key], and(
  [_thisrow].[op] = “ty”, 
  [Image] = “ty.pnj”
))

To include multiple options for the column value, use IN() instead of the = opperator

select(Image_Table[Key], and(
  in([_thisrow].[op], LIST(“ty”, "tz", etc.)),
  [Image] = “ty.pnj”
))

[Cannone_Cannone]

I’m sorry, I think I made myself clear.
I on each row of the Google sheet will have a different “op” column value.
How do I associate the correct image to the value type?
The images are about 30
Thank you.

[MultiTech]

Do you have the values stored in the sheet with the images?

Like: You’ve got Column 1 (the image), Column 2 (Op column), Column 3 (etc.) maybe more columns??

---

Also, in the table where you’re wanting to import these images, is there a column that will hold the value for that view? LIke TY for one, another is tx, etc.?

[Cannone_Cannone]

exactly!

[MultiTech]

Then this makes things SOOO much easier

select(Image_Table[Key], [op] = [_thisrow].[Column_With_Value])

[Cannone_Cannone]

I am hopeless !!!

[Steve]

Wrap the SELECT() expression in ANY().

[Cannone_Cannone]

but the table where I keep the images must refer to the table where I insert the virtual column?

[Cannone_Cannone]

[Steve]

The error tells you what the problem is: the vettore column contains a Ref value but your Virtual Column 1 expects an Image value.

[MultiTech]

Is this an image column?

[Cannone_Cannone]

The Image refers to the table called vector where I keep the images.
the virtual column was created in the “centering” table which has a vector column (image) and an OP column (TEXT)

[Cannone_Cannone]

in the OP column if I find an example an “AC” value I want it to insert the image of the vector table
sorry and thanks for the help

[MultiTech]

try this:

select(vettore[image], [vettore] = [_thisrow].[op])

[Steve]

…wrapped in any()…

[MultiTech]

but if you want the deck view, it needs to be a list… and the key column now that I look at the formula.

Whichever key in the vector table is marked as the KEY in appsheet should be in the COLUMN_HERE space in the formula:

select(vettore[COLUMN_HERE], [vettore] = [_thisrow].[op])

[Cannone_Cannone]

Resolved !!!
Thank you

any(select(vettore[image], [vettore] = [_thisrow].[op]))

[MultiTech]

Woohoo!

[Cannone_Cannone]

[Cannone_Cannone]

then the vector table before was in the same google sheet.
I wanted to create another database folder I imported the new table and now it doesn’t work anymore !!

[Cannone_Cannone]

if I add the table in the google sheet of appsheet everything works