Employee ID based on previous numbers

[Tim_Martin]

I’m trying to create/auto increment new employee numbers based on year & number.
For example, our employee IDs are 19-0054. When I create a new employee entry/new form entry, I’d like the new employee ID to increment by one from the previous number.

Any thoughts would be greatly appreciated.

Cheers!
Tim