Change Icon based on column value

irongiant · 03-06-2022 10:20 AM

I am looking to write an expression to change the image for a card based on the value of one of the columns. It would be a IF statement but configure out the expression. Read through some of the documentation for AppSheet but still unable to pull it together.

I have a column called "Type", it has two possible values "Medical" & Documentation". For my "Icon" column I am trying to write an expression to link to one image if the "Type" is "Medical" and a different image if the "Type" is "Documentation"

Something like below, I know it's wrong but hopefully enough so you know what I am trying to write.

IF([Type] = "Medical", HYPERLINK("https://www.google.com/picture1.jpg", "Picture1")) OR IF([Type] = "Documentation", HYPERLINK("https://www.google.com/picture2.jpg", "Picture2"))

Marc_Dillon

Try IFS() instead.

https://help.appsheet.com/en/articles/2355961-ifs

Also, that's not how OR works in Appsheet.

https://help.appsheet.com/en/articles/2357288-or