.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 will not allow to customize list forms if the list contains lookup fields with "link to ite

Posted By:      Posted Date: October 23, 2010    Points: 0   Category :SharePoint

I am posting this here, because the error message is a little misleading: It will say that you may have an incompatible field types, corrupt fields, or fields are mandatory and should not be. As a remedy it's suggested to either make them non-mandatory fields or to delete them and recreate them.

Solution: Just lookup to your field without the "link to item" option. 


View Complete Post

More Related Resource Links

Move custom list (with lookup fields) to another Web Application

Is it possible to move a custom list with lookup fields to other custom lists from one web application to another? Creating list templates does not work and breaks the relationship. Thanks.   Neil

workflow lookup between 2 fields in 1 list

hi, how can a create a workflow lookup in 1 list between 2 fields. i wan to compare if the 2 fields are in the same row. i create a list with users name and their approvers. the approver must be the unique approver of the user in the same list. can i do this with the workflow in sharepoint designer? thnx

Customized list forms and additional fields afterwards

Hello, Sometimes I need to customize a list form, e.g. when some fields should not be displayed when adding an item, but they should be displayed when editing an item. In those cases I open SharePoint Designer, and I search the form that needs customisation. I hide the original (default) form, and I add a customized list form and delete the fields that I don't need in that form. It also happens that afterwards I need to add a new column to the list, that should also be displayed in the customized form. On default forms, this field will be added automatically, but not in customized forms. Currently I just go to the code view, and type in the code myself, with the correct internalfieldnames etc. Is there an easier way to do this, e.g. with some kind of wizard to add a list column to the customized form that will generate the correct code automatically for me ? That would be easier than thinking of unique field ids every time (I use date/time for that now, but it gives large ids...). Thanks in advance!

Custom List with Infopath Forms

Hi, In a Site Definition I would like to include a few List Definitions.For these lists I would like to replace the standard NewForm.aspx, DispForm.aspx etc. with Infopath forms.Can you guide me to some walkthrough or some example sources?Thank you,JC

import data from infopath xml forms to SharePoint list

Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint

Can we managed code for a list using InfoPath forms?


Is possible to add manage code to Infopath LIST forms. We want to validate data that goes beyond what InfoPath can do out of  the box.

cascading drop down list in infopath forms services Using SharePoint Look up list from multiple Sh



Some one can help me, if possible screen shots.
Environment : MOSS 2007, InfoPath 2007

Creating new List Item with Lookup, Owner and DateTime fields WebService



I've created a function that creates a List Item, given a bunch of values (Using the WebService). This works fine when I try to populate plain text fiels. But in the list item there are a few picklists and an owner field. When I try to populate these, I get no error but the new record is not created:

      //batch.SetAttribute("OnError", "Continue");
      batch.SetAttribute("ListVersion", "1");
      batch.SetAttribute("ViewName", "");

      batch.InnerXml =
        "<Method ID='1' Cmd='New'>" +
        " <Field Name='ID'>New</Field>" +
        " <Field Name='Title'>" + title + "</Field>" +
        " <Field Name='Owner'>" + owner + "</Field>" +
        " <Field Name='Status'

Using Infopath 2010 to customize a SharePoint 2010 list with columns using Managed Metadata


Hello All-

I would like to customize the "new" form on a SharePoint list that has some columns that use managed metadata term sets as options.  Unfortunately, when I do so, I get the message:

"InfoPath cannot generate a form template for the SharePoint list."

The following fields in the SHarePoint list are not supported because of their data type and will not be available in InfoPath Designer:

-MyColumnName (TaxonomyFieldTypeMulti)

This error message seems to be pretty self explanatory, but it boggles my mind that this would be the case.  Can I really not customize my list "new" form in Infopath if I am using columns with managed metadata?  Any workarounds?

Customizing SharePoint List Forms in InfoPath 2010

Learn how to customize the forms for viewing and editing items in a SharePoint list with the InfoPath Designer, and then take the forms offline using SharePoint Workspace.

Sample: Customizing SharePoint List Forms in InfoPath 2010

Explore the code sample as you learn to customize the forms for viewing and editing items in a SharePoint list with the InfoPath Designer, and then take the forms offline using SharePoint Workspace.

INFOPATH: how can I calculate hours between 2 date fields in a list form


I am trying to calculate the number of hours between 2 date/time fields in a list form.

If I do this on a list view level with a calculated column, the column is not available for column summaries. Therefor I intend to use a regular number column and calculate the hours in an InfoPath form. Obviously the formula for calculated fields in list columns will not work in InfoPath.

Addition: I tried DateField1-DateField2, but the result is NaN...




How to Customize the Add Comment 'Items on this list require content approval...' notification in


WSS 3.0:

If content approval is turned on, the Add Comment section displays a fairly ugly notification. Is there any way I can customize that section through e.g. CSS or SPDesigner?

I'd like to change at least the text, and preferably the yellow exclamation image, and also the background if possible.

Populating a list box in InfoPath from a sql stored proc


I have an InfoPath web enabled form that gets published to a SharePoint site.  I need to add a list box to the form that gets populated with data returned from an existing call to a SQL Stored Proc.  

As the form works now, the user types in a patient id #, then clicks a button that calls the Stored Proc and returns any patients that match the given patient ID.  This part works.  

My task is to add a list box so that if more than one patient is returned , display the list box with all of these patients populated in it.

I am hoping to do this within the confines of the existing code.  The existing code looks like this:

private bool LoadPatientInformationFromDB(string patientId, string patientFirstName,
      string patientLastName, string patientMiddleInitial, string birthDate, string gender,
        string admitDate, string location)
      bool completed = false;
      //Load from DB
      SqlConnection conn = new SqlConnection(GetOrderSetDBConnectionString()); 
      //Create Form Builder
      formBuilder = new FormBuilder();
      SqlDataAdapter adpt = null;
        if (!String.IsNullOrEmpty(patientId) || !String.IsNullOrEmpty(patientFirstName) ||
          !String.IsNullOrEmpty(patientLastName) || !String.IsNullOrEmpty(patientMiddleInitial)
          || !St

calculate fields in a list



how do I go about generating formulas for something like this.

I have a field( choice ) that has three choices (Low, Medium and High ). If I choose Low, I need to add 5 days to the current date( excluding weekends ) and place it in the Target date field, the same goes for Medium = 3 days( exclude weekends) , High = 1 day, exclude weekends.



Need to pass parameters from URL to fields in Custom List


I have a complex customized list and I need to pass parameters of two fields so that when the 'Questionnaire' is completed and subsequentially opened after initial submission, it will retrieve the Number and GUID automatically in respective fields. I send an email out with a link to the 'Form' that carries the parameters. I am trying to use the following javaScript but am unsure as to where to place this on the SharePoint page for it to work.



<script type="text/javascript">

function loadFormVars()
getQuerystring('CustodianGUID', 'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_ff46_1'); ///replace
customerGUID and form field name
'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_FormField11_ctl00_ctl00_TextField'); ///replace customerGUID
and form field name

alert("it works");

function getQuerystring(key, field)
key = key.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");
var qs = regex.exec(window.location.href);
document.getElementById(field).value = qs[1];


When editing a list item the fields are not blank.


This is a recent issue that I have in which I have a "Issue Tracking" List that maintains the workflow of contract renewals.

When an person goes to edit an existing list entry, the description field (standard) has the original text in the box. Prior to this the original - or any older text from a prior change was listed outside and just below the box - and non editable.

That's not the case anylonger.

Any thoughts?



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