Perhaps I've misunderstood what you want to use the ID for. I thought you wanted a unique reference number for a list item, and the ID gets you that. I wasn't proposing that you use it to create a value in another field. (I'm not sure that you can given that the ID may be assigned when the item is added to the list, rather than when the NewForm.aspx page is displayed). Can you quickly outline what your requirement is?
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Noone Sent: Thursday, 17 July 2008 10:00 AM To: [email protected] Subject: RE: [OzMOSS] Create timestamp for column Hi David, the ID would actually do nicely. Although I'd love to get the employee name into there as well. How do I use the ID column value in a calculated formula. It seems MOSS is very picky about which columns can and can't be used, and how. I've tried [id] but get the error: The formula contains reference(s) to field(s). Regards, Paul Online Developer, ICT CEO Sydney From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Crabbe, David Sent: Thursday, 17 July 2008 11:57 AM To: [email protected] Subject: RE: [OzMOSS] Create timestamp for column The Title column is a PITA. It's a Single Line of Text by default and it's type can't be changed. Even if you change the name of the column, it's still called Title internally. However each list item will have an internal ID associated with it. You can see this in action when you open the DispForm.aspx for a list item as the URL will have a query string like ?ID=<number>. Can you use this ID instead for your purposes? Just a thought, David. David Crabbe Consultant Web Solutions Team Fujitsu Australia Ltd T: +61 8 9268 1505 E: [EMAIL PROTECTED] ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Noone Sent: Thursday, 17 July 2008 8:58 AM To: [email protected] Subject: [OzMOSS] Create timestamp for column I'm trying to give a hidden Title column a timestamp "yyyy/mm/dd hh:mm:ss" or random value of some kind using its Default value: Calculated value. I've used - =DATE(YEAR(Today),MONTH(Today),DAY(Today)) - which gets accepted but returns nothing. The Today function doesn't appear to work and there doesn't seem to be a NOW equivalent or simple function to enter the seconds since epoch, or even a random number. I can't delete or change the type for the Title column because the content type uses Item as a parent. Is there some other way to get the hyperlink/action functionality for a column? Or should I have started with another content type as parent? Any suggestion (apart from creating extra columns) appreciated. Ugh. Soz. Been a long week. J ________________________________ ________________________________________________________________________ ____ This e-mail is intended for the use of the addressed recipient(s) only and may contain confidential and privileged information. If you have received this message in error, please delete the message and any attachments and copies immediately; and notify the sender by return e-mail. Any views expressed in this message or any attachments are those of the individual sender and do not necessarily represent the corporate opinion of the Catholic Education Office (CEO), Sydney. The CEO Privacy Policy is located at http://www.ceo.syd.catholic.edu.au ________________________________________________________________________ ____ ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you. If you do not wish to receive commercial email messages from Fujitsu Australia Limited, please email [EMAIL PROTECTED] ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ________________________________ ________________________________________________________________________ ____ This e-mail is intended for the use of the addressed recipient(s) only and may contain confidential and privileged information. If you have received this message in error, please delete the message and any attachments and copies immediately; and notify the sender by return e-mail. Any views expressed in this message or any attachments are those of the individual sender and do not necessarily represent the corporate opinion of the Catholic Education Office (CEO), Sydney. The CEO Privacy Policy is located at http://www.ceo.syd.catholic.edu.au ________________________________________________________________________ ____ ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
