Question with PurchaseOrder#s

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?

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

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

This topic was automatically closed after 70 days. New replies are no longer allowed.