Expression for radom number

[vacina_nesf]

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

[Lavanya]

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

Refer this URL for more information

help.appsheet.com

UNIQUEID()

Pseudo-unique ID

[vacina_nesf]

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

[VOLODYMYR_TYROL]

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

[Lavanya]

Kindly refer this URL:

help.appsheet.com

Sequential Keys

A technical rationale for why AppSheet can't support sequential keys.

[Steve]

Also reference:

Serial Numbers, If You Must Tips & Tricks 💡

Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …

[Steve · Accepted solution]

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()))
)

[vacina_nesf]

You are the best thanks

[vacina_nesf]

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

[vacina_nesf]

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