INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Manipulating library field output in theater view  (Read 2093 times)

moordred

  • Recent member
  • *
  • Posts: 6
Manipulating library field output in theater view
« on: November 11, 2016, 03:17:27 am »

Hi everyone.
Does someone know how I can define the "critics rating" library field output to my own defined interval?
At the moment its defined as one decimal grouping (7.9, 7.8, 7.7 and so on) Which in my opinion makes it a bit cluttered.

I tried to change the group value, but I think I'm lacking some expression/knowledge to make it work.
thanks in advance
/D
Logged

221bBS

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 703
Re: Manipulating library field output in theater view
« Reply #1 on: November 11, 2016, 04:38:45 am »

Here are some expressions you can try...

This will round the number up (7.8 becomes 8)
Code: [Select]
FormatNumber([Critics Rating],0)
or if you want to round down (7.8 becomes 7)
Code: [Select]
ListItem([Critics Rating],0,.)
If the value is between 1-10 you can also output it with stars by changing the Edit Type to 10 stars

Logged

moordred

  • Recent member
  • *
  • Posts: 6
Re: Manipulating library field output in theater view
« Reply #2 on: November 11, 2016, 07:16:14 am »

Thank you!
I tried to create an expression in video/movies/genre. But it didnt seem to work. (Also tried it in grouping size window on "critic rating" field just for the hel of it)

Do i need to apply this in the tag field when i "import"?
Logged

221bBS

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 703
Re: Manipulating library field output in theater view
« Reply #3 on: November 11, 2016, 10:14:06 am »

Click Tools > Options > Library & Folders > ... Manage Library Fields...

A new window will pop up called Manage Library Fields. Click Add New Field and enter a name for the field, i.e. Rating (Critics). This will create a new field titled Rating (Critics).

Click the radio button next to Calculated data and enter one of the following in the Expression field.

This will round the number up (7.8 becomes 8)
Code: [Select]
FormatNumber([Critics Rating],0)
or if you want to round down (7.8 becomes 7)
Code: [Select]
ListItem([Critics Rating],0,.)
Optional settings...
If this is only for videos, click the Flags field and uncheck all but Videos and maybe TV.

If you want to have this shown as stars, i.e. ★★★★★☆☆☆☆☆, click the Edit Type field and set it to Ten stars.


Click OK to close the Manage Library Fields. Click OK again to close Options window.

Substitute the Rating (Critics) field (if that's what you titled yours) for the Critics Ratings field in your theater view.
Logged
Pages: [1]   Go Up