Unique field

[theBuzzyCoder]

https://forum.espocrm.com/forum/developer-help/51664-unique-field-error

[Exsto]

One can add

{
"fields": {
"fieldName": {
"unique": true
}
}
}

in metadata.entityDefs.Entity.json under fields.fieldName

Hi,
has anything changed? Can I create a varchar field and make it unique?
I have to make the VAT number unique.
Thank you

[theBuzzyCoder]

hi
1. Can I create a value field in which can only be unique?

One can add

{
    "fields": {
        "fieldName": {
            "unique": true
        }
    }
}

in metadata.entityDefs.Entity.json under fields.fieldName

[tanya]

in database only

[rucrm]

Can I edit this field (number) or only in the database?

[tanya]

number field or autoincrement

[rucrm]

hi
1. Can I create a value field in which can only be unique?