auto generate quote number "td" <tx2[ at ]hotmail.com> 11/24/2008 9:51:33 PM I am new to InfoPath. I have been asked to create a sales form. I have the entire form created but need to find a way to auto generate a quote number field. I will be publishing this form to a sharepoint server and I also have a SQL 2005 server that I would like to submit the forms to once a user clicks on a submit button. I am hoping someone can help me find a way to auto generate the quote number and then make it so that if the quote is opened in the future that they quote number can't be edited. ~Thomas

RE: auto generate quote number Anuma(GGK Tech) 11/25/2008 3:26:01 AM Hi, Verify this link: http://www.bizsupportonline.net/browserforms/autonumber-infopath-form-submitted-sharepoint-library.htm -- Anuma Reddy http://www.GGKtech.com "td" wrote: [Quoted Text] > I am new to InfoPath. I have been asked to create a sales form. I have the > entire form created but need to find a way to auto generate a quote number > field. I will be publishing this form to a sharepoint server and I also have > a SQL 2005 server that I would like to submit the forms to once a user > clicks on a submit button. I am hoping someone can help me find a way to > auto generate the quote number and then make it so that if the quote is > opened in the future that they quote number can't be edited. > > ~Thomas > >

RE: auto generate quote number Sandhya 11/25/2008 3:39:00 AM Hi, Can you go through the below it describes How to Create an Auto-Number Field in InfoPath http://radio.weblogs.com/0131777/stories/2004/02/22/howToCreateAnAutonumberField.html -- Thanks, Sandhya "td" wrote: [Quoted Text] > I am new to InfoPath. I have been asked to create a sales form. I have the > entire form created but need to find a way to auto generate a quote number > field. I will be publishing this form to a sharepoint server and I also have > a SQL 2005 server that I would like to submit the forms to once a user > clicks on a submit button. I am hoping someone can help me find a way to > auto generate the quote number and then make it so that if the quote is > opened in the future that they quote number can't be edited. > > ~Thomas > >

RE: auto generate quote number Swathi (GGK Tech) 11/25/2008 1:02:01 PM Hi, You can use the GetlistItems web method to get the auto generated number given by sharepoint itself. Use the following link to know how to use this method. http://www.infopathdev.com/blogs/agni/archive/2006/05/15/Query-for-Items-in-SharePoint-Form-Library-Using-GetListItems-Web-Method.aspx -- Swathi Porandla http://www.ggktech.com "td" wrote: [Quoted Text] > I am new to InfoPath. I have been asked to create a sales form. I have the > entire form created but need to find a way to auto generate a quote number > field. I will be publishing this form to a sharepoint server and I also have > a SQL 2005 server that I would like to submit the forms to once a user > clicks on a submit button. I am hoping someone can help me find a way to > auto generate the quote number and then make it so that if the quote is > opened in the future that they quote number can't be edited. > > ~Thomas > >

Re: auto generate quote number "td" <tx2[ at ]hotmail.com> 11/25/2008 4:45:18 PM Thank you everyone for your help. "td" <tx2[ at ]hotmail.com> wrote in message news:%23pyPe7nTJHA.3932[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] >I am new to InfoPath. I have been asked to create a sales form. I have the >entire form created but need to find a way to auto generate a quote number >field. I will be publishing this form to a sharepoint server and I also >have a SQL 2005 server that I would like to submit the forms to once a user >clicks on a submit button. I am hoping someone can help me find a way to >auto generate the quote number and then make it so that if the quote is >opened in the future that they quote number can't be edited. > > ~Thomas

Re: auto generate quote number Anuma(GGK Tech) 12/31/2008 11:08:06 AM Also verify below link.. http://bladah.com/?p=51 -- Anuma Reddy http://www.GGKtech.com "td" wrote: [Quoted Text] > Thank you everyone for your help. > > "td" <tx2[ at ]hotmail.com> wrote in message > news:%23pyPe7nTJHA.3932[ at ]TK2MSFTNGP02.phx.gbl... > >I am new to InfoPath. I have been asked to create a sales form. I have the > >entire form created but need to find a way to auto generate a quote number > >field. I will be publishing this form to a sharepoint server and I also > >have a SQL 2005 server that I would like to submit the forms to once a user > >clicks on a submit button. I am hoping someone can help me find a way to > >auto generate the quote number and then make it so that if the quote is > >opened in the future that they quote number can't be edited. > > > > ~Thomas > >