{"id":340,"date":"2008-10-31T16:47:37","date_gmt":"2008-10-31T16:47:37","guid":{"rendered":"http:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/"},"modified":"2008-10-31T16:47:37","modified_gmt":"2008-10-31T16:47:37","slug":"creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer","status":"publish","type":"post","link":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/","title":{"rendered":"Creating a multi-column search form in SharePoint v3 with SharePoint Designer"},"content":{"rendered":"

This post isn\u2019t anything ground breaking or new but I remember the first time I tried to do this! Also every time I do it I always forget something<\/p>\n

The requirement here is simple<\/p>\n

Create a form that allows the user to enter some search criteria and have it search across specific, multiple columns<\/p>\n

For example, <\/p>\n

There may be a Customers list (which may not be too different to the Northwind database in Access 2007\u2026wink, wink). This list holds lots of details including the customers name, address, phone number, post code, current balance, account number<\/p>\n

When the customer calls you need to be able to call up their details quickly. To identify the customer you may ask for an account number, a post code, etc (even just a part of that information \u2013 first three digits of their post code for example) which is why this needs to work across multiple columns<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n

You may be thinking \u201cwhy don\u2019t you just use the built-in search functionality?\u201d<\/p>\n

The built-in search functionality in SharePoint is still a great tool (and we\u2019ll leave Search Server Express out of this for now!) but the main problem in this scenario it doesn\u2019t work as we as I only want to search on specific fields<\/p>\n

So to get this running first create a Web Part Page <\/p>\n

Click \u201csite actions\u201d, \u201ccreate\u201d, \u201cWeb part page\u201d<\/p>\n

Enter a name for your page (We\u2019ll use \u201ccustomer search\u201d here), select a layout template and select a document library to store the page in and click OK<\/p>\n

 \"image\"<\/a> <\/p>\n

Once you\u2019ve done that you will be taken to the new page. It will be in edit mode ready for you to add some web parts!<\/p>\n

Click \u201cAdd a web part\u201d, select a \u201cForm Web Part\u201d and click OK<\/p>\n

\"image\"<\/a> <\/p>\n

If you just wanted to search on one specific column you could add your list to the page, setup a web part connection and never have to touch SharePoint designer!<\/p>\n

But why do things the easy way? \ud83d\ude42<\/p>\n

Open SharePoint Designer, then open your site and then open your Customer Search Web Part page (if you want to take a copy of that file, now is the time to do it before we mess with it!)<\/p>\n

Click on the \u201cData View\u201d menu and select \u201cInsert Data View\u201d. The data source task library task pane will open and ask you to choose a list.<\/p>\n

Select your customer list and click \u201cShow Data\u201d<\/p>\n

Hold down your CTRL button and pick some fields. I\u2019m going to pick <\/p>\n

First Name, Last Name, Company, Business Phone and Zip\/Postal Code<\/em><\/p>\n

Then click the \u201cInsert Selected Fields as\u201d menu and select the \u201cMultiple Item View\u201d option<\/p>\n

\"image\"<\/a><\/p>\n

  The data view will then be inserted into your page.<\/p>\n

\"image\"<\/a> <\/p>\n

Click the > button for the data view so you get the common tasks menu and select the \u201cparameters\u201d option. In the Data View Parameters dialog select \u201cNew Parameter\u201d<\/p>\n

Give your parameter a name (i\u2019m using \u201cSearchValue\u201d) and change the parameter source to CONTROL and the CONTROL ID to the ID of your FORM WEB PART (If your following these instructions or haven\u2019t changed the ID it\u2019s more than likely T1) and click OK<\/p>\n

\"image\"<\/a> <\/p>\n

Then, from the command task menu of the data view select \u201cWeb Part Connections\u201d. In the first page of the wizard select the \u201cGet Parameters From\u201d option. <\/p>\n

On the second page leave the default \u201cconnect to a web part on this page\u201d option selected<\/p>\n

On the third page set the target web part to be form web part and the target action as \u201cProvide form values to\u201d<\/p>\n

On the fourth page look for your }<\/p>\n

There may be a better way of doing this but it works for me. If you know of a better way please let me know!<\/p>\n

You can also change DispForm to EditForm if you want to be able to go straight to editing the record<\/p>\n

Keep an eye on the \u201cText to display field\u201d as this tries to mirror the address field and this isn\u2019t always what you want<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n

Save the page again and marvel at your finished project!<\/p>\n

The northwind demo data is a bit pants for testing this to be honest but it does the job<\/p>\n

As you know the latest version of SharePoint (v3 \/ 2007) is going to be a part of SBS 2008 and there is a lot of potential for helping your clients make the most of the product so get learning!<\/p>\n","protected":false},"excerpt":{"rendered":"

This post isn\u2019t anything ground breaking or new but I remember the first time I tried to do this! Also every time I do it I always forget something The requirement here is simple Create a form that allows the user to enter some search criteria and have it search across specific, multiple columns For<\/p>\n

<\/span>Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[45,71],"tags":[],"class_list":["post-340","post","type-post","status-publish","format-standard","hentry","category-sharepoint","category-sharepoint-designer"],"yoast_head":"\nCreating a multi-column search form in SharePoint v3 with SharePoint Designer - Andy's Techie Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a multi-column search form in SharePoint v3 with SharePoint Designer - Andy's Techie Blog\" \/>\n<meta property=\"og:description\" content=\"This post isn\u2019t anything ground breaking or new but I remember the first time I tried to do this! Also every time I do it I always forget something The requirement here is simple Create a form that allows the user to enter some search criteria and have it search across specific, multiple columns ForRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/\" \/>\n<meta property=\"og:site_name\" content=\"Andy's Techie Blog\" \/>\n<meta property=\"article:published_time\" content=\"2008-10-31T16:47:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/andyparkes.co.uk\/blog\/wp-content\/uploads\/2008\/10\/image-thumb.png\" \/>\n<meta name=\"author\" content=\"Andy Parkes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andy Parkes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/\",\"url\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/\",\"name\":\"Creating a multi-column search form in SharePoint v3 with SharePoint Designer - Andy's Techie Blog\",\"isPartOf\":{\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#website\"},\"datePublished\":\"2008-10-31T16:47:37+00:00\",\"dateModified\":\"2008-10-31T16:47:37+00:00\",\"author\":{\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d\"},\"breadcrumb\":{\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/andyparkes.co.uk\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a multi-column search form in SharePoint v3 with SharePoint Designer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#website\",\"url\":\"https:\/\/andyparkes.co.uk\/blog\/\",\"name\":\"Andy's Techie Blog\",\"description\":\"Professional Geek\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/andyparkes.co.uk\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d\",\"name\":\"Andy Parkes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g\",\"caption\":\"Andy Parkes\"},\"description\":\"Andy Parkes is Technical Director at Coventry based IT support company IBIT Solutions. Formerly, coordinator of AMITPRO and Microsoft Partner Area Lead for 2012-2013. He also isn't a fan of describing himself in the third person.\",\"sameAs\":[\"http:\/\/www.andyparkes.co.uk\/blog\"],\"url\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/author\/andyparkes\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a multi-column search form in SharePoint v3 with SharePoint Designer - Andy's Techie Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/","og_locale":"en_US","og_type":"article","og_title":"Creating a multi-column search form in SharePoint v3 with SharePoint Designer - Andy's Techie Blog","og_description":"This post isn\u2019t anything ground breaking or new but I remember the first time I tried to do this! Also every time I do it I always forget something The requirement here is simple Create a form that allows the user to enter some search criteria and have it search across specific, multiple columns ForRead More","og_url":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/","og_site_name":"Andy's Techie Blog","article_published_time":"2008-10-31T16:47:37+00:00","og_image":[{"url":"https:\/\/andyparkes.co.uk\/blog\/wp-content\/uploads\/2008\/10\/image-thumb.png"}],"author":"Andy Parkes","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Andy Parkes","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/","url":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/","name":"Creating a multi-column search form in SharePoint v3 with SharePoint Designer - Andy's Techie Blog","isPartOf":{"@id":"https:\/\/andyparkes.co.uk\/blog\/#website"},"datePublished":"2008-10-31T16:47:37+00:00","dateModified":"2008-10-31T16:47:37+00:00","author":{"@id":"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d"},"breadcrumb":{"@id":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/10\/31\/creating-a-multi-column-search-form-in-sharepoint-v3-with-sharepoint-designer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/andyparkes.co.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating a multi-column search form in SharePoint v3 with SharePoint Designer"}]},{"@type":"WebSite","@id":"https:\/\/andyparkes.co.uk\/blog\/#website","url":"https:\/\/andyparkes.co.uk\/blog\/","name":"Andy's Techie Blog","description":"Professional Geek","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/andyparkes.co.uk\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d","name":"Andy Parkes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g","caption":"Andy Parkes"},"description":"Andy Parkes is Technical Director at Coventry based IT support company IBIT Solutions. Formerly, coordinator of AMITPRO and Microsoft Partner Area Lead for 2012-2013. He also isn't a fan of describing himself in the third person.","sameAs":["http:\/\/www.andyparkes.co.uk\/blog"],"url":"https:\/\/andyparkes.co.uk\/blog\/index.php\/author\/andyparkes\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pmvJ6-5u","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=340"}],"version-history":[{"count":0,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/340\/revisions"}],"wp:attachment":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}