Question with PurchaseOrder#s

[yuto]

I have a;
• UserNumber field (type text) in my User data type.
• PurchaseOrder# field (type text) in my Order data type.

I want my PurchaseOrder# to be as like; 2308-001

Created date formatted as yy, followed by User Number, followed by “-”, followed by the actual PurchaseOrder# this specific User has submitted the created year.
So that next number should be 2308-002.

How can I achieve this?

[Nobi]

You need to use regex to extract information and then you can store it as you like

[georgecollier]

@yuto

So that next number should be 2308-002

Arbitrary text containing:

Current date time: extract year: truncated from end to 2 (to extract 23)
Current user’s number

Dash

Do a search for Purchase order count + 1:

• created date >= current date time rounded down to year
• created date < current date time rounded down to year