Adding letter suffix to Auto Generated value

Developers
1

I am trying to add a sequential letter suffix to an Auto Generated Field.

For instance, I have a field with the value 20220601, and I want to generate another field that would read 20220601A, 20220601B, 20220601C… and so on.

I currently have it as “{2,reference,1001113}-{0,number,#}” which adds a number to the end. How do I make it a letter?

2

Hi,

Unfortunately, the sequence of auto generated field could only be number, it can’t be letter.
If you would like to get the field value like above, you will need to create a field and apply IFS() to transfer 1 to A, 2 to B, 3 to C…, etc. And combine the strings together with string formula.