Possible to have a counter using Infopath2003 and submitting form to sharepoint? - InfoPath Dev
in

InfoPath Dev

Possible to have a counter using Infopath2003 and submitting form to sharepoint?

Last post 03-14-2013 08:27 PM by Bonz2012. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 03-03-2013 11:37 PM

    Possible to have a counter using Infopath2003 and submitting form to sharepoint?

    Hi,

    Some of my users have 2003.  I do have 2010 but I have to make the form 2003 for now until they all upgrade.

    Right now I am using the "Now" function to title the document and therefore make it unique.  I'd like to be able to use a counter to make it easier to talk about a specific form.  Let's say form 231, instead of form 3-1-2013T12:22.  Is this possible?

  • 03-10-2013 11:38 AM In reply to

    Re: Possible to have a counter using Infopath2003 and submitting form to sharepoint?

    Yes, the best practice is to have a button with a rule that has two submit actions and a query. First submit will submit it with your natural Now() key (also, make sure this value is stored somewhere in your form). Second action is the query - just query the library to get the SharePoint ID assigned to the form that you just submitted. Since you're using InfoPath 2003, you will need to query all rows and filter in the form (or you can use the FilterOwssvr approach to filter out only the one with the Now value that you just saved). Third action sets a field in your form equal to the SharePoint ID value in the secondary data source that you just queried. Finally, submit it again using same name as first time. You can change the columns of the library to make sure the ID appears. The form can also show the ID on the view since you now have it in the form.

    The only downside of this approach is that when the data moves from one site to another, the IDs could change. Make sure you promote the IDs after you migrate to a new site so you can use it as a custom column if they don't match the auto-assigned values.  

    Patrick Halstead
    Project Manager at Qdabra
  • 03-14-2013 08:27 PM In reply to

    Re: Possible to have a counter using Infopath2003 and submitting form to sharepoint?

    Hello Patrick,

    Thanks for the reply.

     

    Forgive me but I am too new at this and need a little clarification.

    How do I query the sharepoint library for the form ID?  The rest I understand... I understand the concept of what you’re telling me to do but not how to get it started.

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