Knowledge Base

How to regenerate document number after properties changes in a SharePoint document library?

With Document Number Generator you can create numbering schemes to identify or classify any document. After applying the numbering scheme to the document library, you might make changes to item properties. Document Number Generator provides a Regenerate feature to regenerate/update the field on which the numbering scheme applies automatically whenever document properties are edited, saved and checked in. In this article we will focus on how to create a numbering scheme which will regenerate the document number after property changes.

WHAT YOU'LL GET

The Title field of Document “Bulk Properties Editor Brochure” has been regenerated automatically after its Review Date edited.

WHAT YOU'LL NEED

The sample data we use for this case

Create a document library named as Product Brochures from the Document Library template on your SharePoint site with columns as following. You can create the document library based on your needs. Here we have Name, Review Date (a “Date and Time” column, the “Date and Time Format” is “Date Only”, the “Display Format” is “Standard” and the “Default value” for Review Date is “Today’s Date”), Version, Content Type and Title columns in Product Brochures. And we have uploaded 4 PDF documents with the Content Type of Document in the document library.

Regenerate document number after properties changes

  1. Download the trial version of Document Number Generator, and install it to your SharePoint server.

  2. Navigate to the Product Brochures library prepared above.

  3. Click LIBRARY on the ribbon, and then click Library Settings in the Settings group.

  4. On the Library Setting’s page, click Document Number Generator Settings (Powered by BoostSolutions) under General Settings.

  5. Then, you will be redirected to the Document Number Generator Settings’ page. Here you can add new document numbering schemes. Click Add New Scheme to add a new scheme for Product Brochures.

  6. Then, the Create Document Numbering Scheme dialog will pop up as following. There are 5 sections on the Create Document Numbering Scheme page.

    Scheme Name: a required section, you must enter a unique name for this scheme.

    Content Type: a required section, it consists of two parts. Select a content type and Which field should use the scheme through which you can specify which document type in this document library should use the scheme if there are more than one content types in the document library and to which column/field the scheme should apply.

    Formula: a required section, in this section, you can build the formula for this scheme by using Add element to add a combination of variable and separator and use Remove element to remove it. In the Formula Preview field, you can preview the formula you are building. Click Select a field… to add the first element, then select the Separator by clicking the drop-down menu right next to the Select a field… to insert a separator between the first and the second element (for the separator, we support 5 separators, they are “-“, “_”, “.”, “/” and “\”), then you can click Add element to add another variable to the formula if needed, the separator between variables will be generated with the new added element along automatically.

    Date Format: an optional section, it is useful in case you add at least one Date and Time typed field in the formula, you can specify the Display Format of the Date and Time typed field in the formula. The default value is Default SharePoint Format.

    Regenerate: an optional section, you can specify if document numbers are regenerated whenever document properties are edited, saved and checked in. It is checked by default.

  7. Now, let’s configure the new creating numbering scheme as following:

    First, let’s input a unique name for the scheme, here we name the scheme as Naming Rule for the Product Brochures.

    In the Content Type section, select Document for Select a content type, and select Title for Which field should use the scheme, the scheme we are creating will work on the Title field for documents with the Content Type of Document.

  8. In the Formula section, let’s configure the naming formula itself. First, click Select a field… to select the first variable for the formula from the drop-down list. Here we select the Name field.

    Then, let’s click the drop-down menu right next to the Name field to add a separator between the first and the second element, here we select the separator “_”, as you can see, in the Preview Formula field, you can preview what you have built in real time.

    Then, let’s click Add element to add another variable to the formula, this time we select the Review Date field.

    Now, select the separator again, this time we select the separator”/”.

    Finally, let’s click Add element again to add the last variable to the formula, this time we select the Version field.

    In the Formula Preview field, you can preview the formula we are working on as shown below.

  9. For Date Format section, we just added the Review Date field (a Date and Time field) to the formula, here let’s select MMM dd yyyy as the Date Format.

    In Regenerate section we specify if the numbers are regenerated in case document property changes. Let’s keep it as default, checked. Then the document number will be updated whenever document properties are edited, saved and checked in. Click OK to save the new created numbering scheme.

  10. Then, you will see the new created scheme has been listed on the Document Number Generator Setting’s page as shown below.

  11. Now let’s navigate to Product Brochures. As you can see the Title value has not been changed according to the numbering scheme we just created. That’s because we didn’t Apply it to the document library. We have to apply the new created numbering scheme to the document library if the documents are already existed in the library when we built the numbering scheme.

  12. Let’s go back to the Document Number Generator Setting’s page again, then click Apply of Naming Rule for the Product Brochures to apply it to Product Brochures.

    After clicking Apply, the notification will pop up to notify you that the operation will overwrite the Title field with specific scheme for all items. Click OK.

    After a short loading process, you will see the appear on the right of the Apply button, indicating that the scheme has been applied to the document library.

  13. Now, let’s navigate to the Product Brochures again, you will find that the value of the Title field has been updated to the numbering scheme accordingly.

  14. Now, let’s edit the Document “Bulk Properties Editor Brochure” to change its Review Date to 8/20/2018.

  15. Then, you will find that the Title field for the Document “Bulk Properties Editor Brochure” has been regenerated automatically to Bulk Properties Editor Brochure _Aug-20-2018/3.0. That’s how Regenerate works.

Login