.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

InfoPath 2003 - Populate Data Field based on text field from secondary/different data source.

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

I have a form where the main fields are populated based on the results of a query field.
Ex, Main Data (SQL) Source: 

Fruit         Color
Apple       Red
Orange     Orange
Pear         Green
Banana     Yellow

Secondary Data Source (Sharepoint List)
Fruit         Code
Apple        1001
Orange     1002
Pear         1003
Banana     1004

What I would like to do is create form fields that will automatically populate based on the contents of the text field.
Ex,  (text field)   Please enter your fruit of choice:   [ Apple ]

(Field 2 - from main SQL data source)          The color of your fruit is [ RED ]

(Field 3 - from secondary Sharepoint List data source)  Your fruits code is  [ 1001 ]


Any suggestions would be greatly appreciated.

View Complete Post

More Related Resource Links

Is there any way to populate an InfoPath form field with the data from the site content type column?


I have a Form library with a form template.

The templat has a field "Office name" which should not be a fixed list of values, but a dynamical list, feeded from a different type of form. I'm a novice with InfoPath - Sharepoint and I want to find out, how can I can give users a possibility to create and maintain a list of offices and also have this list as a selection list inside main library form - ALL inside one library, if possible.

I assumed that if I publish main form (Itinerary) as a library template form and lookup form (OfficeInfo) as a SiteContent, I should be able somehow to connect to siteContent column and it's information. But I cannot see how - Site Content Gallery is not appering as a Connection item.

Can I use SiteConenct for this purpose or there are other ways to create end-user lookup lists?

Thank you!


changing font color on a data column field based on the contents

I am trying to change font color if the datafield has the string EMERGENCY. This is my original template field: <asp:TemplateField HeaderText="Type" SortExpression="DigType"> <EditItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("DigType") %>' ></asp:Label> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("DigType") %>' ></asp:Label> </ItemTemplate> </asp:TemplateField>   and this is what I thought would work: <EditItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("DigType") %>' ForeColor='<%# IIf(Eval("DigType")="EMERGENCY","Black", "Red") %>'></asp:Label> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("DigType") %>' ForeColor='<%# IIf(Eval(&quo

XML data stored in text field

Hi there, I need to extract XML data stored as text from any number of given rows of a table. The stored XML data typically looks like this: In the ATTRIBUTES field from NODEMEATADATA table <T41><A93>S46 SE Trade &amp; Investment</A93><A35>3284</A35><A84>28 November 2008</A84><A33>S Polkinghorn Bband</A33><A46>S46 0501-KEYF Keyfort Limited</A46><A89>400.68</A89><A90>0</A90><A88>400.68</A88><A66>560200 Broadband</A66><A70>ITAC</A70><A54>N/A</A54><A86 /><A87>Awaiting Posting</A87><A91>Mashudul Karim</A91><A94>Chris Burchell</A94><A92 /></T41> I need to be able to extract the invoice numbers from any number of rows based on a WHERE clause that referes to another column of a date/time format. The invoice numbers are with the <A35>****</A35> tags What I have noticed in the table is that element is not always the same. SOme are <T41> some <T6> or <T7> which I think might have something to do with the document status within the <A87> tags. If possible I need to pick up within multiple elements. I then need to add this to my current simple query: SELECT METAID, CONVERT(VARCHAR(10), CAST(CAST(CREATEDON AS VARCHAR) AS DATETIME), 103) AS 'CREATED', FROM N

A field or property with the name 'FieldName' was not found on the selected data source


I'm attempting to load a GridView dynamically on a button is pressed.

The gridview has AutoGenerateColumns="True" (set in skin definition) and has a declarative column definitions as follows:

<asp:GridView runat="server"
        SkinID="GridViewDetail" ID="gvReport"
            <asp:TemplateField HeaderText="Date">
                        <asp:LinkButton  OnClick="

Dynamic Data Field template edits - Tooltip text, Dynamic Data Page template edits - field sort


I have an ASP.net website build in VB 2010 web dev pro using 4.0 framework.  Its a dynamic data site and I am having some trouble formating some of the field and page canned templates.

Q1: Field Templates - the tooltip code (TextBox1.ToolTip = Column.Description) is within the ascx.vp pages for each of the field templates.  Where can I update each columns description (as the code references) so the tooptip will be column/field specific.  If its not as straight forward as that, I was trying to write an if/else statement because the tooltip code is set at the field type level (decimal, date, etc) and I want it to be column specific.  example;

if column.value = Financial Impact

then  TextBox1.ToolTip = "enter financial impact in whole dollars"

else TextBox1.ToolTip = "next fields tooltip text"



A field or property with the name 'User_x0020_Name' was not found on the selected data source.


I am trying to bind the XML data to a datagrid from an XML file.  I don't know why I am getting the message: "A field or property with the name 'User_x0020_Name' was not found on the selected data source."

The "User_x0020_Name" field does exist in the XML file.  This is a portion of the XML file.

<?xml version="1.0" encoding="utf-8" ?> 
<DataSet xmlns="http://www.----------.com">
 <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
 <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
 <xs:choice minOccurs="0" maxOccurs="unbounded">
 <xs:element name="Table">
 <xs:element name="User_x0020_Name" msdata:ReadOnly="true" minOccurs="0">
 <xs:restriction base="xs:string">

Displaying data from Enhanced Rich Text field


Iam using a custom list, one of the column datatype of the list is Multiple lines of text with type of text to allow as Enhanced Rich Text. Users in my site can copy any type of data and paste in that list coulmn. I need to display the list data in a webpart same as how it is copied. But after querying the list iam getting all the Style tags. How to avoid this.

For example, i copied the following text in the coulmn as below:

One advantage of using the SPGridView control in SharePoint-based solutions is that it has been integrated with the cascading style sheets that are built into Windows SharePoint Services 3.0. Also, the SPGridView control is heavily.
But after quering the list while displaying, following is the output iam getting. How to avoid the tags:

<div class=ExternalClass70B2A73EC47547F98E72395A66BC565C><div>One advantage of using the <strong>SPGridView</strong> control in SharePoint-based solutions is that it has been integrated with the cascading style sheets that are built into Windows SharePoint Services 3.0. Also, the <strong>SPGridView</strong> control is heavily </div></div>

InfoPath -Validate a Field Based on ANY change in a Secondary Field


I would like to require a change to one field if a secondary dropdown field is changed at all.  At Minimum I would like to change the formatting or color of the field in question.


Filter Data View Web Part based on a field



I am trying to filter a data view web part based on a choice made by the end user. I have a lookup field in the Pages list that displays the Title of all pages within that list. I want it so that when an end user selects something from that field that it will filter the list accordingly. Do I need to create a variable, parameter or something of that nature?

Any help is greatly appreciated! Thanks in advance.


How to change the way the infopath form saves data in SharePoint library (Ex: Person/Groups field is

Person/Group field is taken as an integer field in SharePoint form library when a form is submitted. I need to retain it as Person/Group column in the SharePoint form library too. Please help on the same. Thanks.

How to pull data from SharePoint List to Infopath field?

I have customer's name, address, account number, etc in Sharepoint list. In infopath I have a field's like Customer Name, Address, Account number..I created a data connection for Customer's name and I want to populte the related data of that customer in Infopath field by calculated formula or something. When ever we pull some one's name ..I need that customer's Address and other details about him in INfopath form. The data should keep changing if I pull out some other customer's name..Does any one know how to do this? Seems simple..but not able to it though...

Change data type of library field from Single Line Text to currency


I have an InfoPath 2010 form that has a field listing the amount of currency on a meter. It is a Decimal form in Infopath but publishes to SharePoint as a Single Line of Text.  It will not let me modify the column in SharePoint and it will not let me select the allow edit from the Publishing Wizard.  I need the column as a currency so my Excel Queries work.



Linq getting data from field on record



   I would assume this is possiable but I cannot seem to find it anywhere. I just one the contents of a single field, I don't see why I have to return the how

record to get get that information, here is my current code, how can I make this better without returning the entire record, for just getting contents of one field.

var patternrecord = storedb.Patterns_Table.Single(a => a.Pattern_GUID == id);
PMEDIA.Pattern_Key = patternrecord.Pattern_Key;

Combining data from 2 lists, then summing a field


I have 2 lists, one is a contact list (client, client title, address, etc.), the other is a list of meetings with these clients (client name, type of meeting, date, etc.).  The 2nd list has multiple entries for the same client.  I am trying to create a report that combines the data in these lists and displays them like this:

Client--Client Title--MeetingType1--MeetingType2




In addition to combining the list data, I also need to break up the Type of Meeting field and sum the number of different types of meetings for each client.  I added the 2 lists to a linked source, then inserted the data into a DVWP adding data from the 2nd list as a joined subview.


I tried this: xsl:value-of select="count(/dsQueryResponse/Rows/Row[@TypeOfMeeting = 'MeetingType1'])" but it just returns 0.  I'm not sure if that's the correct method though as I think it will return a count of ALL the rows, not the current row.  Any ideas would be appreciated!

How do you create a custom BDC data field that allows for multiple selected values?

I need help creating a custom data field using the BDC column as a base.  We need to allow for multiple selected values instead of just a single one.  I can't find anything on the net which shows how to do this.

Extracting XML Data from a Field SQL Server 2005

I have extracted XML data in the past, but I have received data from a vendor and they basically dumped information into this one XML field.  I am having issues extracting and was wondering if someone might know how?Here is a sample snipit of the info: <form><text id="vwdateneeded" label="Date Needed *">2-2-09</text><text id="vwdesklocation" label="Desk Location *">kljklj</text><text id="vwreportsto" label="Reports To *">kjhjkh</text><text id="vwcostcenter" label="Cost Center *">jkhjklhj</text><select id="vwhardwarerequired" label="Hardware Required *" style="combo">IT Desktop<option label="" /><option label="Business Desktop">Business Desktop</option><option label="Business Laptop">Business Laptop</option><option label="IT Desktop">IT Desktop</option><option label="IT Laptop">IT Laptop</option><option label="IT Project Computer">IT Project Computer</option><option label="Other">Other</option></select><text id="vwcomments" label="Comments *" multiline="true">kjgjhg</text></form>' I took some help from an on

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend