I m trying to get the following code work, it doesnt seem to work been at it for the past 4 hours.
Patch('Omaha Bulk List', Defaults('Omaha Bulk List'),{
Title:LblAppName3_1.Text,
DeliveryDate:Today(),
Driver:Driver DropDown_1.Text,
Compartment1Products:Gal For Prod 1 DropDown_1.Selected.Value,
Compartment2Products:Gal For Prod 2 DropDown_1.Selected.Value,
Compartment3Products:Gal For Prod 3 DropDown.Selected.Value,
Compartment4Products:Gal For Prod 4 DropDown.Selected.Value,
GallonsforCompartment1:Gal For Comp 1_1.Number,
GallonsforCompartment2: Gal For Comp 2_1.Number,
GallonsforCompartment3: Gal For Comp 3.Number,
GallonsforCompartment4: Gal For Comp 4.Number,
Compartment1BOL1:BOL 1 Comp 1_1.Number,
Compartment2BOL1:BOL 1 Comp 2_1.Number,
Compartment3BOL1:BOL 1 Comp 3.Number,
Compartment4BOL1:BOL 1 Comp 4.Number,
Prod1Comp1:Prod 1 Comp 1 DropDown_1.Selected.Value,
Prod1Comp2:Prod 1 Comp 2 DropDown_1.Selected.Value,
Prod1Comp3:Prod 1 Comp 3 DropDown.Selected.Value,
Prod1Comp4:Prod 1 Comp 4 DropDown.Selected.Value,
Gal1Comp1:Gal 1 Comp 1_1.Number,
Gal1Comp2:Gal 1 Comp 2_1.Number,
Gal1Comp3:Gal 1 Comp 3.Number,
Gal1Comp4:Gal 1 Comp 4.Number,
Compartment1BOL2Gallons:BOL 2 Comp 1_1.Number,
Compartment2BOL2Gallons:BOL 2 Comp 2_1.Number,
Compartment3BOL2Gallons:BOL 2 Comp 3.Number,
Compartment4BOL2Gallons:BOL 2 Comp 4.Number,
Prod2Comp1: Prod 2 Comp 1 DropDown_1.Selected.Value,
Prod2Comp2: Prod 2 Comp 2 DropDown_1.Selected.Value,
Prod2Comp3: Prod 2 Comp 3 DropDown.Selected.Value,
Prod2Comp4: Prod 2 Comp 4 DropDown.Selected.Value,
Gal2Comp1:Gal 2 Comp 1_1.Number,
Gal2Comp2:Gal 2 Comp 2_1.Number,
Gal2Comp3:Gal 2 Comp 3.Number,
Gal2Comp4:Gal 2 Comp 4.Number,
PodTruckComp1:Pod Truck Comp 1 DropDown_1.Selected.Value,
ProdTruckComp1:Prod Truck Comp 1 DropDown_1.Selected.Value,
ProdTruckComp3:Prod Truck Comp 3 DropDown.Selected.Value,
ProdTruckComp4:Prod Truck Comp 4 DropDown.Selected.Value,
Compartment1TotalGallonsonTruck: Tot Gal Truck Comp 1_1.Number,
Compartment2TotalGallonsonTruck: Tot Gal Tuck Comp 2_1.Number,
Compartment3TotalGallonsonTruck: Tot Gal Tuck Comp 3.Number,
Compartment4TotalGallonsonTruck: Tot Gal Tuck Comp 4.Number,
Customer1Name:Customer Name 1_1.Text,
Customer2Name:Customer Name 2_1.Text,
Customer3Name:Customer Name 3_1.Text,
Customer4Name:Customer Name 4_1.Text,
Customer5Name:Customer Name 5_1.Text,
Customer6Name:Customer Name 6_1.Text,
Customer7Name:Customer Name 7_1.Text,
Customer8Name:Customer Name 8_1.Text,
Customer9Name:Customer Name 9_1.Text,
Customer10Name:Customer Name 10_1.Text,
Customer11Name:Customer Name 11_1.Text,
Customer12Name:Customer Name 12_1.Text,
Customer1Ticket:Ticket Cust 1_1.Number,
Customer2Ticket:Ticket Cust 2_1.Number,
Customer3Ticket:Ticket Cust 3_1.Number,
Customer4Ticket:Ticket Cust 4_1.Number,
Customer5Ticket:Ticket Cust 5_1.Number,
Customer6Ticket:Ticket Cust 6_1.Number,
Customer7Ticket:Ticket Cust 7_1.Number,
Customer8Ticket:Ticket Cust 8_1.Number,
Customer9Ticket:Ticket Cust 9_1.Number,
Customer10Ticket:Ticket Cust 10_1.Number,
Customer11Ticket:Ticket Cust 11_1.Number,
Customer12Ticket:Ticket Cust 12_1.Number,
Customer1Compartment2:Comp 1 Cust 1_1.Number,
Customer2Compartment2:Comp 1 Cust 2_1.Number,
Customer3Compartment2:Comp 1 Cust 3_1.Number,
Customer4Compartment2:Comp 1 Cust 4_1.Number,
Customer5Compartment2:Comp 1 Cust 5_1.Number,
Customer6Compartment2:Comp 1 Cust 6_1.Number,
Customer7Compartment2:Comp 1 Cust 7_1.Number,
Customer8Compartment2:Comp 1 Cust 8_1.Number,
Customer9Compartment2:Comp 1 Cust 9_1.Number,
Customer10Compartment2:Comp 1 Cust 10_1.Number,
Customer11Compartment2:Comp 1 Cust 11_1.Number,
Customer12Compartment1:Comp 1 Cust 12_1.Number,
Customer1Compartment2:Comp 2 Cust 1_1.Number,
Customer2Compartment2:Comp 2 Cust 2_1.Number,
Customer3Compartment2:Comp 2 Cust 3_1.Number,
Customer4Compartment2:Comp 2 Cust 4_1.Number,
Customer5Compartment2:Comp 2 Cust 5_1.Number,
Customer6Compartment2:Comp 2 Cust 6_1.Number,
Customer7Compartment2:Comp 2 Cust 7_1.Number,
Customer8Compartment2:Comp 2 Cust 8_1.Number,
Customer9Compartment2:Comp 2 Cust 9_1.Number,
Customer10Compartment2:Comp 2 Cust 10_1.Number,
Customer11Compartment2:Comp 2 Cust 11_1.Number,
Customer12Compartment2:Comp 2 Cust 12_1.Number,
Customer1Compartment3:Comp 3 Cust 1.Number,
Customer2Compartment3:Comp 3 Cust 2.Number,
Customer3Compartment3:Comp 3 Cust 3.Number,
Customer4Compartment3:Comp 3 Cust 4.Number,
Customer5Compartment3:Comp 3 Cust 5.Number,
Customer6Compartment3:Comp 3 Cust 6.Number,
Customer7Compartment3:Comp 3 Cust 7.Number,
Customer8Compartment3:Comp 3 Cust 8.Number,
Customer9Compartment3:Comp 3 Cust 9.Number,
Customer10Compartment3:Comp 3 Cust 10.Number,
Customer11Compartment3:Comp 3 Cust 11.Number,
Customer12Compartment3:Comp 3 Cust 12.Number,
Customer1Compartment4:Comp 4 Cust 1.Number,
Customer2Compartment4:Comp 4 Cust 2.Number,
Customer 3 Compartment 4:Comp 4 Cust 3.Number,
Customer4Compartment4:Comp 4 Cust 4.Number,
Customer5Compartment4:Comp 4 Cust 5.Number,
Customer6Compartment4:Comp 4 Cust 6.Number,
Customer7Compartment4:Comp 4 Cust 7.Number,
Customer8Compartment4:Comp 4 Cust 8.Number,
Customer9Compartment4:Comp 4 Cust 9.Number,
Customer10Compartment4:Comp 4 Cust 10.Number,
Customer11Compartment4:Comp 4 Cust 11.Number,
Customer12Compartment4:Comp 4 Cust 12.Number,
TotalGallonsCustomer1:Total Gal Cust 1_1.Number,
TotalGallonsCustomer2:Total Gal Cust 2_1.Number,
TotalGallonsCustomer3:Total Gal Cust 3_1.Number,
TotalGallonsCustomer4:Total Gal Cust 4_1.Number,
TotalGallonsCustomer5:Total Gal Cust 5_1.Number,
TotalGallonsCustomer6:Total Gal Cust 6_1.Number,
TotalGallonsCustomer7:Total Gal Cust 7_1.Number,
TotalGallonsCustomer8:Total Gal Cust 8_1.Number,
TotalGallonsCustomer9:Total Gal Cust 9_1.Number,
TotalGallonsCustomer10:Total Gal Cust 10_1.Number,
TotalGallonsCustomer11:Total Gal Cust 11_1.Number,
TotalGallonsCustomer12:Total Gal Cust 12_1.Number,
TotalGallonsDeliveredCompartment1:Total Gal Del Comp 1_1.Number,
TotalGallonsDeliveredCompartment2:Tot Gal Del Comp 2_1.Number,
TotalGallonsDeliveredCompartment3:Tot Gal Del Comp 3.Number,
TotalGallonsDeliveredCompartment4:Tot Gal Del Comp 4.Number,
TotalGalDelivered_1:Total Gal Delivered_1.Number,
EndingGallonsCompartment1:End Gal Comp 1_1.Number,
EndingGallonsCompartment2:End Gal Comp 2_1.Number,
EndingGallonsCompartment3:End Gal Comp 3.Number,
EndingGallonsCompartment4:End Gal Comp 4.Number,
EmptyComp1:Empty Comp 1 Toggle_1.Selected.Value,
EmptyComp2:Empty Comp 2 Toggle_1.Selected.Value,
EmptyComp3:Empty Comp 3 Toggle.Selected.Value,
EmptyComp4:Empty Comp 4 Toggle.Selected.Value
});
Thanks
Saad
2
Share
Report
All responses (
Answers (
