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


Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Sharad
Eminent IT
Post New Web Links

Create an Infopath form to generate unique number MOSS 2007

Posted By:      Posted Date: November 03, 2010    Points: 0   Category :SharePoint
 

I created an infopath form that would auto generate a number to each form from following instructions at the following site.

http://enterprise-solutions.swits.net/browserforms/autonumber-infopath-form-submitted-sharepoint-library.htm

 

 

I am wondering if it is possible to change the starting point of the ID field within sharepoint.  It starts at 1.  I would like it to start at 1000. and add 1 number each time a new infopath form is added. Or would I add a different field to accomplish this.




View Complete Post


More Related Resource Links

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,

how to generate a unique random number on a form submission?

  

I want to generate a unique random number everytime a user submits a form. As the form is submited the data of the form should be placed in a database and a unique random number should be generated so that the user can later use this unique random number to reterieve his details from the database that refer to his unique random id. The unique random number should be atleast 9 digits long. Please help me on this.


Problem with InfoPath 2007 Form opened with InfoPath 2010 - whole number integer not coming into dat

  

I found an issue when testing existing InfoPath 2007 forms via the Infopath 2010 Designer client.  Integer fields in the form template are publishing to a SharePoint Forms Library and show in the default view.  However, if that library is then used as a Data Connection in another or same form template those integer fields are not displaying or available for selection. 

This is not a problem using the InfoPath 2007 client.  It is not an option to convert the field to text as it could affect existing forms in existing libraries.  Also, existing integer fields are no longer appearing in previously defined SharePoint-based secondary data connections.  Only the ID field still appears.  But, those existing fields still work in the form and are selectable for functions, etc.

Is there a solution to this?

Thanks much!  Mike - www.ProgramNetInc.com

 


Auto generate a number in a text box in Infopath Form

  

Hello All,

I have a requirement of generating the auto number in one of the InfoPath form field(text box).I am designing this infopath form for Change Request in the organization.Can anyone help me  in doing it.

I appreciate your response.

 

Thank you,

Smith


smith

Q: How to print out background color in InfoPath 2007 browser form under MOSS form service?

  

Hi InfoPath experts,

I am trying to print out a custom InfoPath 2007 browser form using "Print View" function offered by MOSS Form Service. It seems like the all background color formats has been stripped out when printed out. Interestingly, only font colors are remain the same in printed-out.
Is there a way to fix this issue? I know you can change the settings: http://office.microsoft.com/en-gb/infopath-help/print-background-colors-and-pictures-HP001095710.aspx , but it only applies for InfoPath Client Form, not browser-based Form!

Any help are appreciated!
-Rick


Help creating a unique form number in Infopath

  

I have read the other blog posts about this, and the other users seem to have some success, but I dont' understand HOW they got it to work.

This appears to be the solution, but its not working for me. It just seems to be giving me the time in HHMMSS when I do it: http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/a68b1129-deb3-41a9-a077-c3e8fc3ef86a/

I need to create a unique invoice number based on three parts: Salesperson's initials + date (represented as yymmdd) + a unique number (perhaps the time? but it has to be listed without any formatting, just HHMM)

Ultimately I want the form to have this number going ABYYMMDDHHMM 

Thanks so much


MOSS 2007/InfoPath Form Services Error

  

We are using MOSS 2007 with InfoPath Form Services and receive this error in our event log when trying to submit a form.  We increased the Maximum size of form session state to 16384 and continue to get this error message on large forms.  We are not allowing attachments.  We are running MOSS 2007 version 12.0.0.6335.

Form submission failed. (User: ****, Form Name: NonCredentialed Practitioner AddChange Form, IP: , Request: *****, Form ID: urn:schemas-microsoft-com:office:infopath:NonCredentialed-Practitioner-AddChange-Form:-myXSD-2010-03-15T19-02-04, Type: DataAdapterException, Exception Message: The remote server returned an error: (500) Internal Server Error.

The formatter threw an exception while trying to deserialize the message: Error in deserializing body of request message for operation 'SendRequest'. The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader. Line 134, position 17.

The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuo

How to Create Auto increment Request number for browser enable infopath form field Programmatically?

  
hi all,

i have created an infopath which have one request no. field and it will auto increment when click on add new item on sharepoint Document library

field contains (highest value of column request no. +1 )  when infopath will open in browser.

What i have done on this:i have create new data connection on sharepoint library and then pick document library then choose ID field and insert function in the field max(ID)+1.

help me

thanks

shubham

Can you embed an Infopath 2007 form with MOSS 2007 in an Outlook 2010 email?

  

Hi,

MOSS 2007, Infopath 2007 and Outlook 2010

Is it possible to embed the Infopath Form in the email itself.

I read this link (point 1) http://office.microsoft.com/en-us/infopath/microsoft-office-infopath-2007-top-10-benefits-HA010165024.aspx, but I have been unable to do this?

Do you have to have Infopath 2007 on the client machine to be able to do this?

Thaks.

John. 

 


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


MOSS 2007 : I am looking for tutorial about how tu use infopath 2007 forms and to associate to them

  

Hello,

I am quite new on sharepoint 2007,

i am at the moment looking for tutorial to help to understand better the concept of workflow you can associate with infopath 2007.

I would like to create a  form that the visitor of the website can fill and then submit.

once the form submitted i would like tto be able to store all the date picked up to the database sqlserver 2005 and then to be able to send a email to the administator to be kept inform  of that.

the 2 tutorial i found that i found interested are http://weblog.vb-tech.com/nick/archive/2007/02/25/2207.aspx and the microsoft one o.n the virtual lab.

So what i am looking for is any tutorial which can help me to be understand very well how to use the worklow with infopath or if you have as well some book to advice me for that i would be happy.

Thanks


InfoPath form checked out so 'on create' workflow not being started

  

Hi all,

 

I have found a couple of threads asking for advice on how to check in an InfoPath form when it’s saved or submitted to a forms library. The reason for doing this is so a workflow can start based on a new item being created in that library, and so it doesn’t just sit there with a “Starting” status.

 

The answers I have found contradict each other:

·         You have to do it with a workflow.  This can be done easily with SharePoint Designer if that's an option for you. Source:

Programmatically create an InfoPath form

  

I'm programmatically creating an InfoPath form using this article: http://www.bizsupportonline.net/infopath2007/programmatically-create-infopath-form-console-app.htm.

 

Everything works well up to 29 fields (my:field1 ... my:field29). After that it runs without an error and posts a form to the library however the icon does not switch to an infopath icon and the filename stays blanks. I don't believe this field specific, it seems to be happening when I use any 29 to 30 fields so I'm thinking its a memory issue with the stream reader.

Has anybody every had this issue before, is there a way to fix this?

Thanks


How to set rule only on form validation success InfoPath 2007

  

Hi,

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?


Submtting Calendar items with variable date information via InfoPath 2007 form

  

Hi-

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

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:

http://www.bizsupportonline.net/browserforms/filter-cascade-drop-down-infopath-sharepoint-browser-form-owssvr-dll.htm

http://www.sharepoint-tips.com/2007/01/infopath-form-services-implementing.html


Categories: 
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