Auto Populated Report Number Field - InfoPath Dev
in

InfoPath Dev

Auto Populated Report Number Field

Last post 06-13-2011 12:34 PM by jchapin. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-25-2007 04:07 PM

    • mgibson
    • Not Ranked
    • Joined on 01-26-2007
    • USA
    • Posts 1

    Auto Populated Report Number Field

    I am attempting to auto-populate a report number text field based on the number of reports on a given date. The data in the form has to populate a SharePoint list after submission.

    Example of report number= 2006.01.01.1 with the last number representing the actual report number for the date. So, if I have two reports in a given day- the second report number should be 2006.01.01.2
  • 01-25-2007 06:13 PM In reply to

    Re: Auto Populated Report Number Field

    Hi MGibson and welcome to our forum,
    There is a column in SharePoint that keeps the ID. The problem is that you have to wait until the form is submitted to make sure that you are indeed 2 and not 3 (in case someone else submits before you do). I recommend submitting the form on open and then querying the SharePoint list to get the ID and autopopulate the field. That should work.
    Patrick Halstead
    Project Manager at Qdabra
  • 06-13-2011 12:34 PM In reply to

    Re: Auto Populated Report Number Field

    I'm pretty sure that the following link describes how to do this. It may not be exactly what you're looking for, though:

    http://www.bizsupportonline.net/browserforms/autonumber-infopath-form-submitted-sharepoint-library.htm

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