in

InfoPath Dev

Create Unique ID w/o a lot of programming

Last post 10-28-2008 05:32 PM by bladah29. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 11-09-2007 07:41 AM

    • proud2
    • Not Ranked
    • Joined on 11-09-2007
    • Posts 2

    Create Unique ID w/o a lot of programming

    I've created a form for our group that will create a service request.  I'd like the form to auto generate a unique ID (Service Request #).  I've seen some posts but I don't exactly understand how they are doing this.  I am not a developer, and would like to be able to show that simple requests like this can be handled by non-development staff.

  • 11-09-2007 07:58 AM In reply to

    Re: Create Unique ID w/o a lot of programming

    It is not hard if you have the right to tools.

    Are you using SQL to capture this data?  SQL can automatically create your IDs.This is always best since they are created upon save and therefore you have no worry of duplication.

    Qdabra Database Accelerator Suite Version 2.1 - Developer

    To create it within your form is problematic, since whatever method you use to create a unique number can be happening in another user's form at the same time.  There are ways to lower the chance of duplication but there are always going to be uniqueness issues.

    Filed under:
  • 11-09-2007 08:06 AM In reply to

    • proud2
    • Not Ranked
    • Joined on 11-09-2007
    • Posts 2

    Re: Create Unique ID w/o a lot of programming

    No SQL, just InfoPath and SharePoint.

  • 11-10-2007 01:43 PM In reply to

    Re: Create Unique ID w/o a lot of programming

    Are you trying to create a unique ID for the form or within a repeating node? Sharepoint assigned a unique ID to every form that has been submitted and you can make that visible in a view. If you are trying to uniquely number nodes you can count the preceeding siblings in a function like this:

    count(../preceding-sibling::my:elementName) + 1

     

  • 10-28-2008 05:32 PM In reply to

    Re: Create Unique ID w/o a lot of programming

    Here's the easiest way that I've used:

     http://bladah.com/?p=51

    This will allow you to auto-generate a unique ID when the form is submitted to the library and allow you to edit them at a later time without re-submitting the form. Hope this helps.

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