Custom Column for Identifiers, or combined with ISBN?

Vortex · 12-16-2014, 02:30 PM

Is it possible to have 'Identifiers' as a custom column, or better still combine it with the ISBN custom column so if there is no ISBN it shows the Identifier instead? Thanks.

BetterRed · 12-16-2014, 02:49 PM

@Vortex - create a custom column of type Column built from other columns, behaves like tags with template {identifiers}

It won't be very pretty.

BR

Vortex · 12-17-2014, 06:30 AM

Actually that's just what I was looking for, it shows the ISBN if there is one or an Identifier if not. Means I can remove the ISBN column and see at a glance whether the books has been identified or not.

theducks · 12-17-2014, 10:21 AM

Why bloat your DB (affects performance) using a custom column, with something that can be done with a filter or VL ?

From the Users guide
identifiers:=isbn: and identifiers:isbn:true will find books with a type equal to isbn having any value
identifiers:=isbn:false will find books with no type equal to isbn.

Vortex · 01-18-2015, 02:41 PM

Quote:

Originally Posted by BetterRed

@Vortex - create a custom column of type Column built from other columns, behaves like tags with template {identifiers}

It won't be very pretty.

BR

It's Brilliant, I love it.

Can I make the column 'enterable', so I can enter the identifiers by clicking on the box in the main interface the same way we now can do it with Authors, Title and Series ?

theducks · 01-18-2015, 02:54 PM

Quote:

Originally Posted by Vortex

It's Brilliant, I love it.

Can I make the column 'enterable', so I can enter the identifiers by clicking on the box in the main interface the same way we now can do it with Authors, Title and Series ?

No
You make entries in the main column it was built from

arpeggioaccele · 07-22-2023, 01:01 PM

Does anyone know if there's a way to do the opposite, I need to make custom column data into an identifier.

I've been extracting the first link from inside the epub file and putting them in a links column. I want those to be a url: identifier. (This is for ao3 fanfiction, I understand fanficfare does this but only when downloading metadata from ao3 and I want to avoid that step.)

12-16-2014, 02:30 PM	#1
Vortex Groupie Posts: 171 Karma: 10 Join Date: Dec 2008 Device: Likebook Mars	Custom Column for Identifiers, or combined with ISBN? Is it possible to have 'Identifiers' as a custom column, or better still combine it with the ISBN custom column so if there is no ISBN it shows the Identifier instead? Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to clear all Identifiers (Ids) except ISBN	paul55391	Library Management	11	06-17-2014 09:52 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
How to swap title with identifiers:isbn	tizboy	Library Management	1	06-06-2012 08:48 PM

12-16-2014, 02:49 PM	#2
BetterRed null operator (he/him) Posts: 21,715 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	@Vortex - create a custom column of type Column built from other columns, behaves like tags with template {identifiers} It won't be very pretty. BR

12-17-2014, 06:30 AM	#3
Vortex Groupie Posts: 171 Karma: 10 Join Date: Dec 2008 Device: Likebook Mars	Actually that's just what I was looking for, it shows the ISBN if there is one or an Identifier if not. Means I can remove the ISBN column and see at a glance whether the books has been identified or not.

12-17-2014, 10:21 AM	#4
theducks Well trained by Cats Posts: 31,037 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Why bloat your DB (affects performance) using a custom column, with something that can be done with a filter or VL ? From the Users guide identifiers:=isbn: and identifiers:isbn:true will find books with a type equal to isbn having any value identifiers:=isbn:false will find books with no type equal to isbn.

07-22-2023, 01:01 PM	#7
arpeggioaccele light mode user Posts: 67 Karma: 16268 Join Date: May 2023 Location: New England Device: I use the Calibre ebook-viewer on macos and Apple Books on ios.	Does anyone know if there's a way to do the opposite, I need to make custom column data into an identifier. I've been extracting the first link from inside the epub file and putting them in a links column. I want those to be a url: identifier. (This is for ao3 fanfiction, I understand fanficfare does this but only when downloading metadata from ao3 and I want to avoid that step.)

Advert

Advert