Non-one increment in auto-increment field

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • iioi
    Member
    • Jun 2022
    • 48

    Non-one increment in auto-increment field

    Please, how to make sequence 1,3,5,7,9 in auto-increment field ?
  • yuri
    Member
    • Mar 2014
    • 8442

    #2
    If you have advanced pack.

    1. Create a regular auto-increment field. Name it numberInternal.
    2. Create a regular Integer field. Make it read-only. Name it number.
    3. In a workflow 'update target record' action write a formula script:

    Code:
    number = numberInternal * 2 - 1;
    If you don't have the advanced pack, you can create a Hook, but it requires more coding.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • iioi
      Member
      • Jun 2022
      • 48

      #3
      I've got the idea, thanks

      Comment

      Working...