I am setting up support for a clothing manufacturer's returns system. Currently the ticket IDs start at 1. this is not a huge problem but it would be great if I could have this start at a specific number, or assign a specific number to the ticket with the click of a button.

IE: Customer submits a ticket for a broken zipper on his coat. once we get the ticket and see that we return is in order is there a way to setup "add RA Number" and have the system auto assign a sequential number starting with say 202238

the actual number wouldnt be important as long as I can tell it a specific number to startwith somewhere in the system.

I know this will require some work outside the current scope of the module, but is there a way to do this with CCK or perhaps a simple mod to the current module?

I have NOT attempted to modify a module yet or to create a module - so currently that is not a viable option at this time, but I am working towards that.

thanks

Comments

jeremy’s picture

jeremy commented

Tickets are simply nodes. Ticket IDs are simply Node IDs. Thus, you could try and do what you want by setting the AUTO_INCREMENT value in your node table, something like:

ALTER TABLE node AUTO_INCREMENT = 202238;

That simply tells MySQL to start auto incrementing from 202238. Note that if already had a node with nid 202238, this would cause you problems as Drupal would try creating a second node with the same nid and fail. This is not a value you'll want to keep changing.

Madapple’s picture

Madapple commented

ok that will certainly fix that... and I can easily just tell the Customer Service rep to use the ticket ID as the RA number...

so now I just have to add a field that only the admin can access that says "RA Assigned"

thanks!!!!!

jeremy’s picture

jeremy commented
Status: Active » Fixed

Sounds like this works for you. Closing.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.