Custom column - Rating

twstdwspr · 09-23-2015, 01:37 AM

Hi I'm in need of some help. I have looked around and haven't seen this posted so figured I'd try. I'm trying to setup a new custom column and what i want to do is use the Rating column, but instead of the stars I want to replace it with the Ratings from within my Fan fictions. So if it is Teen I want it to say Teen instead of coming up as the stars. I also want to be able to add others in as time goes on.

I'm not very fluent on the programming side and sadly i wish i was a little more so but, any help would be appreciated if you understand what I'm trying to do. Thank you

davidfor · 09-23-2015, 02:14 AM

I don't think a ratings-like column is suitable for what you want. It sounds like a "Text, but with a fixed set of permitted values" would be more suitable. With that, you enter a list of the values you want, and then select them from a drop-down when the book is added.

fidvo · 09-23-2015, 12:30 PM

Quote:

Originally Posted by davidfor

I don't think a ratings-like column is suitable for what you want. It sounds like a "Text, but with a fixed set of permitted values" would be more suitable. With that, you enter a list of the values you want, and then select them from a drop-down when the book is added.

Agreed. I have a similar field in one of my libraries and it works great. As a bonus, you can optionally set up the field with colors to make the distinctions more visible.

Adding new options as time goes on is a little tricky for this type of field. You have to go into the field properties and add the new value there, plus one more color if you're using colors.

If you suspect you're going to be adding possible values often in the future, you might go with a tag-like field instead. The fixed-values field is best if you intend to set it up ahead of time and rarely make changes to the possible values.

theducks · 09-23-2015, 12:58 PM

Fixed prevents the proliferation of 'tags' by only allowing the SINGLE preset value.

TBD should be one choice to allow a place-holder marking, while you fix the omission.

Order the value list by frequency usage (entering first letter in the field jumps to the first item with that value. Another entry, jumps to the next with that letter)

twstdwspr · 09-24-2015, 09:47 AM

Thank you all for the help! It's working great. I was kinda curious though if it was possible to automate it. Cause at the moment the only way for me to know which story is rated say Teen, or such is I have to edit the book and find it. It does take quite a bit of time especially when you have a lot of fanfics. If it is not possible it's not a big deal I can manage just thought I'd ask.

BetterRed · 09-24-2015, 04:53 PM

Quote:

Originally Posted by twstdwspr

Thank you all for the help! It's working great. I was kinda curious though if it was possible to automate it. Cause at the moment the only way for me to know which story is rated say Teen, or such is I have to edit the book and find it. It does take quite a bit of time especially when you have a lot of fanfics. If it is not possible it's not a big deal I can manage just thought I'd ask.

@twstdwspr - why do you need to edit it to 'rate' it?

Couldn't you just skim read it or obtain from a summary on the site where you got the story?

BR

davidfor · 09-24-2015, 07:12 PM

How are you getting the fanfic? If you are using the FanFicFare plugin, you might be able to automate this as part of the download. And for the fanfic you already have, I think you can do a metadata only download.

twstdwspr · 09-24-2015, 08:14 PM

To answer that question I download the .epub file from the site and drag and drop it into calibre. As for FanFicFare some of the authors are no longer writing and have removed there fics from most sites so using the plugin won't help me in that aspect.

09-23-2015, 01:37 AM	#1
twstdwspr Junior Member Posts: 3 Karma: 10 Join Date: Sep 2015 Device: none	Custom column - Rating Hi I'm in need of some help. I have looked around and haven't seen this posted so figured I'd try. I'm trying to setup a new custom column and what i want to do is use the Rating column, but instead of the stars I want to replace it with the Ratings from within my Fan fictions. So if it is Teen I want it to say Teen instead of coming up as the stars. I also want to be able to add others in as time goes on. I'm not very fluent on the programming side and sadly i wish i was a little more so but, any help would be appreciated if you understand what I'm trying to do. Thank you

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Decimal "Rating" column (Custom) and Stars	Chris_Snow	Library Management	6	04-06-2015 12:25 PM
Rating column?	unabatedshagie	Library Management	3	10-10-2014 06:11 AM
Custom column returns value based on value of another custom column?	calvin-c	Calibre	3	09-14-2013 02:24 PM
Custom yes/no column built from long text column	Philantrop	Library Management	7	03-23-2013 07:44 PM
how to move value(s) of tag column to a custom made column	zoorakhan	Library Management	0	12-08-2012 03:53 AM

09-23-2015, 02:14 AM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	I don't think a ratings-like column is suitable for what you want. It sounds like a "Text, but with a fixed set of permitted values" would be more suitable. With that, you enter a list of the values you want, and then select them from a drop-down when the book is added.

09-23-2015, 12:58 PM	#4
theducks Well trained by Cats Posts: 30,939 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Fixed prevents the proliferation of 'tags' by only allowing the SINGLE preset value. TBD should be one choice to allow a place-holder marking, while you fix the omission. Order the value list by frequency usage (entering first letter in the field jumps to the first item with that value. Another entry, jumps to the next with that letter)

09-24-2015, 09:47 AM	#5
twstdwspr Junior Member Posts: 3 Karma: 10 Join Date: Sep 2015 Device: none	Thank you all for the help! It's working great. I was kinda curious though if it was possible to automate it. Cause at the moment the only way for me to know which story is rated say Teen, or such is I have to edit the book and find it. It does take quite a bit of time especially when you have a lot of fanfics. If it is not possible it's not a big deal I can manage just thought I'd ask.

09-24-2015, 07:12 PM	#7
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	How are you getting the fanfic? If you are using the FanFicFare plugin, you might be able to automate this as part of the download. And for the fanfic you already have, I think you can do a metadata only download.

09-24-2015, 08:14 PM	#8
twstdwspr Junior Member Posts: 3 Karma: 10 Join Date: Sep 2015 Device: none	To answer that question I download the .epub file from the site and drag and drop it into calibre. As for FanFicFare some of the authors are no longer writing and have removed there fics from most sites so using the plugin won't help me in that aspect.

Advert

Advert