Select to view content in your preferred language

Survey123 Issue with multi choice drop down pulling from .csv file

177
3
a week ago
ShawnBlaesing
Emerging Contributor

I replicated this survey from another (there will eventually be a total of five with the same parameters just different assets assigned).  The original was for lighting, so I changed out the references to lighting to be traffic barriers.

On the first page of the survey (attached below) the users can choose traffic barriers and or other, then on the second page they can use the repeater to add whatever materials they used to do the repair.  The materials class is pulling from a list on a csv file (attached below).  This worked fine for the lighting original survey but for the replicated one it is only pulling from other.

The materials repeater is supposed to pull from whatever lists are checked on the first page,  (leveraging the category field in the csv) and then use the fields below in the survey to take the cost rate information field from the csv file to do math about how much each material cost to install and them sum them below in the same section of the survey.

Hopefully this is a simple fix, or if there is a way to set this up a little better, I'd appreciate all the help you can provide.

Thanks

Shawn

0 Kudos
3 Replies
Neal_t_k
Frequent Contributor

You are using the label for your choice in the CSV instead of the value.  

Neal_t_k_0-1759436290988.png

Neal_t_k_1-1759436315644.png

you need "_" in Traffic Barrier in your CSV.  "Traffic_Barrier"

 

DougBrowning
MVP Esteemed Contributor

This is a perfect example of always having name and label the same.  Spaces are just fine.  This will drive you nuts for years just make them the same.

0 Kudos
ShawnBlaesing
Emerging Contributor

That did the trick.  I thought I needed the underscore in the name field but didn't know it would effect the pull from the .csv.

0 Kudos