Help needed for Custom Column

[slb]

I've been struggling with the template language to make a custom column.

Any help would be appreciated.

For sorting purposes I've created a custom column #sorttype.

I want this column to show:

if column #type has the value "Extra", show "Ebook"
if column #type has the value "Bonus", show "Ebook"
if column #subtype has the value "Chapter", show "Other"
if not show the value in column #type

Can someone give me the line that I simply need to copy and paste into the custom column template? Otherwise I fear, I will miss again.

[dunhill]

I don't know if this will help, but try it and let me know.

program:
    if field('#type') in ['Extra','Bonus'] then
        'Ebook'
    elif field('#subtype') == 'Chapter' then
        'Other'
    else
        field('#type')
    fi

[slb]

Thank you.

I had just found a working solution.
I've slightly changed it as I've changed the original metadata.

template:

program:
test(list_intersection('Extra', field('#type'), ','), 'Ebook', field('#type'))

With this my costum column #sorttype does this:
if column #type has the value "Extra", show "Ebook"
if not show the value in column #type