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
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:
[Serial Numbers, If You Must](https://community.appsheet.com/t/serial-numbers-if-you-must/19325) 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 …
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
it’s only adding up the first record and not the last