Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Provided Answers: 2

    Unanswered: Renumbering across folders

    Here is a interesting problem or idea. I have maybe 10+ folders. I would like to number the records starting with 1 through what ever across all the folder. Is
    this possible? I have a method but it is quite extreme.


  2. #2
    Join Date
    Oct 2013
    Provided Answers: 2
    Here is how its done.
    [$ck] = 0
    [q] = queRecN(Folder Check All)
    Show Message (There are [$q] Records in database., , Ok)

    Now in the Query (Folder Check All)
    Click image for larger version. 

Name:	v1.jpg 
Views:	11 
Size:	45.6 KB 
ID:	16234

    Now go to the actions and check Execute a script for each record

    enter this code

    Main Sheet: [ID] = [$ck]+1
    [$ck] = [ID] (for Main Sheet)

    of course your form will have another name.
    This will renumber the id's of all records

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts