INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Craig on December 27, 2005, 08:38:01 am

Title: Calculated Field Help
Post by: Craig on December 27, 2005, 08:38:01 am

Is it possible to add a calculated field which contains the initial letter of the artist name?
I want to use it in my directory structure to keep it easier to navigate.

Thanks in advance
Craig

Title: Re: Calculated Field Help
Post by: hit_ny on December 27, 2005, 09:35:35 am

Since they allow expressions in Calucalted fields with 11.1, you could use the mid expression to give just the first character.

Not on 11.1 yet myself tho.

Title: Re: Calculated Field Help
Post by: Craig on December 28, 2005, 08:42:45 am

Thanks for that, I'm still using 11.0 so I'll have a dabble when i've upgraded.

Craig

Title: Re: Calculated Field Help
Post by: EpF on January 08, 2006, 11:58:28 am

Quote from: Craig on December 27, 2005, 08:38:01 am

Is it possible to add a calculated field which contains the initial letter of the artist name?
I want to use it in my directory structure to keep it easier to navigate.

Did you know that under 'Edit View Scheme', you can add the 'Artist' Field twice, and choose to group the field by a size of 1, which automatically gives you the first letter or digit of the artists name in a pane?

Looks like this:
(http://www.alluvialplains.com/Images/MC/ArtistGrouping.gif)

Is that what you are after?