Reference ID reset by day

 
1
0
-1

Hi 

I have created an Reference ID with ID Generator field and it is work. However, I want to change it so that the counter reset by day.


For example on 2nd November, there were 36 forms submitted. so the reference ID is up to 0211-2021-CMR-000036. Tomorrow, when another form is submitted, the reference ID should reset to 0311-2021-CMR-000001. But instead in my case, it just continues to 37, 38 and so on. This could be due to me using a counter. I read previously that I need to use HASH variable, but I am not sure how.

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      You need to reset the value of the "counter" variable every day. Maybe through a process that executes everyday and run a beenshell or something to reset the value to 0 or 1

        CommentAdd your comment...
      1.  
        1
        0
        -1

        In "environment variable name", set it to "counter#date.ddMM-yyyy#"

        Meaning, every new day, it will use new variable and it starts with 0.

        1. Danial Jefri

          Hi

          Regarding your answer, Joget does not accept symbol either than underscore in their env. var. name.

          Thank you for replying to my post.

        2. Bastiana

          Go to adv tools > json defintion

          Set it directly into the property.

        CommentAdd your comment...