InfoPath Dev

Hi Matt, I have just been using a drop down for number which then completes the name field and the users seem happy enough so I will probably leave it as it is... Thanks for the offer to help though!

Hi, I want to show two columns - unique number and name within the same drop down list. On my list in SharePoint I have created a column which has ''number, name'' but when I go to create a datasource in infopath to this list, the column which is a calculated column (''number, name'') is not listed as one I can select. Can anyone ...

I know that if this were sql I would be trying to write: SELECT fname FROM [previous form] LEFT JOIN [this form] ON [previous form].[fname] = [this form].[fname] WHERE ((([this form].fname) Is Null)); Can anyone tell me how to get this working in infopath? Thanks Clare

Hi, I am also trying to do this. I want to show two columns - unique number and name within the same drop down list. On my list in SharePoint I have created a column which has ''number, name'' but when I go to create a datasource in infopath to this list, the column which is a calculated column (''number, name'') is not listed as one I can ...

Thanks for your help. Please could you clarify this a bit more. I have a data connection to form one. I have another data connection to form 2. In the drop down list on form 2, I have the data source as form one. I then select name from form one as the entries. It is possible to filter here. What should the filter be? I have tried filter where ...

I think this is because I have other fields on the same form which I do not want submitted. Is it possible to submit only specified fields? Thanks

Thanks for that, almost works. But when I press submit I get an error: The SOAP response indicates that an error occurred on the server: Exception of type Microsoft.SharePoint.SoapServer.SoapServerException was thrown. <detail> <errorstring xmlns=''http://schemas.microsoft.com/sharepoint/soap/''>The parameter is ...

Hi, I am not really sure if that is the correct thing, let me explain a bit further. Form one is completed for a specific name (person) Only if form one is completed by person X can form two be completed by person X. Only if form two has not already been completed by person X can it be completed by person X. Cannot have 2 forms for same ...

Hiya, I am selecting data from a SharePoint form library(1) to appear in the drop down list of a form on another library (2). This is working fine, however I want to introduce the following. Data should only appear in the dropdown list of form 2 if it appears in form 1, and does not appear already in form 2. This looks to me like an outer join ...

Hi, I have a form which contains many different text fields. At the bottom of the form is a button. When this button is pressed I would like to be able to select the data from certain fields in the form and send this to a SharePoint list. I can see how to send ALL the information to a SharePoint document library but not how to select certain ...