Create a script concatenation Property - M-Files Cloud Vault

Hello Team,

i want to genrate the autamatic numbering of my quote.

for exemple: QUOYYDD0001.

and when a new month start i will the numbering at 1:

e.g : QUO24040001 : First quote in april 2024

        QUO24050001 : First quote in May 2024

Need your assistance...

Parents
  • Compliance Kit's Utilities module has a sequences functionality that can use value list properties to determine when a new sequence is needed. If you can get the month and year into two value list properties somehow then you can use this module to get the monthly sequences.

    In this example Sequence value property is automatically set by the Utilities module with a running number for each month and Quote number is an automatic text property concatenating the month, the year and the sequence value.

    Sequence configuration in Utilities module:

    Quote number concatenation:

    I hope this gives you an idea of how to set it up.

Reply
  • Compliance Kit's Utilities module has a sequences functionality that can use value list properties to determine when a new sequence is needed. If you can get the month and year into two value list properties somehow then you can use this module to get the monthly sequences.

    In this example Sequence value property is automatically set by the Utilities module with a running number for each month and Quote number is an automatic text property concatenating the month, the year and the sequence value.

    Sequence configuration in Utilities module:

    Quote number concatenation:

    I hope this gives you an idea of how to set it up.

Children
No Data