Updating a secondary data source - InfoPath Dev
in

InfoPath Dev

Updating a secondary data source

Last post 08-03-2012 01:32 PM by Anson Hidajat. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 08-02-2012 02:44 PM

    • fnork
    • Not Ranked
    • Joined on 05-14-2010
    • Posts 5

    Updating a secondary data source

    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).

  • 08-03-2012 09:28 AM In reply to

    Re: Updating a secondary data source

    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.
    Anson Hidajat
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 08-03-2012 01:27 PM In reply to

    • fnork
    • Not Ranked
    • Joined on 05-14-2010
    • Posts 5

    Re: Updating a secondary data source

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

  • 08-03-2012 01:32 PM In reply to

    Re: Updating a secondary data source

    Glad to hear you were already considering going down that path.  Good luck!
    Anson Hidajat
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.