Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Mikael Söderström — Mon, 31 Mar 2008 09:14:09 GMT

Hi James,

Thanks, that´s exactly what I was asking for. :-)

Regards,

Mikael Söderström

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Nikoli Plantov — Thu, 15 May 2008 14:59:17 GMT

Brilliant. Thanks for the information.

Nikoli Plantov

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Sergei Golubev — Mon, 09 Jun 2008 18:58:39 GMT

Thanks, James! Your article was very useful for the task I’m doing now.

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Debbie Robinson — Thu, 12 Jun 2008 21:13:46 GMT

Is there a way to make a column appear in a list with only 15 characters showing in the column and the rest wrapped like you can in an excel spreadsheet

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

James Kemp — Wed, 18 Jun 2008 19:40:26 GMT

Hi Debbie,

I don't think this is possible out of the box. One would have to do some custom coding instead. I would also check out www.codeplex.com and see if you can find anything.

Kind Regards,

James

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Brian — Fri, 22 Aug 2008 23:50:40 GMT

Hi,

I have Choice Column that is a drop down menu. I want to display a text field when an item in a list has been selected.

Do you know how I go about this?

Thank you

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

James Kemp — Tue, 26 Aug 2008 10:54:25 GMT

Hi Brian,

I don't think this would be possible out-of-the-box, you would need to write some custom code. The alternative would be to:

- Have the text field always available when users create a list entry

- Create two different views on the list to show/hide the extra field depending on whether or not choice X was chosen. Not ideal perhaps....

Thanks,

James

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Jan Munkholm — Tue, 16 Sep 2008 17:36:14 GMT

Hi James

Can you calculate or sort the content of a column based on which content that the user has chosen in another previous column?

Br.

Jan

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

James Kemp — Fri, 19 Sep 2008 17:33:05 GMT

Hi Jan,

The only way I can think of doing this would be to:

- Create the list/library

- Create a column (i.e. Column X) which will hold the choices available to users (e.g. Choice 1, 2 and 3). Make Column X hold values of type 'hyperlink'

- Create three view on the list/library for each of the choices available. For each view, you can then define whatever columns, calculations and sorting you want

- Make the hyperlink in Column X correspond to the different views of the list/library.

This should mean that when a user clicks a choice in Column X, it just refreshes the page and shows a different view of the same list/library. To them, it will appear as if the list/library has changed based on their actions.

I hope this helps?

James

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Mike — Mon, 06 Oct 2008 18:38:48 GMT

James

Is it possible to have text content dependent on a previous selection?

For example - have two drop down columns on a library, 'Vendor' and 'Product', the selection of a Vendor changes the visible choices in the Product column; for example choosing a Vendor 'Microsoft' would only list Microsoft products in the Product drop down.

Thanks very much

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

James Kemp — Mon, 13 Oct 2008 13:57:29 GMT

Hi Mike,

This is slightly different to the scenario that Jan posted and unfortunatley I'm not sure this is possible OOTB. Instead, you would probably need to create a custom field. MSDN guidance on this is available at http://msdn.microsoft.com/en-us/library/ms446361.aspx

Thanks,

James

re: more suggestions for [Me]...?

Andy G — Thu, 06 Nov 2008 18:38:57 GMT

Hi James,

Great post! However, from this I'm assuming that what I want to achieve isn't supported. Or at least, isn't obvious.

I want to get the currently logged in users name into an existing default calendar 'Title' column.

Since this default column can only be either text or a calculation, options are limited.

The formula [Created By] doesn't exist in the above reference table, neither does [PreferredName](it was an idea from the UserProfile Service).

Trying to get a duplicate of a 'People or Group' column by using [column_name] also fails.

All of the above return the error: 'One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.'

Using [Me] which is the closest option returns 'DOMAIN\username' which is not particularly pretty.

How can I get this to format like 'firstname lastname' within the calculation?

If you have any ideas I'd be pleased to hear them!

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Nate — Wed, 26 Nov 2008 19:12:07 GMT

How can I use functions in View Filters? I can use all these in a calculated column. However, I want to have my view display items in a list based on a computed "Week" value based on a formula:

FLOOR((([Julian Date]+1)/7),1). I want to compute the Julian date from [Today] in my filter then run my computation on it, yielding my actual week. This way, I see only items for the current week (forward and back), and none for the following or prior weeks.

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

James Kemp — Fri, 28 Nov 2008 19:41:42 GMT

Hi Andy,

I had a small experiment and came to the same conclusions as you have. The only possible away around this that I can think of is to modify the list/library so that you can manage the content types on the list/library. Then, on your custom content type you should be able to delete/modify the Title column to be something else (e.g. a calculated field). You should be able to do the formulas you desire on this "default/first" field.

Good luck!

James

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

James Kemp — Fri, 28 Nov 2008 19:57:11 GMT

Hi Nate,

I'm not 100% sure what you are after. Do any of the following posts help:

http://blogs.technet.com/collaboration/archive/2008/03/19/how-to-see-items-added-to-a-sharepoint-list-library-that-meet-a-custom-date-value.aspx

http://blogs.technet.com/collaboration/archive/2008/02/22/how-to-see-items-added-to-a-sharepoint-list-library-in-the-last-x-days.aspx

Thanks,

James

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Esther Hunter — Thu, 22 Jan 2009 22:05:50 GMT

Thanks so much for this post. Very helpful. One question is whether or not this calculation will constantly update to reflect the current date. I think that current date (TODAY) is stagnant no?

thanks,

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

James Kemp — Wed, 11 Feb 2009 13:47:43 GMT

Hi Esther,

The calculations should be dynamic in most/all cases. I would have to test the TODAY function to be sure for the example you have given. Please share your results if you have tested this already.

James :)

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

Joe Lichty — Wed, 11 Feb 2009 19:43:17 GMT

Hi James--

This helped quite a bit, but I'm having some challenges:

I need to constantly calculate the time to expiry for some domains based on today's date and the expiry date.

When I try your solution, the calculation is correct but the date in the record does not reflect the current date, only when I altered that record.

If I try to use TODAY in a calculated column, I get a note saying volatile functions such as ME and TODAY cannot be used.

Any ideas?

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

James Kemp — Thu, 12 Feb 2009 12:38:05 GMT

Hi Joe,

It sounds like:

A) If TODAY is used in a column without a calculation, it won't be updated dynamically

B) If TODAY is used in a calculated column, it isn't allowed.

So, the only two options left I think are:

(C) to use the TODAY function in a view, and see if that achieves your goals - see http://blogs.technet.com/collaboration/archive/2008/03/19/how-to-see-items-added-to-a-sharepoint-list-library-that-meet-a-custom-date-value.aspx, or

(D) to create a custom field and use the TODAY value within it. MSDN guidance on this is available at http://msdn.microsoft.com/en-us/library/ms446361.aspx

Thanks,

James

re: Functions for use in a MOSS 2007 column ([Today] [Me] [Other??])

LoriH — Fri, 20 Feb 2009 04:49:04 GMT

Thanks for the great post!! I've been hunting for this information for 2 weeks - now I came across it looking for something else. :-)