Custom Table ID From yyyymmdd<txncode><sequence>

 
1
0
-1

hi, have been 3 month thinkering with joget. now i want to use custom table id using specified format rather than uuid. 

format as below 

<yyyymmdd><txncode><sequence>


example : <20190804><1001001><000001>  = 201908041001001000001


yyyymmdd - current date

txncode - transaction code

sequence - seq number (read from environment variable) 


how to achieve this ? or any idea ? thanks 

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, you could try to use the ID Generator Field in conjunction with some Hash Variables. Found another related question How to reset ID Generator Field Counter Annually.

        CommentAdd your comment...