Changing the background colour of a tabe cell, according to the selection in a drop down list | Community
Skip to main content
Staffle
Staffle
Level 2
October 5, 2015
Solved

Changing the background colour of a tabe cell, according to the selection in a drop down list

  • October 5, 2015
  • 12 replies
  • 9239 views

I have a drop-down list wrapped in a subform in a table cell. Users can pick Green, yellow or red and I want the background colour to change according to their selection.

Can you tell me why this script is not working? I am sure some of you folks can see it in a second.


if (this.ListItem=="green") {

Subform1.DropDownList1.fillColor = "000,128,000"; BackgroundFill="solid";

}                  

if (this. ListItem=="yellow") {

Subform1.DropDownList1.fillColor = "255,128,000";

}

if (this.ListItem=="red") {           

Subform1.DropDownList1.fillColor = "255,000,000";     

}


Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by _Bruce_Robertson

Hi,

I think you should be able to use the following code in the change event of the dropdownlist.

form1.#subform[0].Table1.Row2.DropDownList1::change - (JavaScript, client)

if (xfa.event.change=="green") {

  this.fillColor = "000,128,000";

}                 

if (xfa.event.change=="yellow") {

  this.fillColor = "255,128,000";

}

if (xfa.event.change=="red") {          

  this.fillColor = "255,000,000";    

}

Regards

Bruce

12 replies

Show previous replies
_Bruce_Robertson
_Bruce_Robertson
Level 10
October 12, 2015

Hi Lisa,

There seems to be some code (I guess from an earlier attempt) in the exit event of the Subform1 that contains the drop down.  This code is no longer required and should be removed.  It is this code that changes the brackground back to green (because the if statement only has one "=" sign).

Bruce

Staffle
StaffleAuthor
Level 2
October 13, 2015

Hi Bruce,

I checked all the cells with scripts and there is nothing on an exit event.The problem was that the subforms were all called Subform1 instead of 1, 2, 3, 4.

So, this code works fine now:

if (xfa.event.change=="green") {

  this.fillColor = "000,128,000";

}                 

if (xfa.event.change=="yellow") {

  this.fillColor = "255,128,000";

}

if (xfa.event.change=="red") {          

  this.fillColor = "255,000,000";    

}

Many thanks...all good!!!

Lisa

Terms & ConditionsAccessibility statement

Loading footer...