Add a new datasource to you InfoPath form that points to your list that you want to count:

Select the ID column. It really doesn’t matter what columns you select.

After you created the datasource we add a textbox to the form to display the number of items in the form:

Now modify the properties of the textbox by right clicking on it and select Text Box Properties:

We will set the default value of the textbox, so click on the formula button: . We use a function to count the items. The function is called: Count(), what a coincidence

We will count the number of items in the datasource we just created:

Make sure you select the “dataFields” SharePointListItem folder and not the queryFields one.

You can use the “filter data” button to filter the items before counting.

That’s all you have to do, besides clicking “OK” a few more times. Now you can preview your form and you can see the number of items in the list.

Share with more services

By using SharePoint as a platform I can create (quick-win) applications in a few moments of time. Can you do that by using some custom development code?

Try this:

Create a web application where users can submit their name, email, address and a document. Make sure everything is stored in a database and the administrators must have the ability to rapidly view, delete of edit each record. They also need some filtering, grouping or sorting mechanism and they want to export the data to excel. Also do not forget the permissions on the backend data and make sure it is reusable.

I can do this in less then 1 hour on the SharePoint platform. Can you? Do you accept this challenge?

Share with more services

Let me repeat my first line: I love the SharePoint community! I’m just a little concerned about the quality and how the preserve this.

How can I be sure that the information is true? Do we have to rely on the feedback and comments at the end of the articles or do we have to trust on the bio of the authors?

What do you, community members, think?

Share with more services

I did not found a way to do this out-of-the-box so I suggested to create a sandboxed solutions that will handle the request.

What do you need to start?

• a SharePoint site
• a document library with
  • a title column (that’s in there by default)
  • a customer column (text – single line), we will add the name of the customer here
  • a modified template document (format it like you wish, I added a title and the customer fields), note: make sure you save the template document as a .docx file, not as a .dotx file.
• Visual Studio 2010

What will we do?

We will create a web part that we will deploy as a sandboxed solution. The web part will accept the query string parameters and create a document in the library.

To begin, create a new empty SharePoint project and choose to deploy it as a sandboxed solution.

In your project add a new Web Part. Call it: “ParameterPortalWebPart”

Now we have to add some code:

Protected Overrides Sub CreateChildControls()

    Dim label As New Label

    label.Text = "<h1>Parameter portal WebPart</h1>"

    Dim textboxOutput As New TextBox
    textboxOutput.TextMode = TextBoxMode.MultiLine
    textboxOutput.Rows = 10
    textboxOutput.Columns = 20

    Dim output As New Text.StringBuilder()

    output.Append("Customer: ").Append(Page.Request.QueryString("customer"))
    output.Append(Environment.NewLine)
    output.Append("Title: ").Append(Page.Request.QueryString("title"))
    output.Append(Environment.NewLine)
    output.Append(Environment.NewLine)

    ‘create file
    Dim filename As String
    Dim fileurl As String

    If Page.Request.QueryString("customer") <> String.Empty And Page.Request.QueryString("title") <> String.Empty Then
        filename = String.Format("{0}.{1}.{2}", Page.Request.QueryString("customer"), Page.Request.QueryString("title"), Now.Ticks)

        fileurl = Me.CreateDocument(filename, "Document", "Contracts", _
                                                  Page.Request.QueryString("customer"), _
                                                  Page.Request.QueryString("title"))

    End If
 

    Dim hyperlinkFileUrl As New HyperLink
    hyperlinkFileUrl.Text = filename
    hyperlinkFileUrl.NavigateUrl = fileUrl

    textboxOutput.Text = output.ToString

    Me.Controls.Add(label)
    Me.Controls.Add(textboxOutput)
    Me.Controls.Add(hyperlinkFileUrl)

End Sub

What do we do here? We add a few controls to the web part (label, textbox) to provide some feedback. Then we make sure the query string parameters are not empty. Next, we generate a unique filename (by using the Now.Ticks property). You could use another method to do this but this is out of scope here.

Then we call the CreateDocument method that returns the url of the newly created document. This function contains the actual code to generate a document:

Private Function CreateDocument(ByVal filename As String, ByVal contenttypename As String, ByVal listname As String, _
                            ByVal customerName As String, ByVal title As String) As String

    Try
        Dim site As SPSite = SPContext.Current.Site
        Using web As SPWeb = site.OpenWeb()
            web.AllowUnsafeUpdates = True

            Dim list As SPList = web.Lists(listname)
            Dim folder As SPFolder = web.Folders(listname) ‘root folder
            Dim files As SPFileCollection = folder.Files

         
            Dim template As String = list.ContentTypes(contenttypename).DocumentTemplateUrl

            Dim destinationFile As String = files.Folder.Url & "/" & filename & ".docx"

            Dim nieuwDocument As SPFile = files.Add(destinationFile, web.GetFile(template).OpenBinary(), True)
            Dim newItem As SPItem = nieuwDocument.Item
            newItem("ContentType") = contenttypename
            newItem("Customer") = customerName
            newItem("Title") = title
            newItem.Update()

            Return nieuwDocument.Url

        End Using
    Catch ex As Exception
        Throw ex
    End Try
End Function

In this chunk of code we get the document library (root folder) and get the url of the template for a certain content type in that library. We will add a new document based on that template document. At the end we populate the custom fields with the parameters that the url query string provided us.

You can use Visual Studio the deploy the solution to you development environment and start play with it. Package the project and upload the .wsp file to your online environment if you want to test it there.

Have fun with it.

* this code was part of a SharePoint development training. You want this training in your company? Contact us!

Share with more services

In SharePoint 2010 one of the new features are the possibility to edit the input forms in InfoPath.

In my example we created 3 lists:

• Products (custom list)
• Title column
  
• Types (custom list)
• Title column
• Product column: lookup to Products list
  
• Orders (custom list)
• Title column
• Product column: lookup to Products list
• Producttype: lookup to Types list
  

We want to use a cascading lookup in the Orders input form. You edit the form by clicking the InfoPath button in the ribbon of the list.

We want to change the input form so that we can select a product (Car or Bike) and then see the types (Peugeot, Porsche, …)

Therefore we need to add a new data connection that can read data from the Types list. We will use this data connection instead of the default one that is already added. We will filter the custom data connection by the value we are selecting in the Product list.

Adding a new data connection

To add a new data connection click the “Data Connections” button in the Data tab in the ribbon.

Click the “Add” button to add a new one:

The new data connection must receive data, select this option:

Select “SharePoint library or list” and in the next window you add the url to the SharePoint site where the list can be found. Next you select the list (Types):

Now you select the columns of the list we will need. Choose Title and Product and sort the items by Title.

Give the data connection a new in the next screen (I used Types1) and click Finish. Now we create the data connection.

Change the default datasource

By default there is already a data connection linked to the dropdown control on your page. We have to change this.

Therefore we edit the properties of the control.

We select our newly created data connection: Types1

To filter the values you click the button next to the Entries textbox.

Click the “Filter Data” button and add a new filter:

We want to filter the list by the Product column where the Product value must be equal to the value of another field (Products) on our form. Select “field or group”.

Select the main data connection as source and select the Product column:

Click “OK” a few time to confirm all you settings and you are ready.

Now you publish the form to you list and you can start using it.

Share with more services

“Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit.”

Now, we think it is not necessary to increase the storage limit for all our employees but only for the persons who make a lot of use of their MySite. But how?

1. On the Sharepoint server browse to the Central Administration for Sharepoint 2010;
2. Go to “Application Management” and choose “Configure quotas and locks”;
3. Select the applying web application from the list and search for the MySite you want to edit;
4. Select “Individual quota” as a template and modify the limitations to your needs;
5. Hit OK and make your colleague happy.

Share with more services

<style type="text/css">
    .navigationText{
        text-decoration:none !important;
        color:#676767 !important;
        width: 125px;
        height: 125px;
        display:table-cell;
        font-size: medium;
        text-align: center;
        background-color: #CCEBFF;
        vertical-align:middle;
    }
</style>

More information about this keyword is on the W3.org website.

Share with more services

You can use this url:

https://server/sitename/_layouts/SubNew.aspx?List=guid&Source=%2Fsitename

The hard part is to find the list guid of your list. You can do this by browsing to the list where you want to create an alert and go the the list settings. Now you find the list guid in your address bar of your browser. Copy and replace it in the link and you’re ready to share the url.

Share with more services

1. Go to the list settings of your list
   
2. In the general settings section select Advanced settings
   
3. Select the first option: Allow management of content types
   
4. Click on the item contenttype
   
5. Click on the Title column name and select the Hidden (will not appear in forms) option
   
6. Go back to the list settings
7. Make sure the title column is not required
1. Click the title column and choose No
   
8. TIP: edit the default view and deselect the title column. You can add the edit button to let the users edit the item
   

Share with more services

Share with more services