Stump the Panel: Recent Posts

Stump the Panel: Recent Posts http://www.endusersharepoint.com/STP/ SharePoint QA en Wed, 02 Dec 2009 00:39:10 +0000 Toni on "Add a new column to a custom list form" http://www.endusersharepoint.com/STP/topic/add-a-new-column-to-a-custom-list-form#post-11681 Tue, 01 Dec 2009 19:57:08 +0000 Toni 11681@http://www.endusersharepoint.com/STP/ Yes you can. First you need to add your new column to the <datafields> list. This list is in the "@InternalColumnName, Display Name;" format. You must use proper values here. Next you need to add a new field to edit data. Simply copy entire section starting with <tr>. Change reference to existing field and add the @InteralColumnName as above. If you have good Data View Web Part skills this is going to be easy for you. Post here if you need more details. Toni on "Integrating/View Squish in SharePoint" http://www.endusersharepoint.com/STP/topic/integratingview-squish-in-sharepoint#post-11680 Tue, 01 Dec 2009 19:47:37 +0000 Toni 11680@http://www.endusersharepoint.com/STP/ Sure can, there are two options. Hookup to your bug tracking DB with Data View Web Part or use Business Data Catalog <a href="http://msdn.microsoft.com/en-us/library/ms563661.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms563661.aspx</a> klink on "Add a new column to a custom list form" http://www.endusersharepoint.com/STP/topic/add-a-new-column-to-a-custom-list-form#post-11679 Tue, 01 Dec 2009 18:39:01 +0000 klink 11679@http://www.endusersharepoint.com/STP/ To start out, I am just getting my feet wet with SharePoint Designer. So far, so good! I have gotten a lot of help out on the web! I have managed to create a custom newform with hardly any trouble! =) However, my boss asked if I would be able to add columns later to the form. So I tried, and I CANNOT FIGURE IT OUT! CRIPE! I have searched, with no luck. Can you PLEASE help me? I can't believe it is hard... THANKS! I don't know if I picked the right section for this question... =( bhorner on "User can't edit items in a list" http://www.endusersharepoint.com/STP/topic/user-cant-edit-items-in-a-list#post-11677 Tue, 01 Dec 2009 17:24:27 +0000 bhorner 11677@http://www.endusersharepoint.com/STP/ What does the workflow do? Also, did you check the Settings->List Settings->Advanced Settings->Edit Access to make sure it is set on "All Items" and not "Only your own" or "None"? bhorner on "SharePoint Announcements" http://www.endusersharepoint.com/STP/topic/sharepoint-announcements#post-11675 Tue, 01 Dec 2009 17:17:20 +0000 bhorner 11675@http://www.endusersharepoint.com/STP/ One way to accomplish this: Use SharePoint's OOTB Announcements and a SharePoint Designer Workflow. Step 1: Create an Announcements list and optimize its settings for you. How: * Go to the site where this list will be held; go to the top-right and click "Site Actions" and then click "Create" (If you have a large dropdown when you click this, click "View All Site Content" and then click the "Create" link toward the top left of the new page that appears). * Give the list a name and click "OK" * You should now be viewing your announcements page, click "Settings" on the menu bar towards the top and then click "List Settings" * On the left, you should see a section called "Versioning Settings", click that and then click the "Yes" bubble under the question "Require content approval for submitted items?" and click "OK" * You should be back on the settings page and there is a section called "Columns" that has all of the SharePoint columns underneath; below that, click "Create Column" * Type the word "Publish Date" in the Column Name and choose the bubble for "Date and Time" * Scroll down and under the "Require that this column contains information" choose the "yes" bubble * Toward the bottom you CAN set the default day to Today's Date...up to you if you would like this; either way, click "OK" * Back on the settings page, look below the "Create Column" link to find and click "Column Ordering" * Rearrange these fields as you see fit (probably with Published before Expired) and click "OK" * Click the "title" column and change the maximum number of characters to something smaller than 255, I'd say something like 75 should be plenty, and click "OK" * Below the Column Ordering should be "Indexed Columns", click that * Click the checkbox next to Expires and next to Published Date and click "OK" * You are now done with step 1 Step 2: Setup a SharePoint Designer workflow I've run out of time, can someone else help define the workflow? If not, I'll return to this tomorrow and put in step 2. dootndo2 on "MOSS 2007 Problems" http://www.endusersharepoint.com/STP/topic/moss-2007-problems#post-11674 Tue, 01 Dec 2009 15:09:46 +0000 dootndo2 11674@http://www.endusersharepoint.com/STP/ For Issue 2, Excel will always prompt for authentication. If you have to provide credentials to access the site, Excel will prompt as well. If you are not able to save the file back to the site by default, make sure that the file is Published to the Document Library and not just uploaded there. For Issue 3, this is a permissions problem on resources on the page that the user is viewing. I would recommend trying to hit cancel on all of the prompts except for the first one. If it is an image or style sheet, it will not be rendered but the page will show. Also, determine if this occurs when the Site Collection Administrator accesses the same page. Unless the resource is in a different Site Collection with different permissions, you should only be prompted once. dootndo2 dootndo2 on "Display Current User" http://www.endusersharepoint.com/STP/topic/display-current-user#post-11673 Tue, 01 Dec 2009 14:59:44 +0000 dootndo2 11673@http://www.endusersharepoint.com/STP/ If the user is logged into SharePoint, there is always (unless you customize it out) a Welcome, John Doe in the upper right corner of the screen. You could use some Javascript to access that text: <script> var name = document.getElementById('zz8_Menu'); alert(name.innerHTML); </script> You could parse off the "Welcome, " and the image reference by using substrings. Add this code to a CEWP or just use it in your output. There is also a variable on the page that is _spUserId that is accessible. You would have to write some routine to access this information. Otherwise, doing it server side would be very easy to do. dootndo2 eric on "Showing descriptions of list columns" http://www.endusersharepoint.com/STP/topic/showing-descriptions-of-list-columns#post-11672 Tue, 01 Dec 2009 14:49:50 +0000 eric 11672@http://www.endusersharepoint.com/STP/ The descriptions don't appear on views, only on the forms like NewForm.aspx, EditForm.aspx and DispForm.aspx for the list. eric on "Hide Default Document Library Template" http://www.endusersharepoint.com/STP/topic/hide-default-document-library-template#post-11671 Tue, 01 Dec 2009 14:44:06 +0000 eric 11671@http://www.endusersharepoint.com/STP/ I can confirm that is the same feature id in our environment as well, 00bfea71-e717-4e80-aa17-d0c71b360101. eric on "Create a CV from My Site content?" http://www.endusersharepoint.com/STP/topic/create-a-cv-from-my-site-content#post-11670 Tue, 01 Dec 2009 14:40:46 +0000 eric 11670@http://www.endusersharepoint.com/STP/ You'd have to look into modifying the Person.aspx page so you can drop in some IDs on content you'd like to target. Then using jQuery or something like that, have a button that generates a document by aggregating all the information you gave IDs to. Or by creating a web app that can query the user information profiles and grab the specific information you'd like to gather. dootndo2 on "Hide Default Document Library Template" http://www.endusersharepoint.com/STP/topic/hide-default-document-library-template#post-11669 Tue, 01 Dec 2009 14:38:49 +0000 dootndo2 11669@http://www.endusersharepoint.com/STP/ Yes this is possible. Each item on the Create Page has a feature GUID associated with it. If you Right Click on the link, you will notice that there is a FeatureID=GUID. Features installed in SharePoint can be active but hidden. In order to remove the Document Library link use: stsadm -o deactivatefeature -id 00bfea71-e717-4e80-aa17-d0c71b360101 -url THEURLOFTHESITEYOUWANTTOREMOVETHEBUTTONLINKON -force No carriage returns. Verify the Feature GUID before you run this to ensure that it is correct. I checked mine on 2 servers and the provided one was for Document Library. dootndo2 eric on "Accidental column deletion- options?" http://www.endusersharepoint.com/STP/topic/accidental-column-deletion-options#post-11668 Tue, 01 Dec 2009 14:33:11 +0000 eric 11668@http://www.endusersharepoint.com/STP/ If the column was created as a site column, it could quickly be readded to the list should it get deleted, since he's deleteing it at the list level and not the site level. Other than that, it would have to be recovered from backup or recreated if it was a short list of data (sometimes this is faster than recovery). sympmarc on "Error trying to display connected survey webpart" http://www.endusersharepoint.com/STP/topic/error-trying-to-display-connected-survey-webpart#post-11667 Tue, 01 Dec 2009 14:22:53 +0000 sympmarc 11667@http://www.endusersharepoint.com/STP/ Here's hoping mny approach will work. If you want to follow along: <a href="http://spservices.codeplex.com/Thread/View.aspx?ThreadId=76735" rel="nofollow">http://spservices.codeplex.com/Thread/View.aspx?ThreadId=76735</a> M. dootndo2 on "Info Path" http://www.endusersharepoint.com/STP/topic/info-path#post-11666 Tue, 01 Dec 2009 14:21:32 +0000 dootndo2 11666@http://www.endusersharepoint.com/STP/ You can use the API and an EventHandler to move the .xml file from the submitted library to another library. When you upload your InfoPath form, create it as a content type that is used across your top level site collection. Then add that form to both libraries. When a new form is created/submitted, the event handler can copy the listitem from one list to the other. This requires coding however. Not sure about the email stuff. dootndo2 bhorner on "Only one tier is working in a multi-tier approval workflow created with Workflow" http://www.endusersharepoint.com/STP/topic/only-one-tier-is-working-in-a-multi-tier-approval-workflow-created-with-workflow#post-11664 Tue, 01 Dec 2009 14:08:30 +0000 bhorner 11664@http://www.endusersharepoint.com/STP/ Is there a pause that is occuring after you attempt to collect the information in the "Collect BAS Team Lead Approval" action? I'm wondering if it is setting either a default value or incorrect data or you have your lookup incorrect on the Requisition Request Tasks: BAS Team Lead Approval/Comments when setting those variables. Btw, why not set these variables in InfoPath as invisible data sources instead of creating the variables in the workflow? Since this information will probably need to be documented anyway, it might do well to have them incorporated into the form itself (and can be set automatically using a data connection to a SharePoint List with this information). jbhoward on "Error trying to display connected survey webpart" http://www.endusersharepoint.com/STP/topic/error-trying-to-display-connected-survey-webpart#post-11663 Tue, 01 Dec 2009 14:06:39 +0000 jbhoward 11663@http://www.endusersharepoint.com/STP/ Thanks Tony. Thought of that, but the survey is HEAVILY branched and needs to be. Doing that as a list would be a nightmare. Blessings, JIm Bob eric on "Person Column - How to expose more Profile Properties in the 'show field:' list?" http://www.endusersharepoint.com/STP/topic/person-column-how-to-expose-more-profile-properties-in-the-show-field-list#post-11661 Tue, 01 Dec 2009 14:02:34 +0000 eric 11661@http://www.endusersharepoint.com/STP/ I want to say by mapping more AD fields to the user profiles in the SSP in Central Admin. I haven't tried this, but I would gather that this is where the information is coming from. It's a place to start at least. sharepointony on "Error trying to display connected survey webpart" http://www.endusersharepoint.com/STP/topic/error-trying-to-display-connected-survey-webpart#post-11660 Tue, 01 Dec 2009 14:01:31 +0000 sharepointony 11660@http://www.endusersharepoint.com/STP/ Sympmarc's option is more elegant, but in case you want another idea... Create your Survey as a list form (in SPD) rather than as a SharePoint "survey" - then you can initiate a workflow to move the survey data to the Injury Report. jbhoward on "Error trying to display connected survey webpart" http://www.endusersharepoint.com/STP/topic/error-trying-to-display-connected-survey-webpart#post-11659 Tue, 01 Dec 2009 13:59:25 +0000 jbhoward 11659@http://www.endusersharepoint.com/STP/ Thanks, Marc! Looking into it. Do I need to install something for this to work? Blessings, Jim Bob sympmarc on "Error trying to display connected survey webpart" http://www.endusersharepoint.com/STP/topic/error-trying-to-display-connected-survey-webpart#post-11658 Tue, 01 Dec 2009 13:46:15 +0000 sympmarc 11658@http://www.endusersharepoint.com/STP/ What about using SharePoint's Lists Web Service to write the ID of the survey into the BPE on completion? Since you're already using jQuery, you can just add the Web Service call to UpdateListItems. Check out my jQuery Library for SharePoint Web Services: <a href="http://spservices.codeplex.com." rel="nofollow">http://spservices.codeplex.com.</a> I'm available to help figure it out if you need help. Just post on the Codeplex Discussion. M. jbhoward on "Error trying to display connected survey webpart" http://www.endusersharepoint.com/STP/topic/error-trying-to-display-connected-survey-webpart#post-11657 Tue, 01 Dec 2009 13:03:35 +0000 jbhoward 11657@http://www.endusersharepoint.com/STP/ OK... So, here's my problem. Background I have an intake form for employee injury/illness reports. This is set up as a list (Injury Report). If the injury type is Bloodborne Pathogen exposure (BPE) [yes, we're in healthcare], a workflow triggers and asks the user to complete a survey specific to the BPE. Using jQuery, the link provided in email feeds the Injury Report ID into a lookup field on the BPE survey. The survey is branched extensively but works great. Goal I need the survey results tied to the report. Problem Surveys don't trigger workflows, so I can't copy the BPE answers into the Injury Report Have tried multiple ways to add a BPE webpart to the Injury Report DispForm, but can't seem to get the webpart connections to take. Tried a DVWP, tried Custom List, et. al. None display any survey data on the DispForm in the browser (though they show up in SPD). Connection settings I've tried: Source Web Part: Work-related Injury or Illness Report Source action: Send Row of Data To Target Web Part: Bloodborne Pathogen Survey Target action: Get Filter Values From Match column to input: Columns in Work-related Injury or Illness Report = ID Inputs to Bloodborne Pathogen Survey = Incident Report (the jQuery-filled Lookup column in the Survey) Question Can anyone (a) see something I'm doing wrong, or (b) offer another suggestion for showing BPE Survey data on the Incident Report DispForm? Thanks! Blessings, Jim Bob Simple on "Easy Tabs - Rounded corners" http://www.endusersharepoint.com/STP/topic/easy-tabs-rounded-corners#post-11656 Tue, 01 Dec 2009 11:35:05 +0000 Simple 11656@http://www.endusersharepoint.com/STP/ Any luck on whats going on with IE 7 and the JS errors Christophe? Here is a screen shot of the error. I'd love to use this system if I can just work out the JS errors, I don't mind the corners so much. <a href="http://lh6.ggpht.com/_VYwCCpUX8PY/SxU3kl6GeII/AAAAAAAANpk/VRUhojo5OwA/s800/taberror.JPG" rel="nofollow">http://lh6.ggpht.com/_VYwCCpUX8PY/SxU3kl6GeII/AAAAAAAANpk/VRUhojo5OwA/s800/taberror.JPG</a> aweise on "Integrating/View Squish in SharePoint" http://www.endusersharepoint.com/STP/topic/integratingview-squish-in-sharepoint#post-11655 Mon, 30 Nov 2009 19:17:46 +0000 aweise 11655@http://www.endusersharepoint.com/STP/ Is there a way I can integrate or at least view the bug tracker Squish from SharePoint Services? latimoreb on "Hide Default Document Library Template" http://www.endusersharepoint.com/STP/topic/hide-default-document-library-template#post-11654 Mon, 30 Nov 2009 18:59:25 +0000 latimoreb 11654@http://www.endusersharepoint.com/STP/ Is there a way to hide the default document library option on the create page? We have a custom document library template that we want users to use and not have the ability to create the out the box document library will266 on "Add total count of items in view to Item Limit value" http://www.endusersharepoint.com/STP/topic/add-total-count-of-items-in-view-to-item-limit-value#post-11652 Mon, 30 Nov 2009 17:35:24 +0000 will266 11652@http://www.endusersharepoint.com/STP/ Thanks so much for the prompt reply - I will take a look! MattSnow on "Person Column - How to expose more Profile Properties in the 'show field:' list?" http://www.endusersharepoint.com/STP/topic/person-column-how-to-expose-more-profile-properties-in-the-show-field-list#post-11651 Mon, 30 Nov 2009 16:41:53 +0000 MattSnow 11651@http://www.endusersharepoint.com/STP/ I was wondering how I make more Profile Properties appear in the 'show field:' list? In the 'Create New Column' settings, you choose what info should be displayed in the column. As of now, I see: -------- Name Account Work e-mail SIP Address Department Title First name Last name Work phone Office User name ID Name (with presence) Name (with picture) Name (with picture and details) Content Type -------- How do I go make more Profile Properties appear in the 'show field:' list? Thanks! Brian on "Display Current User" http://www.endusersharepoint.com/STP/topic/display-current-user#post-11650 Mon, 30 Nov 2009 15:34:28 +0000 Brian 11650@http://www.endusersharepoint.com/STP/ I would like to display the name of the current user in the main body of a page .. ...using perhaps teh CEWP, do you know if and how I can do this? Is there a HTML code I can use? Datagirl on "Info Path" http://www.endusersharepoint.com/STP/topic/info-path#post-11649 Mon, 30 Nov 2009 13:00:06 +0000 Datagirl 11649@http://www.endusersharepoint.com/STP/ I see that submitting forms from one site collection to another is not possible :P Is this also true of emailing a completed form from a library on one site collection to a library resideing on a different site collection. Or, does anyone have a solution to this "unsupported feature" Datagirl katscasa on "Accidental column deletion- options?" http://www.endusersharepoint.com/STP/topic/accidental-column-deletion-options#post-11648 Mon, 30 Nov 2009 11:59:55 +0000 katscasa 11648@http://www.endusersharepoint.com/STP/ I have a site user (administrator) who accidentally deleted a column in his library. He was trying to modifying choices in a choice column, and accidentally clicked "delete" instead of the "ok" button. Problem is, no warning message or anything to even give him pause. It just went ahead and deleted it. Which, by the way, also messes up all the views he had that were based on that column. :( Anyone know of options for restoring deleted columns? Unlike deleted items and lists, these never go into the recycle bin. I didn't know of any option other than to use our backup/restore software (DocAve) to restore the library as it was the previous day (which, of course, removes any/all changes he made that day). Anyone know of anything else that can be done in such a situation? Thanks! MartinNr5 on "Create a CV from My Site content?" http://www.endusersharepoint.com/STP/topic/create-a-cv-from-my-site-content#post-11647 Mon, 30 Nov 2009 10:36:20 +0000 MartinNr5 11647@http://www.endusersharepoint.com/STP/ Hi. We have a sales organization that needs access to our consultants CV's on a regular basis. The problem is that these CV's are almost always out of date. What would be the best way to let a sales representative create a CV on the fly based on the information found in a users My Site? Thanks! Brucacuda on "Only one tier is working in a multi-tier approval workflow created with Workflow" http://www.endusersharepoint.com/STP/topic/only-one-tier-is-working-in-a-multi-tier-approval-workflow-created-with-workflow#post-11646 Mon, 30 Nov 2009 10:22:15 +0000 Brucacuda 11646@http://www.endusersharepoint.com/STP/ When the requestor fills out the InfoPath form, they choose their team - that is the single data source in the form. When the form is submitted to the library, the workflow kicks off using one of multiple conditions. Here is the actual 1st Step: Condition: If Team equals XXX Action: Log XXX to the workflow list then store <a href="xxx"> in Variable:Link then Collect BAS Team Lead Approval from XXX (Output to Variable: BASTEamLeadApprovalID) then Set Variable:BASTeamLeadReqRequestApproval to Requisition Request Tasks: BAS Team Lead Approval then Set Variable:BASTeamLeadReqRequestComments to Requisition Request Tasks: BAS Team Lead Comments Then in step 2 is the manager approval, and then step 3 the admin.</a> hamzah on "Showing descriptions of list columns" http://www.endusersharepoint.com/STP/topic/showing-descriptions-of-list-columns#post-11645 Mon, 30 Nov 2009 07:15:02 +0000 hamzah 11645@http://www.endusersharepoint.com/STP/ When creating a custom list, I create the columns and enter description text but it does not show in any of the default views. Is there a way to make this appear OOTB? Toni on "Get full username using CEWP" http://www.endusersharepoint.com/STP/topic/get-full-username-using-cewp#post-11644 Sun, 29 Nov 2009 09:36:20 +0000 Toni 11644@http://www.endusersharepoint.com/STP/ AFAIK you can display only display name (full name) with DVWP, like this: <xsl:value-of select="$UserID"/> There are some steps you need to take before that, as described here: <a href="http://bit.ly/74s6cU" rel="nofollow">http://bit.ly/74s6cU</a> In case you can deploy custom code you can create your own custom web part that displays it via SPWeb.CurrentUser.LoginName Toni on "Reinheriting library permissions from parent" http://www.endusersharepoint.com/STP/topic/reinheriting-library-permissions-from-parent#post-11643 Sun, 29 Nov 2009 08:50:31 +0000 Toni 11643@http://www.endusersharepoint.com/STP/ Login as Site Collection Administrator and inherit permission from the parent site. <a href="http://office.microsoft.com/en-us/sharepointserver/HA100215641033.aspx#11" rel="nofollow">http://office.microsoft.com/en-us/sharepointserver/HA100215641033.aspx#11</a> Toni on "Force NEW button on toolbar to drop down list" http://www.endusersharepoint.com/STP/topic/force-new-button-on-toolbar-to-drop-down-list#post-11642 Sun, 29 Nov 2009 08:48:36 +0000 Toni 11642@http://www.endusersharepoint.com/STP/ You probably can override button behavior with JQuery, but take a look at this web part as it might help you solve your problem. <a href="http://www.sharepointusecases.com/index.php/2009/06/a-great-web-part-for-sharepoint-end-users/" rel="nofollow">http://www.sharepointusecases.com/index.php/2009/06/a-great-web-part-for-sharepoint-end-users/</a>