
Announcements
Hello there!
I'm creating a new table in Dataverse and I want to set the main column as autonumeric.
I want to get this model of sequence:
yyyyMMdd-sequence Example: 20230411-001, 20230411-002, 20230411-003, 20230412-001, 20230413-001
I already try this format: {DATETIMEUTC:yyyyMMdd}-{SEQNUM:3} but I get this...: 20230411-001, 20230411-002, 20230412-003, 20230413-004 the sequence number never reset when it's the next day
Any help is appreciated! 😄
for the sequence you need (reset the number every day) you will need a plugin, the built-in autonumber can't build that kind of sequence.
EDIT: please don't open multiple threads with the same question, you asked this question on 3 different sections of this forum