MobileRead Forums - View Single Post

Krishnam Prabhu · 05-12-2022, 07:00 AM

I'll make it clear. I need the pre-defined column (field) or custom column (field) should be unique. If by mistake I entered the same value, then it should not save. Kindly look at the following sample library structure:

Accession No. Title ISBN
AN-001 Book01 9781234567890
AN-002 Book02 9781234567891
AN-003 Book03 9781234567892
AN-003 Book04 9781234567893
AN-005 Book05 9781234567894
AN-006 Book06 9781234567895
AN-007 Book07 9781234567896
AN-008 Book08 9781234567897
AN-009 Book09 9781234567897
AN-010 Book10 9781234567899

The "AN-003" and "9781234567897" are unfortunately duplicated in Accession No. and ISBN respectively. Now my request is to get a warning message to state that the new value that is entered is already existing in the library. So software should prevent me from input duplicate data.

05-12-2022, 07:00 AM	#4
Krishnam Prabhu Junior Member Posts: 3 Karma: 10 Join Date: Jul 2019 Location: India Device: Calibre	To construct an unique column I'll make it clear. I need the pre-defined column (field) or custom column (field) should be unique. If by mistake I entered the same value, then it should not save. Kindly look at the following sample library structure: Accession No. Title ISBN AN-001 Book01 9781234567890 AN-002 Book02 9781234567891 AN-003 Book03 9781234567892 AN-003 Book04 9781234567893 AN-005 Book05 9781234567894 AN-006 Book06 9781234567895 AN-007 Book07 9781234567896 AN-008 Book08 9781234567897 AN-009 Book09 9781234567897 AN-010 Book10 9781234567899 The "AN-003" and "9781234567897" are unfortunately duplicated in Accession No. and ISBN respectively. Now my request is to get a warning message to state that the new value that is entered is already existing in the library. So software should prevent me from input duplicate data.