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
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
I'm hiding the column from the form view as I want to give it a unique
name, i.e.:
=[Employee Name]& DATE(YEAR(Today),MONTH(Today),DAY(Today))
Unfortunately [Employee name] is a User lookup field and so can't be
used in this way, I don't think.
So, at present I have:
="Leave request
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 Disp
Do you need to convert the date to a string?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Noone
Sent: Thursday, 17 July 2008 10:58 AM
To: listserver@ozMOSS.com
Subject: [OzMOSS] Create timestamp for column
I'm trying to give a hidden Title column a timestamp "/mm/dd hh:
I'm trying to give a hidden Title column a timestamp "/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 the
Just a side question when creating custom content types for a list. Is
there any way to dispose of the inherited columns apart from just hiding
them? I refer specifically to the Item content type and the Title
column, where I would like change the column's type or just remove it
completely.
Reg
Brilliant, thanks mate.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Witherdin, Nigel
Sent: Wednesday, 16 July 2008 5:20 PM
To: listserver@ozMOSS.com
Subject: RE: [OzMOSS] Content types for 'New' menu
The recommended way is to use a feature to apply the content types to
ex
Hi all!
I need to find a way to be able to add dynamic columns to a document
library. For example, if the user selects a particular value in Column X,
then Column Y displays; if they select a different value in Column X, then
Column Z will appear.
So far I have decided to create a Content Type c
Hi Paul,
Create a column called Days Absent and select the field type "Calculated
(calculation based on other columns)" and select a return type of
number.
Also reverse your formula e.g. =DATEDIF([Start Date],[End Date],"d")
cheers
Clayton James
From: [EMAIL PROTECTED] [mailto:[EMAIL
Hi Paul,
Clayton James from Data Cogs (http://sharepoint.datacogs.com/default.aspx)
did some great research and wrote a very useful article on his blog in Apr
2007:
http://claytonj.wordpress.com/2007/04/23/moss-2007-setup-accounts/
maybe this helps you getting around these kind of issue
The recommended way is to use a feature to apply the content types to
existing sites. Martin Kearn has an example feature that does just what
you want (using the Dublin Core content type) here:
http://blogs.msdn.com/martinkearn/archive/2007/11/14/code-callout-featur
es-how-to-make-automated-modifi
12 matches
Mail list logo