Skip to main content
Participant
July 31, 2022
Answered

3 dropdown boxes only 2 are working??

  • July 31, 2022
  • 1 reply
  • 1141 views

I have a form with 3 dropdown lists to select from.

box 1 = product (works)

box2= location (not working)

box3 = Pipeline (works)

 

Box 1 is supposed to determine the data for box2 and box 3.

for some reason, box 2 is not populating ...Im only getting a value in box 3 when box 1 is selected.

var drop = this.getField("drpLocation");
var drop = this.getField("drpPipeline");
if(event.value == "DSW-CUSHING"){
drop.setItems(["CUSHING, OK"]);
drop.setItems(["ENTERPRISE"]);}
else if(event.value == "WTI-CMA"){
drop.setItems(["CUSHING, OK"]);
drop.setItems(["ENTERPRISE"]);}
else if(event.value == "WTI-COLORADO CITY"){
drop.setItems(["COLORADO CITY, TX"]);
drop.setItems(["WTG","BRIDGETEX","MAGELLAN","NUSTAR","PE2","PE3","PE4", "ex-WTG","ex-BRIDGETEX","ex-LONGHORN","ex-PE2","ex-PE3","ex-PE4"]);}
else if(event.value == "WTI-CORPUS"){
drop.setItems(["CORPUS CHRISTI, TX","ROBSTOWN, TX","INGLESIDE, TX","TAFT, TX","BUCKEYE"]);
drop.setItems(["CACTUS I","CACTUS II","EPIC CRUDE","GRAY OAK","NUSTAR","PLAINS","SOUTH TEXAS GATEWAY","ex-EPIC","ex-GRAY OAK","ex-NUSTAR","ex-PLAINS");}
else if(event.value == "WTI-CRANE"){
drop.setItems(["CRANE, TX"]);
drop.setItems(["EPIC CRUDE","GRAY OAK","MAGELLAN","MEDALLION","ex-EPIC CRUDE","ex-GRAY OAK","ex-MAGELLAN","ex-MEDALLION"]);}
else if(event.value == "WTI-CUSHING"){
drop.setItems(["CUSHING, OK"]);
drop.setItems(["ENTERPRISE","PLAINS"]);}
else if(event.value == "WTI-HOUSTON"){
drop.setItems(["HOUSTON, TX"]);
drop.setItems(["ENTERPRISE","MAGELLAN"]);}
else if(event.value == "WTI-MIDLAND"){
drop.setItems(["MIDLAND, TX"]);
drop.setItems(["ENTERPRISE","PLAINS"]);}
else if(event.value == "WTI-ORLA"){
drop.setItems(["ORLA, TX"]);
drop.setItems(["GRAY OAK"]);}
else if(event.value == "WTI-WINK"){
drop.setItems(["WINK, TX"]);
drop.setItems(["EPIC CRUDE","GRAY OAK","WINK TO WEBSTER"]);}
else if(event.value == "WTL-COLORADO CITY"){
drop.setItems(["COLORADO CITY, TX"]);
drop.setItems(["WTG","BRIDGETEX","PLAINS"]);}
else if(event.value == "WTL-CORPUS"){
drop.setItems(["CORPUS CHRISTI, TX","ROBSTOWN, TX","INGLESIDE, TX","TAFT, TX","BUCKEYE"]);
drop.setItems(["CACTUS I","CACTUS II","EPIC CRUDE","GRAY OAK","NUSTAR","PLAINS","SOUTH TEXAS GATEWAY","ex-EPIC","ex-GRAY OAK","ex-NUSTAR","ex-PLAINS"]);}
else if(event.value == "WTL-CRANE"){
drop.setItems(["CRANE, TX"]);
drop.setItems(["ENTERPRISE","MAGELLAN","PLAINS")];}
else if(event.value == "WTL-CUSHING"){
drop.setItems(["CUSHING, OK"]);
drop.setItems(["ENTERPRISE","PLAINS"]);}
else if(event.value == "WTL-HOUSTON"){
drop.setItems(["HOUSTON, TX","ECHO TERMINAL"]);
drop.setItems(["ECHO","STG","MAGELLAN"]);}
else if(event.value == "WTL-ORLA"){
drop.setItems(["ORLA, TX"]);
drop.setItems(["GRAY OAK","ENTERPRISE"]);}
else if(event.value == "WTL-WINK"){
drop.setItems(["WINK, TX"]);
drop.setItems(["EPIC CRUDE","GRAY OAK","WINK TO WEBSTER"]);}
else if(event.value == "WTS-COLORADO CITY"){
drop.setItems(["COLORADO CITY, TX"]);
drop.setItems(["WTG","BRIDGETEX","MAGELLAN","NUSTAR","PE2","PE3","PE4", "ex-WTG","ex-BRIDGETEX","ex-LONGHORN","ex-PE2","ex-PE3","ex-PE4"]);}
else if(event.value == "WTS-CORPUS"){
drop.setItems(["CORPUS CHRISTI, TX","ROBSTOWN, TX","INGLESIDE, TX","TAFT, TX","BUCKEYE"]);
drop.setItems(["CACTUS I","CACTUS II","EPIC CRUDE","GRAY OAK","NUSTAR","PLAINS","SOUTH TEXAS GATEWAY","ex-EPIC","ex-GRAY OAK","ex-NUSTAR","ex-PLAINS");}
else if(event.value == "WTS-CRANE"){
drop.setItems(["CRANE, TX"]);
drop.setItems(["EPIC CRUDE","GRAY OAK","MAGELLAN","MEDALLION","ex-EPIC CRUDE","ex-GRAY OAK","ex-MAGELLAN","ex-MEDALLION"]);}
else if(event.value == "WTS-CUSHING"){
drop.setItems(["CUSHING, OK"]);
drop.setItems(["ENTERPRISE","PLAINS"]);}
else if(event.value == "WTS-HOUSTON"){
drop.setItems(["HOUSTON, TX"]);
drop.setItems(["ENTERPRISE","MAGELLAN"]);}
else if(event.value == "WTS-MIDLAND"){
drop.setItems(["MIDLAND, TX"]);
drop.setItems(["ENTERPRISE","PLAINS"]);}
else if(event.value == "WTS-ORLA"){
drop.setItems(["ORLA, TX"]);
drop.setItems(["GRAY OAK"]);}
else if(event.value == "WTS-WINK"){
drop.setItems(["WINK, TX"]);
drop.setItems(["EPIC CRUDE","GRAY OAK","WINK TO WEBSTER"]);}
else{
drop.clearItems();
drop.clearItems();}

 

This topic has been closed for replies.
Correct answer ls_rbls

I still don't see what you're wanting me to see. 


You have two variables declared with the same variable name.

 

var drop

 

and 

 

var drop

 

Having the same variable name declared with two different field objects has your entire script broken.

 

you may need to change it to something like:

 

var drop1

var drop2

 

or

 

var location = this.getField("drpLocation");

 

var pipeline = this.getField("drpPipeline");

 

for example.

1 reply

try67
Community Expert
Community Expert
July 31, 2022

Do you not see a problem here?

 

var drop = this.getField("drpLocation");
var drop = this.getField("drpPipeline");
Participant
July 31, 2022
Is that supposed to be an answer?
try67
Community Expert
Community Expert
July 31, 2022

Yes. These two lines are the source of all of your issues. I'm trying to guide you to see the problem there. Look carefully...