LC Dynamic Form Need Script to auto increment cell by A, B, C....AA, BB, rather than numeric. Is this possible

Certainly it's possible, character codes are sequential. Here's some code that increments A-Z.


// Initialize
var cInc = "A";

// Increment
var nInc = cInc.charCodeAt(0);
if(cInc < "Z")
cInc = String.fromCharCode(++nInc);


To add more characters "AA" "BB" etc. requires code for getting the current length and rebuilding the string.

I'm a novice to scripting and trying to add script to my file. Do this code all go in the EventCalculate? When I use the code all cells in my column have a "B".

I did not write a complete script. This code was just to show how a text value can be incremented. You could in fact use the row index as the basis for the text value. In this case the code would be placed in the "initialize" event.

var nBaseVal = ("A").charCodeAt(0);
this.rawValue = String.formCharCode(nBaseVal + this.parent.index);

Again, this is not complete. To handle more than 26 rows the script will need to add extra characters. The is also the issue of deleting and inserting rows. The initialize script may need to be rerun in these situations.