whallify's blog - All Comments

re: Inventory Tracking in a Sharepoint List?

itoleck — Fri, 25 Jul 2008 06:16:39 GMT

Not advertising but, look for a SharePoint feature like this in the future from www.swarmsoft.net.

Posted on SharePoint Blogs

re: Wish I could display "totals" for a calculated field in a view...

Roy — Mon, 09 Jun 2008 15:37:26 GMT

Thanks Wolfgeek.

I've tried your solution but the workflow gets stuck on 'started'.

I'm running it on a document library that enforces check-out (can't change this).

After waiting a long time I check in the document and the workflow changes to status 'stopped' and the field is not populated.

Any idea how I get around this?

Posted on SharePoint Blogs

re: Various Sharepoint 2003 and Exchange integration points

Eddie — Wed, 21 May 2008 02:22:44 GMT

We recently installed Sharepoint on a development server and it began to affect the production users. In particular, one error the user had was when he/she tried to send an attachment using Outlook Email, this message popped up "You must select a SharePoint site location for a new shared workspace to be created". Would you know why this error popped up? Further, is it possible to set up Sharepoint on a development server without affecting production systems such as Outlook?

Posted on SharePoint Blogs

re: Submit button at top AND bottom of survey? How?

*** Creams — Tue, 29 Apr 2008 00:18:52 GMT

We Review the Top *** Enhancing Pills & tell you what really works.

Posted on SharePoint Blogs

re: Wish I could display "totals" for a calculated field in a view...

Wolfgeek — Thu, 13 Mar 2008 14:05:40 GMT

Here is a work-around to do totals (and subtotals when using Group By options in a standard list view with calculated fields.

Let's say we have a field called CALCULATED HOURS that is calculated as Round((([END TIME] - [START TIME])*24),1) (this gives the decimal notation of the total time rounded to the closest 10th).

Create a regular number field (not calculated) called HOURS.

Using Sharepoint Designer, create a workflow for your list that runs when list items are created and when list items are changed.

The workflow will have a single step. Leave the condition field blank.

In the action section, choose "Set field in the current item".

Click on the word "field" and choose HOURS.

Click on the word "value" and then click on "fx" to do a lookup.

Choose "current item" for the source.

Choose "CALCULATED HOURS" for the field.

Click Finish

Now whenever someone creates or modifies a list item the non-calculated field will automatically be updated with the data from the calculated field.

Now you can display the non-calculated field in your standard list views, total by it, etc.

Hope that saves people the time it took me to figure it out! ;-)

Posted on SharePoint Blogs

re: Inventory Tracking in a Sharepoint List?

Jim Patton — Wed, 06 Feb 2008 06:50:36 GMT

Add me to this list of people that are looking for the exact same functionality. Anyone?

Posted on SharePoint Blogs

re: WSS doc lib asking for column info (Web File Properties)?

Marshall — Wed, 05 Sep 2007 15:56:24 GMT

I was reading your site looking for info on SharePoint and have a question you may be able to help with. I have a Web File Properties window that pops up as part of saving a template document, but the Web File Properties window itself is to small to show the whole width of the selections. Since I have many computer illiterate people filling in this form it leads to problems because the idea of scrolling is foreign (at least scrolling sideways, scrolling down seems to be common). Is there any way to code the size (width) of this window.

Posted on SharePoint Blogs

re: Inventory Tracking in a Sharepoint List?

prashanth pagidimarry — Tue, 07 Aug 2007 10:37:19 GMT

I want to develop the IT Inventory same as given above can anybody suggest me how to proceed?

Posted on SharePoint Blogs

re: How to use a Sharepoint list for Word 2003 Mail Merge?

monicker — Thu, 05 Jul 2007 05:46:00 GMT

Monkey Merge - Automatically merge multiple Microsoft Word documents, Excel spreadsheets, Adobe PDF files and all plain text files such as CSV files.

more information:

www.qweas.com/.../monkey_merge.htm

Posted on SharePoint Blogs