Showing posts with label content types. Show all posts
Showing posts with label content types. Show all posts

ID and Calculated Column

If you find that you need to use the ID column to generate incremental invoice numbers and using a formal like =[ID]+1000

There is a problem check out Daisy Anands answer just here

http://community.bamboosolutions.com/blogs/bambooteamblog/archive/2008/04/24/calculated-fields-don-t-leave-home-without-them.aspx

The nub of the problem is that ID's aren't assigned till after the item is created, with the upshot that you'll need a tiny bit of workflow to put the invoice number in retrospectively.

Calculated columns, formulas etc

Sharepoint calculated column Common formulas list http://office.microsoft.com/en-us/sharepointtechnology/HA011609471033.aspx

You've tried [Today] and [Me] here are some more functions http://office.microsoft.com/en-us/sharepointtechnology/CH100650061033.aspx

Introduction to the subject http://office.microsoft.com/en-us/sharepointtechnology/HA101215881033.aspx

http://www.sharepointblogs.com/mkruger/archive/2007/06/26/howto-using-sharepoint-calculated-columns-to-display-a-list-item-as-quot-x-quot-days-old.aspx

C

Need to delete a content type but get the error "content in use" well you need to find where it is in use ... try this http://blog.tylerholmes.com/2008/02/deleting-content-types-in-sharepoint.html

CAML query builder so useful http://www.u2u.info/SharePoint/U2U%20Community%20Tools/Forms/AllItems.aspx developed by Patrick Tisseghem