Author Topic: [Resolved] prevent duplicate task names  (Read 2165 times)

poborn

  • Newbie
  • *
  • Posts: 7
    • View Profile
[Resolved] prevent duplicate task names
« on: June 21, 2010, 04:42:43 am »
We are trialling feng office as a TV advertisement tracking system in our TV production house.
Each task name must be unique. (each task name is a unique TV advertisement)
How can I stop duplicate entries of task name?
eg. if I enter a task name as TW0025 how can i stop someone entering TW0025 as a new task in the future? is there something I can modify in Mysql?or php script?
thank you in advance.
« Last Edit: June 30, 2010, 12:30:52 am by poborn »

garrans

  • Newbie
  • *
  • Posts: 4
    • View Profile
    • Email
Re: prevent duplicate task names
« Reply #1 on: June 21, 2010, 11:11:25 am »
I agree this is an issue.
In addition, if you hit save quickly twice you end up with 2 items the same name.

poborn

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: prevent duplicate task names
« Reply #2 on: June 21, 2010, 09:32:02 pm »
I have managed to prevent duplication by accessing the table via phpmyadmin and changing the title field from text to varchar(14, thats the limit of our keynumbers) and making the title field unique (using the unique action button).
hopefully this doesn't create a problem anywhere else in the system, all good...... so far!!
« Last Edit: June 21, 2010, 09:38:58 pm by poborn »