Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

value of a cell dependent on a data selected from the list in another cell

Avatar

Level 1

Hello Everyone,

Could you please help to solve this puzzle.

I need to make a value of cells in the 2nd column dependent on the selection made in the cells in the 1st column, i.e.:

Header 1Header 2
List AnLIst Bn


Lists A and B have 10 items each

A1    B1

A2    B2

........

A10  B10

If A1 is selected I need a B1 appear in the second column in the same row, if A2 selected then B2,...and so on.

Could you please hep to resolve this, if at all this is possible?

Many thanks,

Andrew

1 Reply

Avatar

Level 3

Supposing that your list is a drop down list, you could put a script like the following on the exit event of List A. (very approximate, since I don't know any of your field names)

switch (this.rawValue)

{

case "A1":

     ListB.rawValue = "B1";

     break;

case "A2":

     ListB.rawValue = "B2";

     break;

}

Obviously, you'll want to replace "ListB" with the name of your field, and possibly the references to it (ie. TableName.RowName.FieldName) and fill in more case statements all the way to A10 if that's what you need. If List B is going to be a read-only field, you may even want to make it simply a text input box and have it display the values you want it to have based on the selection from List A.