http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Sat, 28 Feb 2009 12:04:03 +0000 http://www.endusersharepoint.com/STP/topic/calculated-columns-to-write-html#post-4718 Sat, 28 Feb 2009 02:37:11 +0000 Christophe 4718@http://www.endusersharepoint.com/STP/ <p>Calculated columns should not show up when you edit an item. Maybe you are talking about viewing it? </p> http://www.endusersharepoint.com/STP/topic/hideremove-the-title-column#post-4717 Fri, 27 Feb 2009 19:19:52 +0000 PatrikTX 4717@http://www.endusersharepoint.com/STP/ <p>AutoSponge,<br /> You lost me on this one : ) Can you detail your answer a bit more for those of us that are just getting in to SharePoint :) I looked around and did not see an option to build a custom list as a content type?</p> <p>Sorry, I hate being new at stuff :( </p> http://www.endusersharepoint.com/STP/topic/calculated-columns-to-write-html#post-4716 Fri, 27 Feb 2009 18:37:57 +0000 PatrikTX 4716@http://www.endusersharepoint.com/STP/ <p>I have been working on adding status and progress bars to some of my lists and have been able to thanks to the great information from End User SharePoint and Path to SharePoint.</p> <p>But I am seeing some side effects and wondering if there are work arounds for them?</p> <p>Adding the 2 columns to hold the colors and html I note those 2 columns show up when I edit a record and also they show up in the Alert emails.<br /> Any ideas how to hide those? </p> http://www.endusersharepoint.com/STP/topic/skip-weekends-on-recurrences#post-4715 Fri, 27 Feb 2009 17:15:51 +0000 RMesty 4715@http://www.endusersharepoint.com/STP/ <p>Oh, I understand what you are saying. Thanks for the tip...that's how we'll proceed. </p> http://www.endusersharepoint.com/STP/topic/read-only-in-datasheet-view-on-machine-with-office-03#post-4714 Fri, 27 Feb 2009 16:02:56 +0000 Captk 4714@http://www.endusersharepoint.com/STP/ <p>We had a similar issue ... make sure your Office 2003 is the professional version. The standard version won't allow you to use the Datasheet view. </p> http://www.endusersharepoint.com/STP/topic/filtering-workflow-status-column#post-4713 Fri, 27 Feb 2009 16:01:40 +0000 pyar 4713@http://www.endusersharepoint.com/STP/ <p>I believe that I cannot achieve thias I do not have office 2007. </p> http://www.endusersharepoint.com/STP/topic/filter-content-by-ip-address#post-4712 Fri, 27 Feb 2009 14:07:34 +0000 eric 4712@http://www.endusersharepoint.com/STP/ <p>This has been created and sent to Mark to review. He said he hopes to have it published next week so be on the look out. </p> http://www.endusersharepoint.com/STP/topic/skip-weekends-on-recurrences#post-4711 Fri, 27 Feb 2009 14:06:20 +0000 eric 4711@http://www.endusersharepoint.com/STP/ <p>You'll have to split this out into multiple calendar events based on a weekly schedule so that you can specify the workdays. Just setting it as repeadting every 4 days will do Saturday and Sunday.</p> <p>You'll have to sit down and determine a pattern on how it shakes out. We had a problem like this with scheduling on Outlook/Sharepoint calendars and had to create 2 different recurring schedules and assign people to start the schedules at different days so it worked out. </p> http://www.endusersharepoint.com/STP/topic/filtering-workflow-status-column#post-4710 Fri, 27 Feb 2009 12:49:31 +0000 pyar 4710@http://www.endusersharepoint.com/STP/ <p>@Autosponge </p> <p>No matter what I try I cannot get the data into an excel spreadsheet. Columns are selected to show on default view and when I export to spreadsheet they do not show. Just workflow status columns. </p> http://www.endusersharepoint.com/STP/topic/sign-in-as-a-different-user#post-4709 Fri, 27 Feb 2009 12:29:20 +0000 erugalatha 4709@http://www.endusersharepoint.com/STP/ <p>In that case you might need to remove both profiles from the machine. These are usually in the Documents and Settings folder if this is a Windows XP machine.</p> <p>Make sure you save any documents etc. from the Profile before removing it if you need them.</p> <p>If I need to sign into SharePoint as myself on someone elses machine I never use the "Sign in as different user" within the SharePoint dropdown. I always Right-Click on Internet Explorer and choose Run As... and type in the username and password that I want to sign in as. </p> http://www.endusersharepoint.com/STP/topic/sign-in-as-a-different-user#post-4708 Fri, 27 Feb 2009 11:46:47 +0000 mpjtaylor 4708@http://www.endusersharepoint.com/STP/ <p>This could also be tied to roaming profiles I believe at the time I signed in on a laptop that neither of us actually normally use it was in a meeting meaning that she may have signed off the machine while I was logged into SharePoint therefore saving her profile back to the server,.</p> <p>Not sure that sheds any light on anything mind!</p> <p>Marcus </p> http://www.endusersharepoint.com/STP/topic/sign-in-as-a-different-user#post-4707 Fri, 27 Feb 2009 11:38:13 +0000 mpjtaylor 4707@http://www.endusersharepoint.com/STP/ <p>Hi thanks for the reply, As the site was in the Intranet Zone I cannot change the User Authentication as its greyed out. However I did try moving it to trusted and trying differnt User Authentications. Nothing has fixed it still the same.</p> <p>A real problem as I have Administrator permissions to every site collection and she should have very few permissions to only some sites!!</p> <p>any other ideas :(</p> <p>Thanks</p> <p>Marcus </p> http://www.endusersharepoint.com/STP/topic/uploading-files-and-linking-them-to-items-in-other-lists#post-4706 Fri, 27 Feb 2009 11:13:32 +0000 jregist 4706@http://www.endusersharepoint.com/STP/ <p>However, does this work if the secondary list is a document library and the NewForm is actually an Upload form? I understand how to link two lists -- and that is extremely useful -- however, I need to do the same thing when linking from a list to a library. </p> http://www.endusersharepoint.com/STP/topic/show-filter-choices#post-4705 Fri, 27 Feb 2009 11:09:15 +0000 jaxkookie 4705@http://www.endusersharepoint.com/STP/ <p>thanks for your time. </p> http://www.endusersharepoint.com/STP/topic/user-loses-permissions-frequently#post-4704 Fri, 27 Feb 2009 11:06:23 +0000 stump 4704@http://www.endusersharepoint.com/STP/ <p>We have a user who has permissions to a site but they somehow keep losing that permission with no user action. What would be the case? We do a daily AD import into SharePoint but I dont know if that is causing it.. Any ideas?</p> <p>Stump </p> http://www.endusersharepoint.com/STP/topic/notify-on-task-due-not-on-task-assignment#post-4703 Fri, 27 Feb 2009 10:57:30 +0000 stump 4703@http://www.endusersharepoint.com/STP/ <p>Thank you Laura. I tried out the IM policy setting and I think it will meet their need. I dont have the "luxury" of using SP so that option is out of the picture. </p> <p>Stump </p> http://www.endusersharepoint.com/STP/topic/skip-weekends-on-recurrences#post-4702 Fri, 27 Feb 2009 10:42:19 +0000 RMesty 4702@http://www.endusersharepoint.com/STP/ <p>Certain tasks are rotated throughout the dept every 4th day. Wishing to show who has a particular assignment for the day on the master calendar, we set the recurrence for every 4th day. The parameters of the work week were changed to Monday through Friday, starting with Monday. But the recurrence still shows up on weekends.</p> <p>What do I need to do to have the calendar bypass Saturdays and Sundays (and holidays, if possible)? </p> http://www.endusersharepoint.com/STP/topic/not-able-to-save-document-in-the-library#post-4701 Fri, 27 Feb 2009 10:18:25 +0000 brinda 4701@http://www.endusersharepoint.com/STP/ <p>this problem is with all the documents on the portal. I tried both 2007 document and 2003 document and get the same Microsoft office window which says "Unable to connect to the Web Server" </p> http://www.endusersharepoint.com/STP/topic/site-column-default-value-does-not-appear-in-word2007-docinfpanel#post-4700 Fri, 27 Feb 2009 10:08:48 +0000 Kristof 4700@http://www.endusersharepoint.com/STP/ <p>I see, but I want to go one step further:<br /> The content type structure is the same in all document libraries, but the default values should be different depending in what document library I'm in.<br /> A real-life example:<br /> I have a Content Type (with document template) that represents a Project Meeting Report.<br /> The Content Type is the same for all Projects.<br /> But depending on the project (=different site/document library), the ProjectCode and ProjectName (two site columns in my content type) should be there in the DIP when creating a new Meeting Report. And the values are different for each Project.</p> <p>I'm afraid that this is not supported by SharePoint?</p> <p>Kristof. </p> http://www.endusersharepoint.com/STP/topic/uploading-files-and-linking-them-to-items-in-other-lists#post-4699 Fri, 27 Feb 2009 10:08:20 +0000 AutoSponge 4699@http://www.endusersharepoint.com/STP/ <p>I did something similar with my Extending Tasks and Issues series. I typically create links on my DispForm that pass a querystring parameter to the secondary list NewForm then use the pre-populate script to pass the querystring parameter into the form field.</p> <p>1. Add JavaScript to make pre-population work on your secondary list's new form.<br /> 2. Build the link dynamically using JavaScript or a DVWP.<br /> 3. Place the new web part on the primary list's DispForm (since ID is already in the URL, you can just concatenate the value with a new parameter name, like myID, onto the secondary list's newform url). </p> http://www.endusersharepoint.com/STP/topic/not-able-to-save-document-in-the-library#post-4698 Fri, 27 Feb 2009 09:51:10 +0000 Erwin 4698@http://www.endusersharepoint.com/STP/ <p>Is your document an Office 2007 document or 2003? I had problems with saving Excel 2003 documents with Office 2007 into SharePoint. Converting the 2003 document to a 2007 document fixed it for me. </p> http://www.endusersharepoint.com/STP/topic/filter-content-by-ip-address#post-4697 Fri, 27 Feb 2009 09:45:49 +0000 N_Williams 4697@http://www.endusersharepoint.com/STP/ <p>Many thanks in advance Eric </p> http://www.endusersharepoint.com/STP/topic/not-able-to-save-document-in-the-library#post-4696 Fri, 27 Feb 2009 09:43:33 +0000 brinda 4696@http://www.endusersharepoint.com/STP/ <p>i have Office 2007 and authentication mechanism is Windows.. </p> http://www.endusersharepoint.com/STP/topic/change-ok-button-on-edit-form-to-check-in-button#post-4695 Fri, 27 Feb 2009 09:39:27 +0000 Erwin 4695@http://www.endusersharepoint.com/STP/ <p>We have document library with "Require documents to be checked out before they can be edited?" set to Yes. This means we need to check out a document when we want to update the properties of that document.</p> <p>On of our users asked if it wasn't possible to Check In the document from the EditForm.aspx page, instead of having to click the OK button to save (+ redirect to document library), and Check In the document.</p> <p>He basically wants to avoid the 2 steps and wants the Check In operation on the EditForm.aspx itself.</p> <p>Strange thing is that after you upload one document you get the same EditForm.aspx page but with a Check In button instead of an OK button.</p> <p>A bit of help would be appreciated.</p> <p>Regards,<br /> Erwin </p> http://www.endusersharepoint.com/STP/topic/not-able-to-save-document-in-the-library#post-4694 Fri, 27 Feb 2009 09:39:08 +0000 AutoSponge 4694@http://www.endusersharepoint.com/STP/ <p>Which version of Office do you have?<br /> Do you know your server's authentication mechanism? (Windows, Basic, Kerberos...) </p> http://www.endusersharepoint.com/STP/topic/not-able-to-save-document-in-the-library#post-4693 Fri, 27 Feb 2009 09:27:03 +0000 brinda 4693@http://www.endusersharepoint.com/STP/ <p>HI,<br /> I try to edit the document and make changes, and when i click on Save i get "Unable to coneect to te web server" error.<br /> pls help</p> <p>regards<br /> brinda </p> http://www.endusersharepoint.com/STP/topic/filter-content-by-ip-address#post-4692 Fri, 27 Feb 2009 09:10:49 +0000 eric 4692@http://www.endusersharepoint.com/STP/ <p>I'll get the information together. It doesn't involve changes to IIS, it just requires you to define a variable to get the Remote Address from the web server. You just need access to Sharepoint Designer and a little trial and error. </p> http://www.endusersharepoint.com/STP/topic/uploading-files-and-linking-them-to-items-in-other-lists#post-4691 Fri, 27 Feb 2009 08:47:42 +0000 jregist 4691@http://www.endusersharepoint.com/STP/ <p>I cannot seem to find a solution for this problem. I have a custom list called Projects. I have then created a nicely formatted page that shows each project along with related images and documents. These related files are in two other lists, each of to each which I have added a projectID field. Now I need an easy way for people to upload Images or Files to these other lists without having to type in the ID of the project that the image relates to. Is there an easy way to do this, perhaps by using some variation of the jquery sample presented by Paul Grenier? </p> http://www.endusersharepoint.com/STP/topic/display-count-number-better#post-4690 Fri, 27 Feb 2009 07:46:28 +0000 Toni 4690@http://www.endusersharepoint.com/STP/ <p>I am not 100% what you would like to change... but if you would to customize the look and feel of a list view, take a look at the following series of articles: <a href="http://office.microsoft.com/en-us/sharepointdesigner/CH100667641033.aspx" rel="nofollow">http://office.microsoft.com/en-us/sharepointdesigner/CH100667641033.aspx</a></p> <p>SharePoint Designer allows you to change the look and feel for each list view. </p> http://www.endusersharepoint.com/STP/topic/sign-in-as-a-different-user#post-4689 Fri, 27 Feb 2009 07:09:18 +0000 erugalatha 4689@http://www.endusersharepoint.com/STP/ <p>Just guessing here but is there a setting in IE7 options for changing automatic logon.</p> <p>Go to Tools | Options | Choose Security Tab | Select Intranet (or whichever zone you need to change) | Select Custom Level </p> <p>Now scroll down to the end in the list and find User Authentication Section -&gt; Logon and change to whatever suits you here (first note what it is set to now before changing). Try setting it to "Prompt for username and password" and this might reset whatever is holding your data on that machine. Later try changing it back to Automatic Logon with Current Username and Password. </p> http://www.endusersharepoint.com/STP/topic/roll-up-data-to-new-list#post-4688 Fri, 27 Feb 2009 06:15:23 +0000 erugalatha 4688@http://www.endusersharepoint.com/STP/ <p>SPD Workflows do not work with .stp templates as far as my investigations tell me.</p> <p>There's a manual option using the Content and Structure in Site Settings. Select the source list in the subsite and the destination list in the top level site and choose Copy from the Actions menu.</p> <p>Still looking for something like this that is automatic though if you find one post it here. </p> http://www.endusersharepoint.com/STP/topic/jscript-to-sort-on-modified-column#post-4687 Fri, 27 Feb 2009 06:11:45 +0000 brinda 4687@http://www.endusersharepoint.com/STP/ <p>can this be achieved with Javascript. I have used some of the Javascript provided by Paul and they work excellent. So, since this cannot be fixed, i thought as a workaround javascript would help. But i have no idea about javascript. </p> http://www.endusersharepoint.com/STP/topic/sign-in-as-a-different-user#post-4686 Fri, 27 Feb 2009 05:24:06 +0000 mpjtaylor 4686@http://www.endusersharepoint.com/STP/ <p>I have come accross this twice now on a Windows XP machine and a Windows Vista machine both running latest IE7. If I sign in as me on someone elses machine while they are logged on as them (as I have more rights) I cannnot get it to stop signing in as me again. Tried sign off, restart IE, reboot, clear cache, delete cookies everything. After a while the Vista machine rectified itself but now over a week later the XP machine still signs into SharePoint as me. Even though email, Communicator, the pc are all logged in as the other person.</p> <p>How on earth can this be fixed! </p> http://www.endusersharepoint.com/STP/topic/not-able-to-acces-forms-authentication-roles-to-sharepoint-groups#post-4685 Fri, 27 Feb 2009 04:26:06 +0000 amreesh 4685@http://www.endusersharepoint.com/STP/ <p>Hi All,<br /> I have a publishing site in sharepoint. i configured forms authentication for this site using asp.net web application. it wass successfull. i added these roles in the SharePoint Groups and gave appropriate Approve permission to the group. i created different users and assigned them the roles in asp.net web application. Now if i edit a page and start a workflow(serial workflow) as an administrative user and then i login as a normal user under the role which i have added in the sharepoint group, i am not able to see the "Approve" "Reject" and "View Page Tasks" on the home page. I tried by configuring the Forms Authentication for SSP and MySite also which i think not needed in this scenario. </p> <p>If i add a user uder this role in the sharePoint Group then he is able to see all the Approve , Reject and 'View page taks" buttons but not when i add a role in the SharePoint Group. Please give the solution immediately. its very urgent. Any help regarding this will be highly appreciated.</p> <p>i checked the WorkFlow task list permissions and permissions of the workflow. but i am not able to find the solution after so many attempts. please suggest appropriate ideas and solutions...</p> <p>Thanks and Regards<br /> Amreesh Sharma </p> http://www.endusersharepoint.com/STP/topic/calendar-timedate-vs-calendar-alert-timedate#post-4684 Fri, 27 Feb 2009 02:16:04 +0000 Christophe 4684@http://www.endusersharepoint.com/STP/ <p>I experience the same issue... I'll add this to the list:<br /> <a href="http://pathtosharepoint.wordpress.com/2008/11/13/issues-with-calendars/" rel="nofollow">http://pathtosharepoint.wordpress.com/2008/11/13/issues-with-calendars/</a> </p>