View Single Post
Old 08-18-2023, 09:07 PM   #706
Rellwood
Library Breeder (She/Her)
Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.
 
Rellwood's Avatar
 
Posts: 1,289
Karma: 1937893
Join Date: Apr 2015
Location: Fullerton, California
Device: Paperwhite 2015 (2), PW 2024 (12 GEN), PW 2023 (11 GEN), Scribe (1st)
Quote:
Originally Posted by nguoi doc sach View Post
Please someone help me,
I want to put a comma in Votes numbers but I don't know how to do it correctly. Does anyone figure out this yet?
Hi!,

Here is what I do. Sorry it's long, but once it's set up you are good.

I have always used the Goodreads Rating plugin with F_rating, but lately I have just used the new Goodreads with the ratings and the number of votes. Since these are recorded as identifiers, you need to create the custom columns for the identifiers, but this is where you can modify it.

I attached some pictures to show:

Create the columns needed by the new plugin for the average rating and the number of votes as directed.

If you haven't already, create a floating intenger column for the average ratings (for me it's the same column that was created with the older plugin {#gr1})

Also create a new "number of votes" column

If you haven't already done it, it's a good time to install the "Mass Search and Replace" plugin. Create a new rule for GR Ratings/Votes

Create two sets of rules where you copy the column with the identifier for ratings to the column you created with the floating decimal point.

Do the same thing for the number of votes

Now you need to create an icon rule of some sort to let you know when you have a ratings/votes in a book that isn’t showing up in the new columns you set up.
These columns are set up so they automatically follow the decimal point and commas you want. Since you can’t do it with identifiers, and because the column for the identifiers is composite and you can’t change it, what you want is to move those identifiers into the column you created.

Now you should have the "Mass Search and Replace" plugin installed. If you do, then create a new set of rules for moving the numbers from the composite columns (the ones filled in by the plugin) to the new ones. Two rules, one for each column. Give it a name like “GR Ratings/Votes” and basically only run it when you know you have the numbers.

I also created an icon rule set that lets me know when the plugin added new ratings/votes, but I haven’t yet copied them over. This is nice to let you know when you need to do it

Kind of a pain to set up, but once it’s done, it’s pretty autmated and will get those ratings/votes into columns with decimal points and commas.
Attached Thumbnails
Click image for larger version

Name:	Ratings Column.jpg
Views:	384
Size:	219.7 KB
ID:	203209   Click image for larger version

Name:	Number of Ratings.jpg
Views:	310
Size:	218.8 KB
ID:	203210   Click image for larger version

Name:	mass search replace 2.jpg
Views:	289
Size:	96.4 KB
ID:	203214   Click image for larger version

Name:	grrating to my ratings column.jpg
Views:	296
Size:	261.1 KB
ID:	203215   Click image for larger version

Name:	grvotes to number of ratings.jpg
Views:	285
Size:	208.4 KB
ID:	203216   Click image for larger version

Name:	notification for ratings.jpg
Views:	275
Size:	234.0 KB
ID:	203217   Click image for larger version

Name:	notification for votes and ratings.jpg
Views:	301
Size:	233.2 KB
ID:	203218  
Rellwood is offline   Reply With Quote