More > Media Center 16 (Development Ended)

How can i set ratings in increments of a half?

<< < (2/3) > >>

MrC:
I'm sorry for the delay in responding to this.

Here's a way to make a 5 star rating system with pseudo 1/2 stars (shown as unfilled stars).

You're going to make a new user field of type Decimal.  You'll use this field to set the rating.  This is where you'll rate your tracks, and will ignore the stock [Rating] field.

Anywhere you want to see the Stars, you'll enter the expression:

   mid(★★★★★, 0, [rating (mine)])/
   ifelse(math(equal([rating (mine)] % 1, .5)),☆)

This can be in an expression column, a category, thumbnail or caption text.

The results will look like the attached image.

To create the new User field of type decimal:

   Tools > Options > Library & Folders > Manage Library Fields... > Add New Field

and enter Rating (mine) as the new field name.  Set the User data: Data Type to Decimal, and click OK.

Now, to test it out, in a files list in some view, add two new columns by right-clicking somewhere in the header, and and enable the Rating (mine) field.  Then do it again, this time selecting Add Expression Column... and enter the expression above, and give it a name such as Rating Stars (mine).

Now you can set your values in the Rating (mine) field and see the stars reflected in the Rating Stars (mine) column.

Khaoz:
I want to have both ratings, 5 stars (which stores into file) and 10 stars (or halves). Is there a way to make the 5-star rating to autofill when I give the files the 10-star rating? I mean, 1-2 (or 1 and 1.5) will be 1 star, 3-4 (or 2 and 2.5) 2 stars, and so on... The point is to put the number just once.

Sorry if I don't explain myself very clear, language barriers, you know.

MrC:
There's no way to automatically update the Rating field based on another field.

You can create your own 5-Star rating field, say, My Rating 5, and have it be a calculated field based of your other field My Rating 10.

You'll want to Create two fields:

   My Rating 10
     Data Type: Integer
     Acceptable Values: 1;2;3;4;5;6;7;8;9;10

   My Rating 5
     Data Type: 5 Star
     Calculated data: Expression: Math([My Rating 10] / 2)

(note: set the type to 5 Star, and OK out of the dialog to save the field definition.  Then, re-open it, and change to User Calculated and enter the expression above).

Khaoz:
Oh... but that new 5-star field won't save into file, right?

No problem, I think I'll stick to 5-star ratings. It's so unfair! haha

MrC:

--- Quote from: Khaoz on January 26, 2013, 06:01:48 pm ---Oh... but that new 5-star field won't save into file, right?

No problem, I think I'll stick to 5-star ratings. It's so unfair! haha

--- End quote ---

Sure it can, just set the field to Save in file tags (when possible).

Navigation

[0] Message Index

[#] Next page

[*] Previous page