URGENT!: Pull Data From Other Fields to Create a Record Code
I have a field that I want to be a sort of "Record Code" but I want it to be generated automatically based on other information entered in other fields.
I have figured out how to put the information from other fields and insert it into the "Record Code" field, but I don't want the exact same format.
I want these inputs--
Field--Date Created: "17-Oct-2007 15:33:53"
Field--Facility: "North"
Field--Product: "O-LOSO100"
To output this "Record Code"--
Field--Record Code: "071017-1533-N-O-LO100"
How can I make the date and time format correctly? How can I get the entry "North" to output "N" and the entry "O-LOSO100" to output "O-LO100"?
I need to get this done very soon. Please help!