Copy submission_id to another field

[bhotrock]

Hi,

Is there any way to copy the value of the submission_id field into another field at the time of submission (or immediately after)? I need to use the submission_id number in another application, but it doesn't like that the field type is integer. I really need it in a Varchar field type.

I'm guessing there might be a way to do this with the Hooks Manager. But that's probably a bit of a stretch for me. If someone can at least let me know it's possible, that will get me started. Any hints or examples would be greatly appreciated.

Thanks!
Brad

[bhotrock]

Just in case anyone is looking for something similar. I ended up handling the copy (and conversion) process by using mySQL commands in a shell script that is run by a cron job.