Thu, 24 Sep 2026
Login

How to reset ID Generator Field Counter Annually

Confluence User - 04 Sep, 2017

Hi

 

Similar to what listenwell asked earlier this year in

ID Generator Field Counter change by year

 

Is there a way to reset the ID generator environment variable back to 0 when a year changes from 2017->2018.

2017|0017 

2018|0001

Is there a way to update the counter environment variable through Joget itself or would I need to use a database update tool or other tools to perform this action.

I have no problems changing the year, I only need to reset the counter every new year.

Thanks

 

forms;plugins;database

4

Confluence User •
05 Sep, 2017 •
confluenceUser •
•
confluenceUser •

i think you can use date hash variable in "Environment Variable Name" eg. "counter_#date.yyyy#". So, in each year a new Environment Variable is used to generate the id like following.

counter_2017, counter_2018, counter_2019 & so on.

Confluence User •
14 Sep, 2017 •
confluenceUser •
•
confluenceUser •

The year is not the problem, I'm looking on a way to reset my counter to 0 after every year. As the rolling number will just keep continuing after from 2017->2018

Confluence User •
18 Oct, 2017 •
confluenceUser •
•
confluenceUser •

Once the year changes, the counter will be reset because it is essentially using a different env variable name.

Confluence User •
16 Dec, 2021 •
confluenceUser •
•
confluenceUser •

Hi panda


I tried implement your method, however I cannot create the environment Variable Name with '#'. I am using version DX7 Enterprise Trial.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
How can I set dedicated datasource for each app ?
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Plugin for PDF Editor
Retrieve image upload from form into PDF
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print