Expression for radom number

hi I’m running an app that makes a list of dogs, for the dog ID I need it to be “INCREASING NUMBER/ACTUAL YEAR” like 0001/2021, and i need that for every new year it restarts to 0 again

HI,
Better to use UNIQUEID() in initial value column

Refer this URL for more information

1 Like

i’m using uniqueid but i need a increasing id with a year, and i need that for every new year it restarts to 0 again

It’s just regular id or key column too?
I have the similar idea for key, but have to change it because of if two users create new row(form) at the same time you going to get the same id for both

2 Likes

Kindly refer this URL:

4 Likes

Also reference:

2 Likes

This one’s a challenge! Try this (it’s a long one; you’ll need to scroll to see it all):

CONCATENATE(
  RIGHT(
    CONCATENATE(
      "0000",
      (
        NUMBER(
          ANY(
            TOP(
              SORT(
                SPLIT(
                  SUBSTITUTE(
                    CONCATENATE(
                      SELECT(
                        table[column],
                        ENDSWITH([column], ("/" & YEAR(TODAY())))
                      )
                    ),
                    ("/" & YEAR(TODAY())),
                    ""
                  ),
                  " , "
                ),
                TRUE
              ),
              1
            )
            + LIST("-1")
            - LIST("")
          )
        )
        + 1
      )
    ),
    4
  ),
  ("/" & YEAR(TODAY()))
)
3 Likes

You are the best thanks

1 Like

hi steve i’m getting a problem, it is stuck on 0002 now i don’t know why
Screenshot_13
Screenshot_14

it’s only adding up the first record and not the last