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
Solved! Go to 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()))
)
HI,
Better to use UNIQUEID() in initial value column
Refer this URL for more information
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
Kindly refer this URL:
Also reference:
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()))
)
You are the best thanks
hi steve i’m getting a problem, it is stuck on 0002 now i don’t know why
it’s only adding up the first record and not the last
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |