package n - province 3 - district n
when we 'elect one of the package should pull data for the rest of the text type question automatically
Welcome back to the community, @dimesh! Are you trying to use the cascade the choices here as oultned in the support article Adding Cascading Select Questions?
@Kal_Lam what i want when we select package from the dropdown box, rest of the data should pull from the csv file.
| province | district_name | impliment_agency | site | package |
|---|---|---|---|---|
| Sabaragamuwa | Rathnapura | MASL | walawa | Hydro Mechanical works of Walawa RB Main Canal |
| Sabaragamuwa | Rathnapura | MASL | walawa | Ecological Improvements and Marking Reservation along Walawa RB Main Canal |
| Sabaragamuwa | Rathnapura | MASL | walawa | Improvements to Walawa RB 41 km Main Canal from 0+000 km to 8+250 km (Package 01) – (Retender) |
| Sabaragamuwa | Rathnapura | MASL | walawa | Improvements to Walawa RB 41 km Main Canal from 8+250 km to 17+400 km (Package 02) – (Retender) |
| Sabaragamuwa | Rathnapura | MASL | walawa | Improvements to Walawa RB 41 km Main Canal from 23+400 km to 30+005 km (Package 03) – (Retender) |
| Sabaragamuwa | Rathnapura | MASL | walawa | Improvements to Walawa RB 41 km Main Canal from 30+005 km to 41+600 km (Package 04) – (Retender) |
| Sabaragamuwa | Rathnapura | MASL | walawa | Supply and Installation of Gantry Crane for Udawalawe Dam |
| Uva | Badulla | ID | Nagadeepa Scheme | Rehabilitation of Arawatta tank bund |
| Uva | Badulla | ID | Nagadeepa Scheme | Rehabilitation of Tank Bund, Sluice and Spillway in Nagadeepa tank |
| Central | Kandy | MASL | Polgolla Barrage | Supply and Installation of Gantry Crane for Polgolla Barrage |
| Central | Matale | ID | Dewahuwa | Rehabilitation of Dewahuwa Scheme |
| North Central | Anuradhapura | ID | Mahalindawewa | Rehabilitation of tank bund (1.5 km) including Rip Rap and sluice of Mahalindawewa Tank |
| North Central | Anuradhapura | MASL | Kalawewa | Repairs to gates of irrigation structures in Kalawewa Left Bank main canal |
| North Central | Anuradhapura | WRB | Anuradhpura-GWMU | Expansion of regional offices for establishment of Provincial Groundwater Management units at regional scale - Puttlam , Anuradhapura & Vavuniya Units -WRB - Anuradhpura |
| North Western | Kurunegala | ID | Bathalagoda | Rehabilitation of D1, D2, D4 canals in Bathalagoda Scheme (Retender) |
| North Western | Kurunegala | ID | Bathalagoda | Rehabilitation of D5, D7, D7 RB canals in Bathalagoda Scheme (Retender) |
| North Western | Puttlam | WRB | Puttalm-GWMU | Expansion of regional offices for establishment of Provincial Groundwater Management units at regional scale - Puttlam , Anuradhapura & Vavuniya Units -WRB - Puttalm |
| Eastern | Ampara | ID | Senanayaka Samudraya | Providing rip-rap protection to Senanayaka Samudraya Bund & Improvement to Bund Road |
| Eastern | Batticaloa | EPC-ID | Meiyankal Scheme | Rehablitation of tank Bund (0.8km) including Rip Rap, Spill and both sluice to Meiyankal Tank |
| Eastern | Batticaloa | EPC-ID | Meiyankal Scheme | Improvements to Spill structure of Meiyankal Tank |
| Eastern | Batticaloa | EPC-ID | Meiyankal Scheme | Improvements to LB & RB Main and D Channel including structures of Meiyankal Scheme |
| Eastern | Batticaloa | EPC-ID | Adachchakal scheme | Rehabilitation of Tank Bund (1.0 km) including rip-rap, spill and sluice of Adachchakal Tank |
| Eastern | Batticaloa | EPC-ID | Adachchakal scheme | Rehabilitation of tank bund and scheme of Adachchakal scheme |
| Northern | Killinochchi | NPC-ID | Kalmadu Tank | Rehabilitation of Kalmadu Scheme Headworks |
| Northern | Killinochchi | NPC-ID | Piramanthalaru Scheme | Rehabilitation of Downstream under Piramanthalaru Irrigation Scheme (phase 01) |
| Northern | Killinochchi | NPC-ID | Kanagambikai Scheme | Rehabilitation of Downstream under Kanagambikai Scheme |
| Northern | Mullathive | NPC-ID | Muthuiyankaddu Scheme | Rehabilitation of Muthuiyankaddu RB Canal - Muthuiyankaddu Division - Package 01 (RB/Track 03) |
| Northern | Mullathive | NPC-ID | Muthuiyankaddu Scheme | Rehabilitation of Muthuiyankaddu RB Canal - Muthuiyankaddu Division - Package 03 (RB/Track 05) |
| Northern | Mullathive | NPC-ID | Muthuiyankaddu Scheme | Rehabilitation of Muthuiyankaddu RB Canal - Muthuiyankaddu Division - Package 04 (RB/Track 01) |
| Northern | Mullathive | NPC-ID | Muthuiyankaddu Scheme | Rehabilitation of Muthuiyankaddu RB Canal - Muthuiyankaddu Division - Package 05 (RB/Track 02 |
| Northern | Mannar | ID | Akathimurippu Tank | Improvements to Akathimurippu tank bund from 0+000 to 6+450 of Akathimurippu Scheme |
| Northern | Vauniya | ID | Muhathankulam Scheme | Improvements to Muhathankulam Main Canal from 0+000 to 4+400 of Muhathankulam Scheme |
| Northern | Vauniya | WRB | Vavuniya-GWMU | Expansion of regional offices for establishment of Provincial Groundwater Management units at regional scale - Puttlam , Anuradhapura & Vavuniya Units -WRB - Vauniya |
| Northern | Jaffna | WRB | Jaffna-GWMU | Establishment of Provincial Groundwater Management unit at Jaffna region -WRB |
@dimesh, so did you mean you wish to use the pull data function for cascading select through the external CSV file, or did you mean you simply wish to use the CSV file for the cascading select options?
