InfoPath Dev

Hi, I am having a travel request form in which id field is there. it is having a backend database i.e. ms access. when ever the infopath form is opened the id field should generate a new number i.e starting from 1 and on submitting data should be submitted to the access.plz help me on this, how to generate unique ids for each form when ever the form is opened. please help me out. its urgent

Hi Manaswita,

This is a common question. Have you tried searching the forum? In general, here are two options:

1. Double submit. When the new form is submitted, have Access automatically create the ID. Then, requery the ID and set the field in the form. Submit the form again before closing.
2. Create on open. Use some logic in Access to create the ID on open. InfoPath then queries Access to get the ID. Drawback is that blank rows are created when users don't submit the form.

Good luck!

Hi Patrick,

Thanks for replying. I have tried searching in forums but not getting exact answer.can u please help me out?? 

 

Hi Manaswita,

Sorry, but this is more of an Access question than an InfoPath one. If you were using SQL, it's straightforward. Same for SharePoint. We don't support Access in this forum. If you're interested in SQL or SharePoint solutions, we can provide them, but it takes some time. The forum is meant to answer questions. The answer to your question is "yes, you can do it". However, while the forum is free, we can't provide free development here. If you need help, you can donate what you think the fair price is for help. This is a coding question. We have solved it many times before for SQL and SharePoint. It's not so hard. For Access, I'm sure it's the same old story, but you're not an Access developer. We aren't either. So, you could find one, or convert to SQL/SharePoint. We could help with those, but will need some incentive since it's just not a forum answer. No, it's called work. It's some amount of work to do it. It's not meant for a forum answer. We can do the work, but it takes some time. Maybe 60 minutes or so.... sorry....

Hi,

 Can u tell me how to generate sequential id in infopath. i.e whenever an infopath form is opened it should generate a new id.

If there's only one person using Access, you could just have an Open rule that looks up the last ID in your Access DB and increments it. However, if you have more than one user, you can't do it sequentially on the client because multiple people could open or submit at the same time and that would create duplicate IDs. The only client solution here is to use Global Unique IDs (GUIDs) but that requires code. We have a free download called qRules that supports creating GUIDs using rules (no code required). However, GUIDs aren't sequential. They are unique however.