Okay
  Public Ticket #2800085
Duplicates cell
Closed

Comments

  •  1
    Tymek started the conversation

    Is it possible to search for duplicates while typing?

    https://imgur.com/a/ULOxpHY

  • [deleted] replied

    Hi Tymek

    Thank you for reaching out to us.

    The plugin doesn't have any features that would look for existing data, and disable editing if there already exists an entry like that. You can, however edit a field in the database, adding a unique constraint, like this:

    ALTER TABLE myTableName ADD CONSTRAINT UQ_MyTable_Name UNIQUE (columnName)
    

    And it will not allow anyone to add the same name or example if it already exists in the table.

    I hope this helps, do let us know if there is anything else we can assist you with.

  •  1
    Tymek replied

    Thanks!

  • [deleted] replied

    You are most welcomesmile.png

    If there is anything else we can assist you with please don't hesitate to open a new ticket, we will gladly help.

    Have a wonderful day!