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"))
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
User | Count |
---|---|
43 | |
29 | |
29 | |
14 | |
14 |