Data Connections

Re: Updating a secondary data source

Anson Hidajat — Fri, 03 Aug 2012 20:32:29 GMT

Glad to hear you were already considering going down that path. Good luck!

Re: Updating a secondary data source

fnork — Fri, 03 Aug 2012 20:27:32 GMT

You know, I think I was slowly coming to that decision, I just needed to hear it from someone else. Thanks for the confirmation!

Re: Updating a secondary data source

Anson Hidajat — Fri, 03 Aug 2012 16:28:53 GMT

You can have InfoPath submit to a library (lists are a little more complicated) and then promote your counter field. Then in this form, create a secondary data connection to it to retrieve the largest value of the counter field. You could even promote additional fields if you need to be ablt to query that data (eg. username, etc.). You'll need to write some logic in the form to increment that field, but that shouldn't be too difficult.

Updating a secondary data source

fnork — Thu, 02 Aug 2012 21:44:51 GMT

Is it possible for Infopath to update a secondary data source (probably a Sharepoint list) without any extra programming? What I'm trying to accomplish is a number generator a bit more complicated than a simple unique ID. I need to be able to retrieve the next number in a sequence based on certain criteria (like username and other data from the form itself). And ultimately, I would like for Infopath to then increment the number automatically. As it stands right now, all of my users have to manually keep track of the next number in the sequence.

Oh, and everything has to be 2003 compatible (we still have some dinosaurs).