tag:blogger.com,1999:blog-79067837585741559422024-02-06T18:17:58.956-08:00Blue InfoPath (SilverSands Associates.com)Unknownnoreply@blogger.comBlogger21125tag:blogger.com,1999:blog-7906783758574155942.post-35233194637704791172009-06-15T08:35:00.001-07:002009-06-15T08:35:50.357-07:00Silversands Associates iPhone ready<p>The website of SilverSands Associates is adapted to have a real iPhone experience, when surfing to the website with an iPhone. <br /> <br />Have a look. <br />From the iPhone: SilverSandsAssociates.com <br /> <br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJvZ_KEkeXdOThnRMbnDyJh3mSGFZ-KvF4-Fom2CfQ8645iDMs2C3OQzzvNWZqJr24RWixG4XkMrMfSeE6aS6MEFhXmHwq8gOBdDH4N8x1Ey4ksWCKwXj7X03JdzQcDKlO9NTsjwCPpZk/s1600-h/iPhone1%5B2%5D.jpg"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="iPhone1" border="0" alt="iPhone1" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyKtCj3eOfzdM4vd_-hoJLtDiEdeVucP1LDlXy_GRr0fGBlWSsI7qN3eUW6O6ehTt5NKld5Gnb8F_e4fFwpgnSXQcuNOJbOS8_0duqaU7nHh3t_uWd4em5qPHuDyJ6Ffw7D9MJzHcI-Pk/?imgmax=800" width="137" height="244" /></a></p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-64366068666172632622009-06-15T00:57:00.001-07:002009-06-15T00:57:41.031-07:00Filter SharePoint List by Workflow Status<p></p> <p> <p>Often we need to filter a SharePoint list by  the status of a workflow. <br /> <br />This is rather simple and can be done in the same way as filtering any other field. <br /> <br />The only thing you need to know is that the status of the workflow is an integer, not a text.  So we can’t add a filter like ‘Workflow name’ IS EQUAL TO ‘In Progress’ <br /> <br />The following list gives the integer values of each status. <br />This data can also be used within InfoPath to change the layout of the form depending on the status of the workflow. <br /> <br />A blog was written earlier how to do this: <br /><a title="http://blueinfopath.blogspot.com/2008/11/how-to-make-infopath-forms-readonly.html" href="http://blueinfopath.blogspot.com/2008/11/how-to-make-infopath-forms-readonly.html">http://blueinfopath.blogspot.com/2008/11/how-to-make-infopath-forms-readonly.html</a></p> <p> <br /> <br /><strong>List of Workflow statuses</strong></p> </p> <li><b>0</b> - Starting </li> <li><b>1</b> - Failed on Start </li> <li><b>2</b> - In Progress </li> <li><b>3</b> - Error Occurred </li> <li><b>4</b> - Canceled </li> <li><b>5</b> - Completed </li> <li><b>6</b> - Failed on Start (retrying) </li> <li><b>7</b> - Error Occurred (retrying </li> <li><b>15</b> - Canceled </li> <li><b>16</b> - Approved </li> <li><b>17</b> - Rejected <p></p> <p></p> </li> Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-7906783758574155942.post-56402851629254060242009-06-15T00:43:00.001-07:002009-06-15T00:43:20.882-07:00Prepare your InfoPath for deployment and be sure your form is generic<p>When creating an InfoPath form, we often use the data connections. <br />InfoPath makes it easy to work with data connections, but the issue is that the links to the SharePoint library or database is saved in the InfoPath Form. <br /></p> <p>What if we have to move the SharePoint Library to another place? <br />Ex. Test -> Production Environment <br /> <br />What if we change the name of the SharePoint Library we want to submit too? <br /></p> <p>We can’t always return to our InfoPath Designer, make the changes and publish again. <br /></p> <p>Happily for us, InfoPath 2007 with SharePoint has a solution.  SharePoint offers a <b>Data Connection Library.</b> <br />Within the data library we place our InfoPath Data Connections.  When changing database password, changing SharePoint Library names or paths etc we just change the Data Connection file in the Data Connection Library and your InfoPath will continue working. <br /></p> <p>The next part will explain you step by step how to do this. <br /></p> <p><b>To Create </b><b>a SharePoint Data Connection Library if the library does not yet exists.</b></p> <p>1. Browse to an Office SharePoint Server 2007 or Office Forms Server 2007 site on which you have at least <b>Design</b> rights. If you are on the root site, or portal, go to the <b>Document Center</b> or create a new site before proceeding to the next step.</p> <p>2. Click <b>Create</b> on the <b>Site Actions</b> menu.</p> <p>3. On the <b>Create</b> page, click the <b>Data Connection Library</b> link in the <b>Libraries</b> section.</p> <p>4. On the <b>New</b> page, type a name for the library and click the <b>Create</b> button.</p> <p>5. Copy the URL of the new library. <br /></p> <p><b>Update your InfoPath file</b></p> <p>1. Create a data connection in InfoPath, following the wizard</p> <p>2. After creating the data connection, you see the list of data connection.</p> <p>Select the newly created data connection</p> <p>3. Click on <b>Convert</b></p> <p>4. On the <b>Convert Data Connection</b> dialog box, enter the URL of the data connection library that you previously copied.</p> <p>5. Delete "Forms/AllItems.aspx" in the URL.</p> <p>6. Enter a name for the data connection file at the end.</p> <p>7. Click <b>OK</b>.</p> <p>8. Confirm that the data connection has been converted successfully by examining the <b>Details</b> section of the <b>Data Connections</b> dialog box while the converted data connection is selected. <br /></p> <p>Don’t forget to publish your InfoPath Form. <br /></p> <p>You will see that under the Data Connections Library, a new file is added.  This file needs to be updated when moving environments, changing databases, changing submit libraries etc.</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-87158840265030507812009-02-09T06:06:00.001-08:002009-02-09T06:06:30.534-08:00Naming Conventions<p></p> <p>The raison to write this article is because I still see many multi-nationals struggling with naming conventions within their IT department.</p> <p>Naming conventions are as old as IT itself, but still many companies do not have proper naming conventions, and even worse, they use internal of external sources to create one. <br /> <br /><strong>What is the reason to have Naming Conventions in the first place? <br /></strong>The main reason to introduce naming conventions is to :</p> <ul> <li>- to reduce the effort needed to read  and understand source code </li> <li>- to enhance source code appearance </li> </ul> <p>The most important reason is the first one, <em><strong>to reduce the effort needed to read and understand source code</strong></em> <br /> <br />Code must be easy and quick readable and understandable when new employees (internal of external) enters the IT department or when other teams takes over the project..</p> <p>The answer I gave to my customers is very easy: take the naming conventions found on the Internet.  The goal is not only to have company related Naming conventions, but <strong>general naming conventions.</strong></p> <p>New employees or external consultancy will loose less time understanding the general naming conventions, as they were used too with their previous work, instead of learning the company related ones, which will never be followed 100%. <br /></p> <p>Some links:</p> <p>BizTalk: <a title="http://wes.fehler.ca/weblog/biztalk/2005/01/biztalk-naming-conventions.html" href="http://wes.fehler.ca/weblog/biztalk/2005/01/biztalk-naming-conventions.html">http://wes.fehler.ca/weblog/biztalk/2005/01/biztalk-naming-conventions.html</a></p> <p>General Naming Conventions: <a title="http://msdn.microsoft.com/en-us/library/ms229002.aspx" href="http://msdn.microsoft.com/en-us/library/ms229002.aspx">http://msdn.microsoft.com/en-us/library/ms229002.aspx</a></p> <p>And many more are available on the net.  </p> <p> </p> <p>Don’t let your IT department loose time to write company related naming conventions, re-use them!</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-51391933047229028032009-01-19T01:06:00.001-08:002009-01-19T01:06:17.350-08:00Automatically add new row to repeating control<p> <p>Some time ago, I wrote some post how to add a new record to a repeating table, using some code.  The code was working very well, but an answer of Jimmy (Japan) brought me to another solution.  </p> <p></p> <p>The code behind the <strong>Add New Record </strong>button is very simply and we don't need the overhead of opening the manifest.xsf file anymore. <br /> <br />The code is:  (c#) <br /> <br />CurrentView.ExecuteAction(ActionType.XCollectionInsert, "group2_1");</p> <p></p> <p>Where <br /> <br /><strong>Group2_1 </strong>can be found in the Advanced tab of the repeating table, the property called <strong>XmlToEdit</strong></p></p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-16056501911661331212009-01-16T04:36:00.001-08:002009-01-16T04:37:17.511-08:00Thank You - TOP 100 and Cascading Dropdows<p></p> <p>I want to thank all of you interested in InfoPath.  I became a TOP 100 contributor on the <a href="http://www.infopathdev.com/" target="_blank">InfoPathDev.com</a> website, and I see several times that the solutions I gave are working. <br /> <br /></p> <p></p> <p>Also when searching for How to use Cascading Dropdown ListBoxes with InfoPath Services (webbassed) I see many companies implemented the out-of-the-box solution I proposed in my <a href="http://blueinfopath.blogspot.com/2008/11/cascading-drop-downs-in-infopath-web.html" target="_blank">article</a> and many others are using the link in their blogs and replies on forums.</p> <p></p> <p></p> Thanks! Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-7906783758574155942.post-35784233427534424442008-12-08T09:54:00.001-08:002008-12-08T09:54:22.648-08:00Check if combination of values is already entered, using Repeating Controls<p></p> <p>Several posts explains how to use drop down list boxes in repeating tables, assuring that the users can only select values which are not selected in previous rows.  This article describes how to extend this validation, to assure the combination of several fields are not entered in previous rows.</p> <h5>Solution:</h5> <p>1. Within the repeating node, add ahidden <strong>TextBox</strong>, called UniqueValue <br />2. Set the <strong>Default Value</strong> to Concat(field1, field2,..)    Field 1, Field 2,... are the fields that will make the row unique <br />3. Add the following rule to the newly created field: <br />       Condition: <strong>The Expression <br />       </strong>Expression: ../my:UniqueValue = (../preceding- <br />       sibing::my:Group2 | ../following- <br />       sibling::my:Group2)/my:UniqueValue) <br /><strong> <br />    Action:</strong> Show Dialog box with some message that the <br />     combination of fields already exists</p> <p> <br />Group2: is the name of the repeating node within the data-source</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-66427355105658600422008-12-08T09:52:00.001-08:002008-12-08T09:52:59.009-08:00Tips: Remove Administrator Approval when publishing the InfoPath form to SharePoint<p></p> <p>Sometimes, when publishing an InfoPath form to SharePoint, the Publishing Wizard tell you that the form must be approved by an administrator.</p> <p></p> <p> <br />This is a normal behavior when your form contains code, but what if you are sure your form doesn't contain custom code.</p> <p></p> To clean up the link, go to <br /> <ul> <li>- Menu <strong>Tool</strong> -> <strong>Form Options</strong> </li> <li>- Select <strong>Programming</strong> </li> <li>- Click on the <strong>Remove Code</strong> button in the <strong>Programming</strong> <strong></strong></li> <li><strong>  Language Section</strong> </li> </ul> <ol> <div align="left"> <p style="width: 417px; height: 1%">this action will remove the link to the Code Project.  Once this link is available in the Form, even without code you wrote, the Administrator Approval is required.</p> </div> <p></p> <div align="left"></div> <p></p> </ol> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-71902798984672588472008-11-19T10:01:00.001-08:002008-11-19T10:05:12.074-08:00Cascading Drop downs in InfoPath Web Forms made easy<p></p> <p>To create user‐friendly web forms, cascading drop down list boxes is a must, but InfoPath Form Services doesn’t allow you to use them, like you can use them with InfoPath Client. <br />(Filter Data on DataConnections/DataSources are not allowed with InfoPath Web Forms)</p> <p> <br />This article explains how to use Cascading Drop down list boxes within an InfoPath Web Form in a very <u>easy and re-usable way. <br /></u> <br />Please download the PDF file containing the step by step guide <br /> <br /><a href="http://www.silversandsassociates.com/HOW_TO_use_Cascading_Dropdown_ListBoxes_within_an_InfoPath_Web_Form.pdf" target="_blank">HOW_TO_use_Cascading_Dropdown_ListBoxes_within_an_InfoPath_Web_Form.pdf</a></p> Unknownnoreply@blogger.com27tag:blogger.com,1999:blog-7906783758574155942.post-6816927458525254902008-11-19T09:59:00.001-08:002008-11-19T10:00:44.288-08:00HOW TO make InfoPath Forms Readonly when SharePoint Worflow is started<p></p> <p>When users filling in an InfoPath Form and submit the form to a SharePoint library, a workflow can be started (ex. Approval). In many cases we don’t want the user changes information after the workflow is started.</p> <p></p> This works with SharePoint Workflows and Nintext Workflows <p></p> <p> <br /></p> Please download the PDF file containing the step by step guide: <br /> <br /> <p><a href="http://www.silversandsassociates.com/HOW_TO_Make_InfoPath_Forms_Readonly_when_a_SharePoint_Workflow_is_started.pdf" target="_blank">HOW_TO_Make_InfoPath_Forms_Readonly_when_a_SharePoint_Workflow_is_started.pdf</a></p> Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-7906783758574155942.post-59765963318400240722008-10-29T13:31:00.001-07:002008-10-29T13:31:12.950-07:00Use Option Control to keep Preferred Opening View<p> <p><a name="_Toc213065833">Introduction</a> <br /> <br />The next article describes how to use an option control, to save the preferred view when opening the InfoPath document; <br /> <br /><a name="_Toc213065833">Step by Step</a> <br /> <br />1. Create your different views <br />2. Add a option control to view 1 <br />3. Double Click the Option Controls, and set the <strong>Value when selected</strong></p> <p>4. Open the <strong>Form Options,</strong>  Menu Tools -> Form options <br />5. Select <strong>Open and Save</strong> item in the Category list <br />6. Click the <strong>Rules </strong>button in the <strong>Open behavior</strong> section <br />7. Click the <strong>Add </strong>button to create a new rule <br />8. Click the <strong>Rule Name</strong> to <strong>SwitchToView1 <br /></strong>9. Click the <strong>Set Condition </strong>button <br />10. Select the Option Control Field in the first dropdown list box <br />11. Set the value of the Option 1 (See Value when selected) in the third col. <br />12.Click the <strong>Ok </strong>button</p> <p>13. Click the <strong>Add Action</strong> button <br />14. Select <strong>Switch Views</strong> in the Action dropdown listbox <br />15.Select View 1 <br />16. Repeat from <strong>Point 7 to </strong>16<strong>  for all the other views.</strong></p> <p>. </p></p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-21228683000104582392008-10-29T13:05:00.001-07:002008-10-29T13:05:44.408-07:00How to populate a list with subdirectories of a SharePoint Library<h4><a name="_Toc213065833">Introduction</a></h4> <p>When creating subdirectories in SharePoint Library, you can’t submit directly to one the sub directories. Also when users add or change the subdirectories, how to handle this in InfoPath.</p> <p><b><i> <br /></i></b></p> <h4><a name="_Toc213065833">Compatibility</a> <br /></h4> <p>InfoPath 2003 and 2007: Full Support <br />Form Serices:  No Support</p> <h4><a name="_Toc213065834">Designing the Form Template</a></h4> <p><b></b></p> <ol> <li>Create the Receiving Data Connection <ol> <li>Go to <b>Menu Tools ->Data Connections</b> </li> <li>Click the <b>Add button</b> </li> <li>Select <b>Receive data</b> </li> <li>Select <b>SharePoint library or list</b> </li> <li>Enter the path to your SharePoint Site </li> <li>Select the Library </li> <li>Select <b>Item</b> and <b>Content Type</b> </li> </ol> </li> </ol> <p><a href="http://lh3.ggpht.com/BlueOceansPictures/SQjCCSBZaYI/AAAAAAAAARc/pQbC6ZoqLe4/s1600-h/clip_image0023.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="171" alt="clip_image002" src="http://lh5.ggpht.com/BlueOceansPictures/SQjCDFsc81I/AAAAAAAAARg/oZqMi1dheMY/clip_image002_thumb.jpg?imgmax=800" width="244" border="0" /></a></p> <p><b>Figure 1: Select Item and Content Type</b></p> <p><b></b></p> <ol> <ol> <li>Set the name to <b>SubDirectories</b> </li> </ol> </ol> <ol> <li>Add the Dropdown list to your form <ol> <li>Add a dropdown list box to the form </li> <li>Double-Click the newly added list box, to open the <b>Properties Dialog Box</b> </li> <li>Select <b>‘Look up values in a data connection ,….’ </b>In the list box entries section </li> <li>Select <b>SubDirectories</b> in the Data Connection Dropdown listbox </li> <li>Click on the <b>‘Select </b>xPath’ button <a href="http://lh6.ggpht.com/BlueOceansPictures/SQjCDo2bsfI/AAAAAAAAARk/OZkKSjuhPXQ/s1600-h/clip_image0033.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="30" alt="clip_image003" src="http://lh5.ggpht.com/BlueOceansPictures/SQjCEGPUmgI/AAAAAAAAARo/gntGOHatGTM/clip_image003_thumb.jpg?imgmax=800" width="30" border="0" /></a> next to the<b> Entries textbox</b> </li> <li>Select the<b> repeating node </b>from the list (= SharePoint Library Name) </li> <li>Click on the <b>Filter Data</b> button </li> <li>Select <b>Content_Type </b>in the first dropdown list box </li> <li>Enter the text <b>Folder</b> in the third dropdown list box </li> </ol> </li> </ol> <p><a href="http://lh6.ggpht.com/BlueOceansPictures/SQjCEmq7s3I/AAAAAAAAARs/8c-nBRt8Wcs/s1600-h/clip_image0053.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="66" alt="clip_image005" src="http://lh4.ggpht.com/BlueOceansPictures/SQjCFGJ719I/AAAAAAAAARw/i-BQut3zjcU/clip_image005_thumb.jpg?imgmax=800" width="244" border="0" /></a></p> <p><b>Figure 2: Filter Data settings</b></p> <ol> <ol> <li>Click 3x the <b>Ok </b>button </li> <li>Set<b> Value </b>and<b> Display Name </b>to<b> @Item</b> </li> <li>Click the<b> Ok </b>button </li> </ol> <li>Test the form </li> </ol> <p><b></b></p> <p><b></b></p> <h4><a name="_Toc213065835">Submitting the form to the selected sub directory</a></h4> <ol> <li>Create a Submit Connection to the main SharePoint Directory <ol> <li>Go to <b>Menu Tools ->Data Connections</b> </li> <li>Click the <b>Add button</b> </li> <li>Select <b>Submit data</b> </li> <li>Select<b> To a SharePoint library</b> </li> <li>Enter the Path of the<b> Main SharePoint Library</b> </li> <li>Set the<b> file name</b> </li> <li>Click the <b>Finish</b> button </li> </ol> </li> </ol> <ol> <li>Set the submitting options <ol> <li>Go to <b>Menu Tools ->Submitting forms</b> </li> <li>Select <b>Enable Submit Commands and buttons</b> </li> <li>Select <b>Custom Submit using form Code</b> in the <b>Submit to</b> dropdown list box </li> <li>Select <b>Edit Form Code</b> </li> <li>Click the<b> Ok button</b> </li> </ol> </li> </ol> <p><b><a href="http://lh4.ggpht.com/BlueOceansPictures/SQjCFj3dSAI/AAAAAAAAAR0/MqFo09_Yl60/s1600-h/clip_image0063.gif"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="14" alt="clip_image006" src="http://lh4.ggpht.com/BlueOceansPictures/SQjCFzhgj2I/AAAAAAAAAR4/0kPNV2bG39g/clip_image006_thumb.gif?imgmax=800" width="14" border="0" /></a> Note:</b></p> <p>The Microsoft script editor will open</p> <p>Point f : is the code using InfoPath 2003</p> <p>Poit g : is the code using InfoPath 2007</p> <ol> <ol> <li><a name="OLE_LINK64"></a><a name="OLE_LINK63">Add the following code to <b>the XDocument::OnSubmitRequest</b> functio</a>n </li> </ol> </ol> <p><a name="OLE_LINK67"></a><a name="OLE_LINK66"></a><a name="OLE_LINK65"><b>Code for InfoPath 2003</b></a></p> <p>//-- Create string objects for each field we will use to modify the FolderUrl – </p> <p><a name="OLE_LINK42"></a><a name="OLE_LINK41">var </a><a name="OLE_LINK49"></a><a name="OLE_LINK48">xnLocation </a>= XDocument.DOM.selectSingleNode("my:myFields/my:DynamicInfo/my:xnLocation").text;</p> <p>//-- Get a reference to the submit data connection – </p> <p>var fc = XDocument.DataAdapters["<b>Submit</b>"]; </p> <p>//-- Modify the Submit connection URL we want to submit to by concatenating the //-- xnLocation and xnFolderName values – </p> <p><a name="OLE_LINK47"></a><a name="OLE_LINK46">fc.FolderURL </a>= fc.FolderURL + "/" + xnLocation; </p> <p>//-- Execute the submit connection – </p> <p>try </p> <p>{ </p> <p>fc.Submit(); </p> <p>eventObj.ReturnStatus = true; </p> <p>} </p> <p>catch(ex) </p> <p>{ </p> <p>eventObj.ReturnStatus = false; </p> <p>}</p> <ol> <ol> <li>Add the following code to <b>the </b><b>FormEvents_Submit</b> function </li> </ol> </ol> <p><b>Code for InfoPath 2007</b></p> <p>try</p> <p>{</p> <p>// Get a reference to the form's XmlNamespaceManager object.</p> <p>XmlNamespaceManager ns = this.NamespaceManager;</p> <p>// Create an XPathNavigator object for the form's main data</p> <p>// source.</p> <p>XPathNavigator xnDoc = this.MainDataSource.CreateNavigator();</p> <p>XPathNavigator xnCountry = </p> <p>xnDoc.SelectSingleNode("/my:myFields/my:country", ns);</p> <p>if (xnCountry != null)</p> <p>{</p> <p>FileSubmitConnection dc =</p> <p>(FileSubmitConnection)this.DataConnections["Main submit"];</p> <p>if (dc != null)</p> <p>{</p> <p>dc.FolderUrl = dc.FolderUrl + "/" + xnCountry.Value;</p> <p>dc.Execute();</p> <p>e.CancelableArgs.Cancel = false;</p> <p>}</p> <p>}</p> <p>}</p> <p>catch (Exception ex)</p> <p>{</p> <p>e.CancelableArgs.Message = "There was a problem submitting the </p> <p>form:\n\n" + ex.Message;</p> <p>e.CancelableArgs.Cancel = true;</p> <p>}</p> <ol> <ol> <li><b>Save </b>and <b>Close</b> the Microsoft Script Editor </li> <li>Finish the InfoPath 2003 form with the <b>other business requirements</b> </li> <li><b>Publish</b> the Form Template to the SharePoint document library or document libraries </li> </ol> </ol> Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7906783758574155942.post-53174393242448532092008-10-27T11:25:00.001-07:002008-10-27T11:25:14.037-07:00Create Personal SharePoint Views depending on an InfoPath field using [Me]<h5>This article is a continue on the previous article "HOW TO Populate a List with the SharePoint Users"</h5> <h5><a name="_Toc212891992">Download</a></h5> <p>To download both articles, please click on the following link:</p> <p><a href="http://www.silversandsassociates.com/HOW_TO_Populate_a_List_with_the_SharePoint_Users.pdf" target="_blank">HOW_TO_Populate_a_List_with_the_SharePoint_Users.pdf</a></p> <p></p> <h5><a name="_Toc212891992">Problem</a></h5> <p>When publishing the previous form to SharePoint, and you promote the field Assign To, you will notice the newly created column is of type: Single line of Text.</p> <h4></h4> <h4><a href="http://lh5.ggpht.com/BlueOceansPictures/SQYHXe29DzI/AAAAAAAAAQc/8fhVmKk4-Hk/s1600-h/clip_image0013.gif"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="55" alt="clip_image001" src="http://lh3.ggpht.com/BlueOceansPictures/SQYHYOaoT4I/AAAAAAAAAQg/ba_cyRFRhsI/clip_image001_thumb.gif?imgmax=800" width="244" border="0" /></a><a href="http://lh4.ggpht.com/BlueOceansPictures/SQYHY_eCBOI/AAAAAAAAAQk/tvpe_c18xao/s1600-h/clip_image0033.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="149" alt="clip_image003" src="http://lh6.ggpht.com/BlueOceansPictures/SQYHZXCSVjI/AAAAAAAAAQo/BEagRjds5i0/clip_image003_thumb.jpg?imgmax=800" width="244" border="0" /></a></h4> <p><b>Figure 3: View of columns.</b></p> <h4></h4> <p>When you want to filter this view, using [Me], you will receive an error</p> <h4></h4> <h4><a href="http://lh4.ggpht.com/BlueOceansPictures/SQYHaUogGAI/AAAAAAAAAQs/lpFUkQS_X2c/s1600-h/clip_image0053.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="150" alt="clip_image005" src="http://lh6.ggpht.com/BlueOceansPictures/SQYHbU8Wj2I/AAAAAAAAAQw/b6QTi09ihBI/clip_image005_thumb.jpg?imgmax=800" width="244" border="0" /></a></h4> <p><b>Figure 4: Edit View page, Set Filter.</b></p> <h4></h4> <p>The error you receive is: The value is not a valid text string</p> <h4><a href="http://lh3.ggpht.com/BlueOceansPictures/SQYHcO60OwI/AAAAAAAAAQ0/4je_L6IYukU/s1600-h/clip_image0073.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="119" alt="clip_image007" src="http://lh3.ggpht.com/BlueOceansPictures/SQYHcvAGWRI/AAAAAAAAAQ4/AgXA4J4Yjqg/clip_image007_thumb.jpg?imgmax=800" width="244" border="0" /></a></h4> <p><b>Figure 5: Error Message.</b></p> <h4></h4> <b> <br /></b> <h5><a name="_Toc212891993">Solution</a></h5> <p>In general, we need to add a new column and create a SharePoint Workflow with the SharePoint Workflow Designer</p> <ol> <li>Add a new column to the View </li> </ol> <p>- Open the <b>Form Library Settings</b> page</p> <p>- Click on <b>Create Column</b> in the Columns Section</p> <p>- Enter <b>Assign To User </b>as Column name</p> <p>- Select <b>Person or Group</b> as the type of the column</p> <p>- Click on the <b>Ok</b> button</p> <ol> <li>Create <b>Workflow</b> </li> </ol> <p>- Open the<b> SharePoint Designer</b></p> <p>- Create a<b> new workflow </b>(Menu File ->New -> Workflow)</p> <p>- Set the workflow name: <b>SetAssignToUserField</b></p> <p>- Select the <b>SharePoint list</b> where the workflow should be <b>attached</b> to</p> <p>- Select <b>Automatically start this workflow when a new item is created</b> checkbox</p> <p>- Select <b>Automatically start this workflow when a new item is changed</b> checkbox</p> <p><a href="http://lh4.ggpht.com/BlueOceansPictures/SQYHdj53vdI/AAAAAAAAAQ8/xeJXyQ3OWWM/s1600-h/clip_image0093.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="191" alt="clip_image009" src="http://lh3.ggpht.com/BlueOceansPictures/SQYHeUHnyzI/AAAAAAAAARA/EacOY4qzIds/clip_image009_thumb.jpg?imgmax=800" width="244" border="0" /></a></p> <p><b>Figure 5: Define Workflow, step 1.</b></p> <p>- Enter the Step 1 name: <b>SetAssignToUser</b></p> <p>- Select <b>Set Field in Current Item </b>under the <b>Actions</b></p> <p>- Click on<b> Field </b>and select<b> Assign To User </b>(the newly created column in the SharePoint View)</p> <p>- Click on <b>Value</b>, click on the <b>Display Data Binding Fx </b>button</p> <p>- Select <b>Current Item </b>as<b> Source</b></p> <p style="width: 441px; height: 1%">- Select<b> Assign To </b>in the <b>Field</b> dropdown box</p> <p><a href="http://lh3.ggpht.com/BlueOceansPictures/SQYHfGokJSI/AAAAAAAAARE/jxH7VfMRXTA/s1600-h/clip_image0113.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="104" alt="clip_image011" src="http://lh4.ggpht.com/BlueOceansPictures/SQYHfrmDpUI/AAAAAAAAARI/75j_DTs4KVw/clip_image011_thumb.jpg?imgmax=800" width="244" border="0" /></a></p> <p><b>Figure 6: Define Workflow Lookup Dialog Box</b></p> <p><b></b></p> <p><b><a href="http://lh3.ggpht.com/BlueOceansPictures/SQYHgNooY0I/AAAAAAAAARM/-VMUO5K4WtE/s1600-h/clip_image0123.gif"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="14" alt="clip_image012" src="http://lh3.ggpht.com/BlueOceansPictures/SQYHgvJauVI/AAAAAAAAARQ/bCRDiW9wcUc/clip_image012_thumb.gif?imgmax=800" width="14" border="0" /></a> Note:</b></p> <p>Note that we just link the Assign To field (Created by InfoPath and keeps the User ID) to the Assign User To column, which is of a Person Group type.</p> <p>SharePoint will execute the lookup automatically and will shows the Display Name in the view<b></b></p> <p>- Click the <b>Finish</b> button</p> <ol> <li>Add the filter </li> </ol> <p>- Go back to the SharePoint List</p> <p>- Modify the Current View</p> <p>- Select <b>Show Items only when the following is True </b>radio button, under the <b>filter</b> <b>Section</b></p> <p>- Select <b>Assign User To</b> from the <b>Show the items when column </b>dropdown box</p> <p>- Enter in the value textbox <b>[Me]</b></p> <p><a href="http://lh4.ggpht.com/BlueOceansPictures/SQYHhd4EdTI/AAAAAAAAARU/tKdllzXesjY/s1600-h/clip_image0143.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="150" alt="clip_image014" src="http://lh6.ggpht.com/BlueOceansPictures/SQYHiMH3BrI/AAAAAAAAARY/6IGZg1U3yAw/clip_image014_thumb.jpg?imgmax=800" width="244" border="0" /></a></p> <p><b>Figure 7: Filter Settings of the View</b></p> <p>- Click on the<b> Ok Button</b></p> Unknownnoreply@blogger.com10tag:blogger.com,1999:blog-7906783758574155942.post-85316566750182610042008-10-27T11:23:00.001-07:002008-10-27T11:23:31.779-07:00HOW TO Populate a List with the SharePoint Users<h4><a name="_Toc212611230">Introduction</a></h4> <p>In many cases, when filling in a form, some of the data must be user names. Users coming from SharePoint as you work together in a Team.</p> <p>A possible scenario is to assign forms to colleagues like tasks or to use with a workflow within InfoPath.</p> <p>This article will explain how to fill in a dropdown list with the SharePoint Users</p> <p></p> <a name="_Toc212611229"> <h4>Download</h4> </a> <p><a href="http://www.silversandsassociates.com/HOW_TO_Populate_a_List_with_the_SharePoint_Users.pdf" target="_blank">HOW_TO_Populate_a_List_with_the_SharePoint_Users.pdf</a></p> <h4><a name="_Toc212611229">Compatibilty</a></h4> <p>Most of the information will be showed in a table and using symbols.</p> <p></p> <table cellspacing="0" cellpadding="2" width="400" border="0"><tbody> <tr> <td valign="top" width="159">InfoPath 2003</td> <td valign="top" width="59"><a href="http://lh5.ggpht.com/BlueOceansPictures/SQYG7H56mBI/AAAAAAAAAPc/FA9S59Y085A/s1600-h/clip_image00142.gif"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="17" alt="clip_image001[4]" src="http://lh4.ggpht.com/BlueOceansPictures/SQYG70BKbcI/AAAAAAAAAPg/E7ug_fRkhuk/clip_image0014_thumb.gif?imgmax=800" width="18" border="0" /></a></td> <td valign="top" width="177">Full support</td> </tr> <tr> <td valign="top" width="157">InfoPath 2007</td> <td valign="top" width="59"><a href="http://lh5.ggpht.com/BlueOceansPictures/SQYG7H56mBI/AAAAAAAAAPc/FA9S59Y085A/s1600-h/clip_image00142.gif"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="17" alt="clip_image001[4]" src="http://lh4.ggpht.com/BlueOceansPictures/SQYG70BKbcI/AAAAAAAAAPg/E7ug_fRkhuk/clip_image0014_thumb.gif?imgmax=800" width="18" border="0" /></a></td> <td valign="top" width="177">Full support</td> </tr> <tr> <td valign="top" width="157">Desktop Browser</td> <td valign="top" width="59"><a href="http://lh5.ggpht.com/BlueOceansPictures/SQYG8x9vB3I/AAAAAAAAAPk/LRw-93ZW8pU/s1600-h/clip_image0024.gif"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="17" alt="clip_image002" src="http://lh6.ggpht.com/BlueOceansPictures/SQYG-Ivjc2I/AAAAAAAAAPo/VC2V0m27A9U/clip_image002_thumb.gif?imgmax=800" width="18" border="0" /></a></td> <td valign="top" width="177">No support</td> </tr> <tr> <td valign="top" width="155">Mobile device browser</td> <td valign="top" width="59"><a href="http://lh5.ggpht.com/BlueOceansPictures/SQYG8x9vB3I/AAAAAAAAAPk/LRw-93ZW8pU/s1600-h/clip_image0024.gif"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="17" alt="clip_image002" src="http://lh6.ggpht.com/BlueOceansPictures/SQYG-Ivjc2I/AAAAAAAAAPo/VC2V0m27A9U/clip_image002_thumb.gif?imgmax=800" width="18" border="0" /></a></td> <td valign="top" width="177">No Support</td> </tr> </tbody></table> <p></p> <h4><a name="_Toc212611231">Designing the Form</a></h4> <ol> <li>Create a Receive <b>Data Connection</b> <ol> <li>Go to<b> Menu Tools</b> -> <b>Data Connections…</b> </li> <li>Click the <b>Add…</b> button </li> <li>Select <b>Receive data</b> option </li> <li>Select <b>SharePoint library or List</b> </li> <li>Enter the <b>Ur</b><b> l </b>of a SharePoint Site </li> <li>Select the <b>Library or List</b> </li> </ol> </li> </ol> <p><b><a href="http://lh5.ggpht.com/BlueOceansPictures/SQYG-89PHgI/AAAAAAAAAPs/Ss2edG_eDZw/s1600-h/clip_image0013.gif"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="14" alt="clip_image001" src="http://lh5.ggpht.com/BlueOceansPictures/SQYG_boNwxI/AAAAAAAAAPw/TUOCIgc7qPo/clip_image001_thumb.gif?imgmax=800" width="14" border="0" /></a></b><b> Note:</b></p> <p style="width: 437px; height: 0.02%"></p> <p></p> <blockquote> <p>You can select any Library or Form, as we are going to change it later. The easiest way is to select a Library or list who has <b>Title</b> and <b>ID</b> as columns. <br />In case you don’t have Title, select <b>Item</b></p> </blockquote> <p></p> <p></p> <ol> <ol> <li>Select only <b>Title</b> and <b>ID </b>(or Item and Id, see note above) </li> <li>Change the name of the Data Connection to <b>SharePoint Users</b> </li> </ol> </ol> <p><b></b></p> <p><a href="http://lh3.ggpht.com/BlueOceansPictures/SQYHAq5eyrI/AAAAAAAAAP0/m6yIki4qfOQ/s1600-h/clip_image0033.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="174" alt="clip_image003" src="http://lh6.ggpht.com/BlueOceansPictures/SQYHBgXNVyI/AAAAAAAAAP4/iE3dpC7nM40/clip_image003_thumb.jpg?imgmax=800" width="244" border="0" /></a></p> <p><b>Figure 1: Data Connection Wizard, selecting the columns</b></p> <ol> <li>Extract the Form Files <ol> <li>Goto menu <b>File</b> -> <b>Extract Form Files</b> </li> <li><b>Select the folder to save</b> the extracted form files </li> </ol> </li> <li> <p><a href="http://lh4.ggpht.com/BlueOceansPictures/SQYHCeDEi3I/AAAAAAAAAP8/KAMkT3kFXqU/s1600-h/clip_image0053.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="241" alt="clip_image005" src="http://lh6.ggpht.com/BlueOceansPictures/SQYHDt3NB0I/AAAAAAAAAQA/fT8TqJ9NgMQ/clip_image005_thumb.jpg?imgmax=800" width="244" border="0" /></a></p> </li> <li> <p><b>Figure 2: Browse for folder dialog box.</b></p> <ol> <li>Click <b>Ok</b> </li> <li><b>Close</b> the InfoPath Designer </li> <li>Open the folder with the extracted files </li> <li>Open with <b>Notepad</b> the file <b>Manifest.xsf</b> </li> <li>Search for<b> sharepointGuid</b> </li> <li>Change the Guid with <b>UserInfo</b> </li> </ol> </li> </ol> <p><b></b></p> <p><b>Code:</b></p> <p><xsf:dataObjects></p> <p><xsf:dataObject name="SharePoint Users" schema="SharePoint Users.xsd" initOnLoad="yes"></p> <p><xsf:query></p> <p><xsf:sharepointListAdapter siteUrl="http://mossqa.silversands.com/sites/Sandbox/infopath/" sharepointGuid="{799BD477-5183-4FAB-AE75-A9C45C870D4B}" infopathGroup="File_Attachments" queryAllowed="yes" submitAllowed="no" name="SharePoint Users"></p> <p><xsf:field sharepointName="Title" infopathName="Title"></xsf:field></p> <p><xsf:field sharepointName="ID" infopathName="ID"></xsf:field></p> <p></xsf:sharepointListAdapter></p> <p></xsf:query></p> <p></xsf:dataObject></p> <p></xsf:dataObjects></p> <p><b>Change to</b></p> <p><xsf:dataObjects></p> <p><xsf:dataObject name="SharePoint Users" schema="SharePoint Users.xsd" initOnLoad="yes"></p> <p><xsf:query></p> <p><xsf:sharepointListAdapter siteUrl="http://mossqa.silversands.com/sites/Sandbox/infopath/" sharepointGuid="UserInfo" infopathGroup="File_Attachments" queryAllowed="yes" submitAllowed="no" name="SharePoint Users"></p> <p><xsf:field sharepointName="Title" infopathName="Title"></xsf:field></p> <p><xsf:field sharepointName="ID" infopathName="ID"></xsf:field></p> <p></xsf:sharepointListAdapter></p> <p></xsf:query></p> <p></xsf:dataObject></p> <p></xsf:dataObjects></p> <p><b></b></p> <ol> <ol> <li>Right-click on <b>Manisfest.xsf</b> and <b>Select design </b>to re-open the form in Design mode </li> </ol> </ol> <ol> <li>Populate the Dropdown with the UserInfo <ol> <li>Add a <b>Dropdown list</b> onto the Form </li> <li>Set the <b>Field Name</b> </li> <li>Select <b>Look up values from an external datasource</b> </li> <li>Select<b> SharePoint Users </b>in the Data Source drop down </li> <li>Select the repeating node using <a href="http://lh4.ggpht.com/BlueOceansPictures/SQYHER9sV2I/AAAAAAAAAQE/5KHMNbD2aGw/s1600-h/clip_image0065.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="30" alt="clip_image006" src="http://lh6.ggpht.com/BlueOceansPictures/SQYHFKmDALI/AAAAAAAAAQI/yiU0QddtjpE/clip_image006_thumb.jpg?imgmax=800" width="30" border="0" /></a> button next to the <b>Entries</b> textbox </li> <li>Set Value to <b>@ID</b>, by using the <a href="http://lh6.ggpht.com/BlueOceansPictures/SQYHFirZ9xI/AAAAAAAAAQM/dzi-N_6hZUs/s1600-h/clip_image00612.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="30" alt="clip_image006[1]" src="http://lh4.ggpht.com/BlueOceansPictures/SQYHGSLkGcI/AAAAAAAAAQQ/6cEDPRfivYY/clip_image0061_thumb.jpg?imgmax=800" width="30" border="0" /></a> next to the Value textbox </li> <li>Set Value to <b>@Name</b>, by using the <a href="http://lh6.ggpht.com/BlueOceansPictures/SQYHHvKZrbI/AAAAAAAAAQU/6KfrfC5gpPk/s1600-h/clip_image00622.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="30" alt="clip_image006[2]" src="http://lh3.ggpht.com/BlueOceansPictures/SQYHIZN7W5I/AAAAAAAAAQY/SjDTYKTi4PU/clip_image0062_thumb.jpg?imgmax=800" width="30" border="0" /></a> next to the Display name textbox </li> </ol> </li> </ol> <ol> <li>Test the form, your doprodown box will be filled with the SharePoint Users </li> </ol> <b><i> <br /></i></b> <h4><a name="_Toc212611232">Conclusion</a></h4> <p>This article described how to populate a dropdown list box 8or other list boxes) with the users from SharePoint.</p> <p>There are other ways of doing this, like using a web services, but this way you can keep everything in the design mode of the form</p> Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-7906783758574155942.post-11359944122945934502008-10-20T10:46:00.003-07:002008-10-20T10:46:45.925-07:00Data validation, Filter Data: Case Sensitive<p></p> <p></p> <blockquote> <p></p> <p></p> <p></p> <p>When you add <strong>data validation</strong> or you want to <strong>filter data, </strong>you already saw that the conditions are <strong>Case Sensitive. <br /> <br />Example: </strong>When you have a text box and you don't want the user to fill in the value abc.  When adding the Data validation Field 1 equal to "abc", then show message box. <br /> <br />When the user enter ABC, the message box isn't popped up. <br /> <br /><strong>Solution:</strong></p> <p>There is no uppercase or lowercase available in InfoPath, the easiest way to reach or goal is to use the <strong>Translate </strong>function: <br /> <br />So the data validation rule will be:</p> <p></p> <p>- Select <strong>The Expression</strong> in the first dropdown <br />- Add the following condition to the Expression Textbox <br /> <br />translate(., "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz") = "abc"</p> <br />This way of working can be used also to Filter Data. <br /> <br /> <p></p> <div class="wlWriterSmartContent" id="scid:0767317B-992E-4b12-91E0-4F059A8CECA8:88510ae9-13fb-41ab-a50e-2d49bafe257c" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px">Blue Oceans Tags: <a href="http://www.example.com/Data%20Validation" rel="tag">Data Validation</a>, <a href="http://www.example.com/Filter%20Data" rel="tag">Filter Data</a>, <a href="http://www.example.com/Case%20Sensitive" rel="tag">Case Sensitive</a>, <a href="http://www.example.com/XPath" rel="tag">XPath</a></div></blockquote> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-74522098579474271722008-10-20T10:46:00.001-07:002008-10-20T10:46:19.597-07:00Debug Tip for InfoPath Forms  <p>In normal environments like creating ASP.net of VB.Net software, the developer has some tools to test and to debug the code.   With Microsoft InfoPath forms the logic behind the form can be very complex also.  How do you debug a form when the form isn't reacting as it should be? <br /> <br />Microsoft added into InfoPath 2007 the Logic Inspector.  This create tool gives the designer of the form an overview about</p> <p></p> <p>- The data validations used on the forms <br />- The Calculated Default Values <br />- The Rules used <br />- Programming information</p> <p></p> <a href="http://lh6.ggpht.com/BlueOceansPictures/SPzD39NK0CI/AAAAAAAAAMM/VodILtfWi6o/s1600-h/LogicInspector2.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="244" alt="LogicInspector" src="http://lh4.ggpht.com/BlueOceansPictures/SPzD5IarzoI/AAAAAAAAAMQ/MyALn6n7muQ/LogicInspector_thumb.jpg?imgmax=800" width="172" border="0" /></a> <p></p> <p></p> <p style="width: 435px; height: 0.08%"></p> <p></p> <p>This is not all, when clicking on a field, a second window will open which gives you <br />- Logic that depends on the value of this field or group <br />- Logic that is triggered by a change in this field or group <br />- The default values of this field <br />- The Rules used by this field</p> <p></p> <p></p> <p><a href="http://lh3.ggpht.com/BlueOceansPictures/SPzD56LTmTI/AAAAAAAAAMU/cdNr9tpiyyU/s1600-h/LogicInspector_Details2.jpg"></a><a href="http://lh3.ggpht.com/BlueOceansPictures/SPzD56LTmTI/AAAAAAAAAMU/cdNr9tpiyyU/s1600-h/LogicInspector_Details2.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="226" alt="LogicInspector_Details" src="http://lh3.ggpht.com/BlueOceansPictures/SPzD6oHUigI/AAAAAAAAAMY/8Dv6uKDuTZk/LogicInspector_Details_thumb.jpg?imgmax=800" width="244" border="0" /></a></p> <p></a></p> <p></p> <p></p> <p><strong>What else can you do with this information? <br /></strong>This feature is great as you can quickly see why some data in a field is wrong?  Also you can print this documentation.   If you have a PDF print driver, you can create PDF files and store them together with the other documentation of the project.</p> <div align="left"> <p></p> </div> <p></p> <div class="wlWriterSmartContent" id="scid:0767317B-992E-4b12-91E0-4F059A8CECA8:faa04a8e-62d6-4e65-ac68-9b32e1f9b370" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px">Blue Oceans Tags: <a href="http://www.example.com/Logic%20Inspector" rel="tag">Logic Inspector</a>, <a href="http://www.example.com/debugging" rel="tag">debugging</a></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-78937863136717785322008-10-16T10:40:00.001-07:002008-10-16T11:07:08.887-07:00InfoPath Forms Compatibility white paper available (for free)<p>This white paper shows an overview of the different controls and features in InfoPath and where they can be used. The document will cover InfoPath 2003, InfoPath 2007 and InfoPath Form Services (desktop and mobile devices)</p> <p>The audiences of the white paper are Business Analysts, developers and decision makers.</p> <p>The white paper is available in PDF format and is distributed freely. </p> <p>Download File: <a href="http://www.silversandsassociates.com/InfoPath_Forms_Compatibility_Overview.pdf" target="_blank">InfoPath_Forms_Compatibility_Overview.pdf</a></p> <p>Visit for more Info and blogs to <a href="http://www.silversandsassociates.com/" target="_blank">SilverSands Associates</a> website.</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-5873281906195143912008-10-09T08:12:00.001-07:002008-10-09T08:12:18.977-07:00How to use wildcard characters in an InfoPath form query when binding to an ADO data source ?<p> </p> <p>When reading forums about Microsoft InfoPath on the Internet, I see this question coming back often.</p> <p>The answer is clear: It is not possible 100% out-of the-box.</p> <p>Microsoft create a very good article about this issue and give an explanation about the work-around.</p> <p>The link: <a title="http://support.microsoft.com/kb/826992" href="http://support.microsoft.com/kb/826992" target="_blank">http://support.microsoft.com/kb/826992</a></p> <p>The link gives a workaround for Microsoft InfoPath 2003 and InfoPath 2007.</p> <div class="wlWriterSmartContent" id="scid:0767317B-992E-4b12-91E0-4F059A8CECA8:2d8c8b65-8bcb-4d94-a6f0-bfc66a2a382c" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px">Blue Oceans Tags: <a href="http://www.example.com/Wildcards" rel="tag">Wildcards</a>, <a href="http://www.example.com/Query" rel="tag">Query</a>, <a href="http://www.example.com/InfoPath%202003" rel="tag">InfoPath 2003</a>, <a href="http://www.example.com/InfoPath%202007" rel="tag">InfoPath 2007</a></div> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-19365232725344366382008-09-19T06:45:00.000-07:002008-09-19T07:03:42.470-07:00Hiding Rows in a table based on a condition<strong>Situation:</strong><br />Sometimes you need to only show the records in a repeating table, depending on a selected value of a dropdownbox. Anoterhway to say it, you need to hide all rows where the value isn't equal to the selected value.<br /><br /><strong>Solution:</strong><br />- Create a Repeating Table (Menu Table -> Insert -> Repeating Table)<br /> Follow the wizard and select the field you want to show.<br />- Update the table layout if needed<br />- Right-click a row and select conditional formatting<br /> To be sure to select the row, make the control smaller and the column bigger, this <br /> way you created an empty space<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ6BnUlgdhOLcBlVdpuCEpaWupM77_L8Wje7CcoaSMbpvQqPYd7EbOH53c6sPKiuhCKLT3GLU_eV75n9b8xYqLQ8KKJ__Gep3_gx0T-nylGRLiDZ7aHkqczEhUlz08VD-yxvEFOG1U9I0/s1600-h/HiddenRow_EmptySpace.bmp"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ6BnUlgdhOLcBlVdpuCEpaWupM77_L8Wje7CcoaSMbpvQqPYd7EbOH53c6sPKiuhCKLT3GLU_eV75n9b8xYqLQ8KKJ__Gep3_gx0T-nylGRLiDZ7aHkqczEhUlz08VD-yxvEFOG1U9I0/s200/HiddenRow_EmptySpace.bmp" border="0" alt=""id="BLOGGER_PHOTO_ID_5247732009370989730" /></a><br /><br />- Set the conditions<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLYPpleE9JCjZrOZY8KaoHOX6ucqLgYY8wqsIEMtsW3J93pLzfCplorg5JCLLKuF-XBF6duvC259gubtLLsfSORNfZimvEY-4iy9ToDmb6O8x8cLBGsbOpKIDz6pHqdvaRDCpsaXT-0do/s1600-h/HiddenRow_ConditionalFormatting.bmp"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLYPpleE9JCjZrOZY8KaoHOX6ucqLgYY8wqsIEMtsW3J93pLzfCplorg5JCLLKuF-XBF6duvC259gubtLLsfSORNfZimvEY-4iy9ToDmb6O8x8cLBGsbOpKIDz6pHqdvaRDCpsaXT-0do/s200/HiddenRow_ConditionalFormatting.bmp" border="0" alt=""id="BLOGGER_PHOTO_ID_5247732118328422306" /></a><br /><br />- Test your form.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7906783758574155942.post-58827928519310225132008-09-17T08:12:00.000-07:002008-09-17T08:13:53.151-07:00Best Practices for Deploying InfoPath 2007 Form Templates to a Production EnvironmentHow do I efficiently move a form template from my development environment to a production environment? <br /><br />Unfortunately, there is not a simple answer to this question. Even with the introduction of InfoPath Forms Services in the 2007 Microsoft Office release, a lot of planning is still needed to configure and deploy a form template for InfoPath-only and browser-compatible form scenarios in both a development and production environment.<br /><br /><br />The following article examines some of the steps you can take to make InfoPath form template deployment less painful<br /><br /><br />Link: http://msdn.microsoft.com/en-us/library/cc704269.aspxUnknownnoreply@blogger.com1tag:blogger.com,1999:blog-7906783758574155942.post-74302198991195630442008-09-17T06:22:00.000-07:002008-09-17T06:31:17.653-07:00How to add User and Creation info to a document<strong>Situation:</strong><br />Within a profesional environment, extra information is added to documets, like creation date username etc. automatically.<br />So how to do this in nfoPath 2007<br /><br /><strong>Solution:</strong><br />1. Open an document<br />2. Add Created By + add a Textbox next to it.<br /> - Change the name to CreatedBy<br /> - Value = <strong>username()</strong><br /> - Display: Read-Only<br /> - Size: Set Height and Width to <strong>auto</strong><br /> - Padding and Margins: Set all values to <strong>0</strong><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGOgoCN2Zbm9odOVcxh0LelwzXgJ18c2j8z1xKE0lFgEE3bNmE6iiknCBtTy7dc80I2l97eyJMxCMWi6UoeTKj1OvaWlUK1nL4vjwQrg7fU7M82xCXjf10fYpEKQKxCFdFY_9vEl-1ZoI/s1600-h/DocumentInfo_1.bmp"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGOgoCN2Zbm9odOVcxh0LelwzXgJ18c2j8z1xKE0lFgEE3bNmE6iiknCBtTy7dc80I2l97eyJMxCMWi6UoeTKj1OvaWlUK1nL4vjwQrg7fU7M82xCXjf10fYpEKQKxCFdFY_9vEl-1ZoI/s200/DocumentInfo_1.bmp" border="0" alt=""id="BLOGGER_PHOTO_ID_5246982125334336034" /></a><br /><br />3. Add the word on after the previous created textbox<br />4. Add a Textbox next to it.<br /> - Change the name to CreateDate<br /> - Value = <strong>today()</strong><br /> - Display: Read-Only<br /> - Size: Set Height and Width to <strong>auto</strong><br /> - Padding and Margins: Set all values to <strong>0</strong><br /><br /><strong>Result:</strong><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghhc1jZR4AnWdNDj0guC11TkbPanyeS73cOZkkn7Q_1uu_7UH-JJP-I2bPIkV8UNLKUcnDOMRl0jLPKeGhsK6-LAaQ77TF8OrcKQMatEkcKjNySlywWyu2Hm_iw5VR9ALnzovbwZRg5Tc/s1600-h/DocumentInfo_Result.bmp"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghhc1jZR4AnWdNDj0guC11TkbPanyeS73cOZkkn7Q_1uu_7UH-JJP-I2bPIkV8UNLKUcnDOMRl0jLPKeGhsK6-LAaQ77TF8OrcKQMatEkcKjNySlywWyu2Hm_iw5VR9ALnzovbwZRg5Tc/s200/DocumentInfo_Result.bmp" border="0" alt=""id="BLOGGER_PHOTO_ID_5246982227602712882" /></a>Unknownnoreply@blogger.com0