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


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

Auto generate a number in a text box in Infopath Form

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

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


View Complete Post


More Related Resource Links

Infopath browser form - odd behaviour on auto expanding multi line text boxes

  

Hi,

 

I have a browser form with a multi line text box. The height is set to be AUTO. Within the client all is fine. When opened as an administrator approved form the text box automatically adds a new line for every 20 characters you type.

 

So if you type 40 characters without pressing enter you get 2 blank lines appear under you text that you CANNOT remove.

 

I have tested this on a new form with various multi line text boxes. The width setting is unimportant, the spell check setting is unimportant.

 

If i fix the height then the issue goes away but this is not any good.

 

I cannot use rich text boxes as i have around 40 text boxes on the form and if they are rich text they take around 10 minutes to load in the browser (this is another issue i have)

 

Thanks in advance

 

Paul


Create an Infopath form to generate unique number MOSS 2007

  

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.


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

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.

Can't paste text into an Infopath form and see it with print preview

  
I have a user who says that they can't view any of their text that they cut and paste into the fields of a form when they choose Print Preview, in the forms library.  They're using IE8 to access the SharePoint site. When I access the same form in the same library from any browser from my computer, I can view pasted text in any field when I click Print Preview. Anyone see this before and can help me?? Thanks!    

Infopath cannot generate a form template for the sharepoint list

  

Dear All,

For Sharepoint 2010, Infopath 2010

When I trying to login Infopath by link Customize Form that available in the List tool bar I found the following error:

Infopath cannot generate a form template for the sharepoint list

The SOAP response indicates that an error occurred on the server

Can anybody help me figure out what is causing this error?


auto-populate infopath form with sql server data connection

  

Hi,

is it possible to auto-populate an infopath form with a sql data connection?

i have a form that only populate the username of the logged in user. but i want to use a secondary data source to auto-populate the user his email, id and department all comming from a sql server database.

and after that auto-populate the user's manager name using sql server db

is this possible in infopath 2007 and how can i do this?


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

 


Infopath 2007 Repeating Sharepoint List Sort Auto Number

  

Infopath 2007
Browser Enabled
Sharepoint List in a Repeating table

I have a view with a Sharepoint List showing in a repeating table. I have conditional formatting to hide items that should not show based on Line Total.

Line Total = 4

Approver    Min Amount        Max Amount  
Jim                      3                  9
Jack                    1                   7
Sally                   2                    5

Based on this, I need to sort the Approvers based on Max Amount and send an email to them in order of the sort.  Is this possible?


chrisdoran

InfoPath Form and Multi-line Text box

  
Hi,

I'm using a multi-line textbox in my infopath form, the text scorlls when user enter texts that exceed the width/height of the text box, thats fine. But after user submits the form, the textbox just dsiplays one line of text with with "..." at the end and user needs to use "End" key or drag the text using the mouse key to see the remaining text. We want to display all the text that user entered instead of "...". What setting needs to be done in the inforpath forms.

Also I wanted to know if there is any known issue using Rich Text field in Infopath form with SharePoint InfoPath service.

Thanks in advace,
San

how to set whole number(integer) in infopath form

  
I have some whole number(integer) field in infopath form  and need to set these field in task using workflow

but if I select numeric type in custom task wizard and afterwards I can not select this task field when I need to set the whole number(integer) with value I want, strange! !

So how to set whole number(integer) field ??

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


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


Using Infopath form fieldnames in a workflow fails

  

Hi,

I designed a form in Infopath and I published it on a SP2007 server to use in a workflow in a library. That goes fine. In the workflow I send an email message. I can use the fields from my Infopath form in the message that I create. 
If the workfow is starts, Shrepoints sends me the message. But it does not use the fields from my InfoPtah form in the message in stead I see questionmarks.

Why doesn't it show the fields?

I alse saw (maybe this makes it clear) that when I let it dipslay the URL in the message, it show: http://1.portal.lucasonderwijs, but the actual site is whithout the "1" and it should also start with https://

Has anyone seen this before?

Thank you,

Ronald


InfoPath Workflow Task Form "Loading" event handler only being called after App Pool recycled.

  

I have a Workflow that is using an InfoPath task form.  In the "FormEvents_Loading" method event handler I have some code that needs to run each time the form is opened.   I recycle the App Pool and open the form the code runs perfectly, but if I close and try to re-open the form the code is not run at all.  I can then recycle the App Pool again and on the next load the code executes just fine.   The code that is supposed to be run is a very simple statement to set a field value, so I don't think it is interfering.

Does anyone know what this might be?

Thanks,
--Aaron


Problems moving an InfoPath form from a DEV system to QA environment

  

We developed an InfoPath form using a local DEV environment.  The site collection under which the form was developed was http://server1/.

We are now attempting to deploy this form to a TEST environment that uses a slightly different structure for the collection, namely http://server2/sites/sitecol1.

In both cases the site that contains the form is /fin (so we were using http://server1/fin in DEV and want to use http://server2/sites/sitecol1/fin in TEST). 

The form contains VBA code and so requires admin-based deployment via Central Administration, so to deploy to TEST we:

1. Publish the form against the TEST server using InfoPath Designer

2. Upload the form using Central Administration > Application Managment > Manage Form Templates

3. After upload, we activate the form for the site collection http://server2/sites/sitecol1/

4. The form is then associated with a Form Library

When we try to create an instance of the form within this library we get the following error when we click on New to create the form instance:

The following location is not accessible, because it is in a differ

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