Is there a way to keep sequential numbers of items in a column that resets on Jan 1st?

[FTong]

I have a list of consecutive jobs numbers that start every year.

The format is as follows:
2k19xxx
2k20xxx
2k21xxx

Description:
2k = code added in the year 2000
19, 20, or 21 - the year the job was started.
xxx = consecutive number from 001 to whatever number jobs are started that year

Right now, the “Jobs Schedule” is kept in a google sheet, and every year is kept in a separate tab - so creating the consecutive number codes is not a problem using a cell formula.

However, when using AppSheet I find it is more convenient to have all the jobs in a single sheet.

I am trying to use the following formula to auto create the job number:

“2K”&(Year(Today())) = 2k2021

Problems:

1. I need the year to be only 2 digits - and I am getting 4 .
2. I need to get a sequential number in 000 format after the year.

Do you have any advice on how to approach these two problems?