MobileRead Forums - View Single Post

Krishnam Prabhu · 05-11-2022, 06:30 AM

Query:
I have e-books in my library with a few custom columns. One such custom column labeled as "Accession Number" so that to avoid duplications (i.e.) No e-book record should have the same Accession Number―An Unique Column. Now when adding a new set of e-books to the same library, but unfortunately if I specified a previous mapped Accession number to the new e-book, then it would be a tragedy!

Suggest:
I need to set a rule or validation message warning when I repeat the same Accession Number. This also implies to have the same structure to ISBN [Pre-Defined Column], so that no e-books have the same ISBN.

Gist:
Finally, to say that all records should be unique but not identical.

05-11-2022, 06:30 AM	#1
Krishnam Prabhu Junior Member Posts: 3 Karma: 10 Join Date: Jul 2019 Location: India Device: Calibre	To construct an unique column Query: I have e-books in my library with a few custom columns. One such custom column labeled as "Accession Number" so that to avoid duplications (i.e.) No e-book record should have the same Accession Number―An Unique Column. Now when adding a new set of e-books to the same library, but unfortunately if I specified a previous mapped Accession number to the new e-book, then it would be a tragedy! Suggest: I need to set a rule or validation message warning when I repeat the same Accession Number. This also implies to have the same structure to ISBN [Pre-Defined Column], so that no e-books have the same ISBN. Gist: Finally, to say that all records should be unique but not identical.