This article applies to InfoPath 2007 only as 2010 and 2013 no longer have this limitation. At some point during your career, you will need to connect to a SharePoint list to retrieve information for a drop down list. This process has changed since 2007 but I thought that I would go ahead and share… Continue reading InfoPath 2007 – Populating from data/dropdown info from SharePoint lists using XML form data
Have you ever logged on to your SharePoint site and the drop down navigation does not work? After days of clicking around, I decided to fix the issue, which really was not much of fix. Turns out, this is an issue with my MS Office installation. All that you have to do is run a repair… Continue reading SharePoint – Dropdown Menu/Navigation Does Not Work
If you need to make changes outside of SharePoint to a list, you always have the option to use Access. Follow these steps and you will be well on your way to using this feature. 1. Open your SharePoint list 2. Click Actions –> Open with Access 3. A dialog box will pop up on… Continue reading Synchronize SharePoint list using Access 2007
Word of warning: If you need to have more than one workflow for a particular list/library, DO NOT copy a SPD workflow and paste back into the same library. What happens is that even if you change all of the properties of the files (names, etc.), there is still a hidden property that SharePoint likes… Continue reading A No-No for having Multiple SPD Workflows for Lists/Libraries
I was faced with this task recently. Let me paint the picture for you. I have a document library with over 1,000 items in it. I added a new column (Named) that needs to have the same information as an existing column (Name). For whatever reason, the web part I am using for my list… Continue reading Need to edit multiple items to kick off a workflow? No prob Bob!
We had an issue come up about security with InfoPath forms. One of the major issues was that we could restrict items in the view, but if you used explorer view, all of the security would be bypassed. To counter this, we use a CEWP and the following jQuery script: HideViewsScript Please note, you will… Continue reading jQuery Security….. Just hide it!
Years ago, I setup an InfoPath form for an approval process. There are around 7 status changes during the duration of this form. We wanted to be able to see how long a request would take from creation to approval. This was actually pretty simple. All that you need is a calculated column. Follow these… Continue reading Add a time duration to a list/library
There may come a time when you will need to move data from one source to another. You could always use Windows Explorer to do this, but you will not be able to retain any metadata in your library. Recently, I needed to move around 1,200 files (680 MB) from a folder into a new… Continue reading Copying files while retaining metadata
There may come a time when you may need to export your user list to excel. It’s not that difficult. Copy the following path into notepad/word pad: http://yoursite.com/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[LISTID]&View=[VIEWID]&CacheControl Minimize the text editor and navigate to Site Actions à Site Setting à People and Groups à All People. Click Settings on the option bar and click… Continue reading How to Export a SharePoint User List to Excel