So we just added a granule to our license that lets us add up to 10 custom tables.
I have already made the table, I know enough about object designer to do that. But what I need help with is auto-populating new entries. I have a “code” field, which stores two digits. Essentially, I want the shortest unique code that a given row can have.
For example, AA, AB, AC, AD and so on. Then it would become AZ, BA, BB and up to ZZ, which allows for 2^26 possibilities.
Is there a way, using C/AL code or something else, to make it automatically continue the series when you add a new line? It would be nice for our users to not have to think about it, they could just make a new row, enter in the rest of the columns and hit enter and the code would appear.
I know we do it with sales headers, for example - the auto-numbering. But that C/AL code uses “number series”, and for this we want letters.
Any help would be appreciated.