Specific code generation

[mandave]

In my table I have different data

1. Date - 01//06/2025
2. Work Index - 1 (or 2, or 3, ...) 
3. Yes/no (of specific situation) - Yes

I wont to write in another field an automatic alphanumeric code for my job in another line with this information:

A011M

Where
 _ A is the year (B is 2026, C is 2027, ...)
 _ 01 is the day (01 june)
 _ 1 is the work index
 _M is the result of Yes/No option, in this case Yes (the other one is S)

How can I write this? Please

[Suvrutt_Gurjar · Accepted solution]

Just for the expression purpose , you may want to try an expression something like below in another's field's app formula setting

CONCATENATE(

SWITCH(YEAR([Date]), "2025", "A", 2026 , "B",  ""2027", "C", ....... "2048", "X", "2049", "Y", "2050", "Z", "AA"),

TEXT([Date],"DD") , 

[Work_INDEX],

SWITCH([Yes_No_Column], "Yes", "M",  "No" , "S", " ")

)

Assumes that [Yes_No_Column] is of enum type with options "Yes" and "No". If it is Y/N type column please substitute subexpression SWITCH([Yes_No_Column], "Yes", "M",  "No" , "S", " ") with SOMETHING LIKE SWITCH([Yes_No_Column], TRUE, "M",  FALSE , "S", " ") 

Please test well.