Hi all, I was wondering if there is a way to...

(Michael Smith) #1

Hi all,

I was wondering if there is a way to dynamically show an image in the deck view based on the value of a column.

I have a pyment table and have and image column for a reminder, but would like that image to change the item is marked paid, which I have a yes/no column for, I tried using two image columns and using Show_if, but that only shows the reminder image.

any thoughts?


(Grant Stead) #2

Yes, do this all the time. Create a virtual column as type thumbnail. Then write an expression… IF column is marked paid show image.png else show image2.png

(Grant Stead) #3

Then mark that VC as your image column

(Aleksi Alkio) #4

You could try to add a virtual column with the formula IF([STATUS]=TRUE,“Image#1.png”,“Image#2.png”) and then use that for the deck view. Have you thought to use format rule instead of an image?

(Michael Smith) #5

thanks guys, I am using format rules to change color as it nears due date and past due, just dont really like the icons available, can you show an image with format rules?, also where to i store the images, right now they are in the root folder with my app data, does it have to be a virtual column or can I use the expression in the image column I have.

(Grant Stead) #6

@Michael Smith the root folder is fine, and it should be a virtual… VCs calculate right away

(Michael Smith) #7

awesome, thanks. Trying it now.