Feng Forum

Support => How To's => : poborn June 21, 2010, 04:42:43 AM

: [Resolved] prevent duplicate task names
: poborn 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.

: Re: prevent duplicate task names
: garrans 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.

: Re: prevent duplicate task names
: poborn 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!!