.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

Submtting Calendar items with variable date information via InfoPath 2007 form

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint


I've seen several posts regarding submitting to a list using and InfoPath form which I am successfully able to do in limited form. (only passing a basic date value) My environment: MOSS 2007 Enterprise w/SP2, InfoPath 2007, SPD 2007.

I'm basically trying to recreate a calendar form with the same data elements (and some additional ones for a specific business requirement) as the standard calendar newform.aspx form. (start time, end time broken down by date, hour, minute and All day event)

I need the form users to be able to select the date and if it is not an All day event...be able to select the hours and minutes just like on the newform.aspx. (date picker control for date and drop downs for hour and minute selection)

On submit I then need to create the list item with the appropriate data passed via a workflow.

My Start Time has a validation rule to not allow dates prior to the current date (and it can't blank) The End Time has a validation rule to not allow dates prior to what is specified as the Start Time value. (Also can't be blank) When I attempt to include conditonal formatting to hide the hour and minute drop downs if 'All Day Event' is selected I get errors stating the fields can't be blank.

I also can't figure out how to pass the entire date/time values or the All Day Event to the list withou

View Complete Post

More Related Resource Links

Unable to get AD profile information using InfoPath form in Sharepoint 2007 browser mode


I have followed the threads on this but haven't been able to resolve the issue with any of the suggestions provided.  I need to get the user's first and last name from their profile.  I created an InfoPath form using the "Get current user without writing code" blog directions I ran across here, using the standard userprofileservice.asmx service.  Everything works fine so long as I don't use the SharePoint browser option.  Then I get the error:

An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.

Log ID:5566

I have attacked this from every angle I can think of:

IE, Design checker - OK, SSP account, my account have AD read access, no problems getting to the site collection, as stated before, runs fine if I don't use the browser option

Converted the connection to a udcx stored in the same site as the form library - tried both converted and unconverted connection - same problem, removed the connection altogether, everything works fine (but, of course, no profile info), works under InfoPath using either connection

Set form with Domain trust

Published it to a form library, also tried admin approved with full trust and signed - same problem

Ran locally on SharePoint server and remotely - same problem


InfoPath 2007: Designing Form Templates With The New Features Of InfoPath


InfoPath 2007 is an XML forms designer and editor, and a fully featured and integrated member of the Office family. This article takes a sneak peek at some of its new features.

Scott Roberts and Hagen Green

MSDN Magazine August 2006

How to set rule only on form validation success InfoPath 2007



I'm a newbie to InfoPath 2007. I am creating a from without code. Is there a way to set a Rule to the Submit Button which will be triggered only in the case of Form validation success ? can we make use of the "Set condition" to setup a expression  in the Rule, for this purpose. Still i have no idea how to come up with an expression for such purpose. Can someone please explain.

Infopath 2007 print view in browser enabled form with Print button


Hi i create a  print view brower enabled form in Infopath 2007 with header and footer. In Infopath works fine. Margin was ok, header and footter to. But then i try to print this browser the margin, header and footer it changes to default setting of browser ? I try also create a print button in form with VS 2008 code, but method :

this.print(); not working.

It is possible to print the "print view" in browser as the same like in Infopath 2007? Does anyone have the code how to create a print button in C# on browser enabled form?

Issue in Infopath 2007 browser form - cascading dropdown using owssvr.dll filter view


Referring the below link, I created a cascading dropdown. The parent dropdown has sharepoint list as datasource and the child dropdown has xml datasource that points to owssvr.dll filter view. The cascading drop down works fine in preview but throws error after publishing as admin approved form - "form cannot run the specified query" exception when trying to execute xml datasource i.e., when a value is selected in parent dropdown. The security is 'Full Trust". In the event viewer the error message states "401 unauthorised" for the user a/c. the xml data source is an approved udcx file and in central admin, have enabled cross domain for infopath service. I have tried different solution provided in tech forums but issue still exists. Not sure whether Im missing something. Can someone guide me in fixing this issue?

Link Reffered:



wss2.0 Infopath 2007 'This form requires connections to data sources when it is loaded. At least on


Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?

Deploying InfoPath 2007 form to WSS 3.0 as browser enabled


Please Help! I've created an Infopath form and wanted to deploy the form as browser enabled to WSS 3.0? What are the different options I can do this? If i cannot use a form then i would like to  create a custom list with all the form fields but the user should be able to enter information in the list and he should see only the information related to him. I don't want to give access of the whole list to each and every user. Only the administrator should be able to see the whole list. The form was actually a user access request form.

Any help and suggestions is appreciated.


Best way to Deploy InfoPath form with connection information and managed code

Hi, Whats the best way to deploy an InfoPath form with connection information and managed code. Is there way I can create a deployment package for this? Thanks in advance, San

How to prevent automatic update from sharepoint list on Infopath 2007 form

Hi there, I've got an Infopath 2007 form on MOSS 2007. I have a custom list in sharepoint and the infopath form has a data connection to that list to receive data. Is there any way to prevent automatic update on the values in the form that is received from the list. I'd like the new form to have updated info received from the list. However, the old/existing forms that were created should have the data that were available at the time when the form was created. Let me know if this is not clear and I'll try to explain more. Thanks,Pman http://www.pmansLab.com/

The URL is not valid error while publishing InfoPath form to MOSS 2007 server

Hi All,   When I try to publish the form onto a SharePoint Team site it throws the error: The following URL is not valid : http://tcs037288:6543/sites/projectmanagement   I have checked the comaptibility, trust and everything looks fine. Also, I tried to upload this template from Central Admin but there it is failing with browser-compatibility errors.       Regards,

Sharepoint Designer 2007 Variable Data on a form

I am a lifetime COBOL programmer trying to make a new career in a Sharepoint world. I am working on a project where I have created a list of Employees.  Almost all of the employees on the list must update their status on a day-to-day basis. A view was created on this list using [ME] as the search criteria to only return the employee who is updating his own info. With Sharepoint Designer 2007 I created a custom form. I cut and pasted the code for the view that I described above and then created a series of buttons to allow the employee to choose a status. For each button, I built a workflow to do the specific updates to the employee's list line. I was able to set up an onclick event for each button to execute a Javascript function that would go to the webpage and start the workflow.  I got the actual workflow URLs from the Sharepoint Intranet webpage after I completed each one. Here is my problem (and it is probably my inexperience that has got me stumped); The URL that is fed to the Javascript function has a hard-coded number representing the ID field of the Employee list (that is what probably sets the "Current Item" in the workflow.  I can see that the listview from above the buttons has the ID field as one of its Fieldrefs.  How can I substitute some kind of ID variable in the set of parameters that is fed to the Javascript? 

InfoPath 2007 - Publishing Creates multiple columns on SharePoint Form Library (GUIDS apparently are

I have been working this issue for 2 days now.  This has happened to me in the past and I was able to work through it.  It doesn't appear that this time I am going to be so lucky. Issue Description: When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created. Troubleshooting steps: I have read this article: http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx   This was the solution the last time I had this problem.  However, no matter what I do, it is not working now.  I have a column named User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow.  When the workflow kicks off, it reads this column and attempts to get the value.  The value is blank because a new column with the name User Name now exists and that is where the value is stored.  I attempted to fix it by remapping the GUIDs as described in the article.  I also reverted the code to a previous version from TFS.  None of these worked.   I now have 3 columns called User Name and I can remap the GUID to the second column and third column.  But when I try to map it to the first column (the one I need) it doesn't work. The first column that is circled is the correct column. 

Infopath 2007: Cant we fetch data from a list or form library without using a Query to the data conn

I am trying to fetch data from a form library and a list (both secondary data sources). But cant do it without using a rule (Query using a data connection). However when I use the 'Refresh' control on the form it brings the value. I find it quite weird, as the connections are made properly and logically speaking all the data connetions should fetch dynamic data once the form opens or loads. Cant we do it without using a (data query) rule? Update: I am using a web based infopath forms, while using the same form on client its working fine. Why is that?

Add a New Item to a Custom Sharepoint List and Sharepoint Calendar from one Infopath form.


I am trying to create an infopath form for requesting time off.  Once the request is approved I want the form to add the event to a calendar on sharepoint.  I was able to do this using the article by S.Y.M. Wong-A-Ton at http://www.bizsupportonline.net/infopath2007/programmatically-add-item-sharepoint-calendar-infopath.htm.  But I want the form to also add an item to a custom list that has the employees available time off stored on it.  That way the form can automatically subtract the time entered on the infopath form from what is available on the custom list.  I was able to do this using another article by S.Y.M. Wong-A-Ton at  http://www.bizsupportonline.net/infopath2007/programmatically-add-rich-text-item-sharepoint-list-infopath.htm.  I can make both of these functions happen seperately but I need them to happen on the same Infopath form.  I am using Infopath and MOSS 2007.  I have tried to use 2 CAML receive data files and I treid to co

Commit Variable from SharePoint Designer 2010 to an InfoPath Form 2010


I saved a string into a SP Workflow 2010 variable, and want to pass this variable to an InfoPath 2010 Form, so that I can display/use this string in the Form.
Please tell me how to commit that.

Thank you in adnavce!

Kind regards,
Milan Stojadinovic

Email InfoPath form located on secure SharePoint 2007 using Outlook


I have a 2007 InfoPath form that is stored on a secure 2007 SharePoint team site that needs to be emailed to outside users for feedback on a certain subject. The form is opened by a team member (with site access), sent to the reviewer to provide feedback (via Outlook 2007), and then submitted back to the team member for review and submission to the SharePoint site.

The issue I've encountered is that the outside user who receives the form in Outlook as the body of the email cannot enter information in any fields in order to provide feedback. The option to "include the form template with the email" is blocked in my InfoPath form options (I believe because the form location is a secured site). I have tried adding the users to permissions in just the library where the form is published to, but they still cannot enter any information.

Can someone provide me with a solution for this problem?

Captcha in Infopath Form 2007

is there way to generate the Captcha control on browser enabled infopath form 2007.
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