Consecutive letters text field

Forum|Forum|3 years ago
June 30, 2022
1 reply
1423 views

Trying to create multiple text fields with consecutive letting based on user input of text box 1.

For example

If user enters "A" in text box 1, text box 2 will auto populate "B" and text box 3 will have "C", and so fourth. At the end of the alphabet, after "Z", it would auto populate "AA".

Can someone help me out please, I've been searching for hours with no luck.

JavaScript

This topic has been closed for replies.

try67

Community Expert

Doing it up to "Z" is not too difficult, but then it becomes a bit tricky. How many such fields do you have?

J

Jordan25071026u5a4Author

Participant

@try67 It differs depening on the day, sometimes I'll have 5 fields, sometimes it can go up to 180+. If you can show me how to do it up to "Z" I can write in the other letter after it doubles up.

Thank you so much

try67

Community Expert

This is not my code, I found it online (and tweaked it a bit), but it seems to work pretty well:

function colName(n) {
	var ordA = 'a'.charCodeAt(0);
	var ordZ = 'z'.charCodeAt(0);
	var len = ordZ - ordA + 1;
  
	var s = "";
	while(n >= 0) {
		s = String.fromCharCode(n % len + ordA) + s;
		n = Math.floor(n / len) - 1;
	}
	return s.toUpperCase();
}

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded