Condition "if" function for frontmatter variable

[ReaderGuy42]

I have a simple dataview (with the cards addon) that outputs a table for my book database. The frontmatter of the book notes include Medium: , with the values Book, Audiobook, Podcast, etc.

I'd like to implement a field (possibly in the same line as the rating?) that would show a little icon, corresponding to the respective book's medium.

Is this possible? Maybe some sort of if-function? Or an alias that just replaces the medium value with a corresponding icon?

Thanks!

This is my table:

```dataview
TABLE without id 
("![](" + Cover + ")") as Cover,
link(file.link, Title) as Title, 
"by " + Author as Author, 
Year as Year,
"⭐ " + Rating as "⭐ Rating", 
"Started " + DateStarted as "Date Started",
"Finished " + DateFinished as "Date Finished"
FROM "Book Log/2022"
WHERE Medium = "Book" OR Medium = "eBook" OR Medium = "Audiobook" OR Medium = "Podcast"
SORT DateFinished desc

[AB1908]

Your best bet would be the choice() function but for larger custom maps like that, you may want to use IIFEs like in #971 .

[ReaderGuy42]

I'll try the choice thing first, but I'm not sure how to implement it exactly. Do I do it like choice("Medium: Book", 📖, 🎧) as "Medium", Or how would I do this?

This outputs a -. This is probably because what I'm trying to query is in the file itself?

[AB1908]

Oh hmm so we'd need nesting here. choice(medium == "Book", "📖", choice(medium == "Podcast", "🎧", "was neither book nor podcast")).

[ReaderGuy42]

That sounds good, but I'm still not sure how to use that? If I put that in the table query alongside the other stuff like Title as Title I get an error.

[AB1908]

My mistake, use single = instead of ==.

[ReaderGuy42]

Awesome, that works :)