Use pulldata() to populate select_one label

[LarryWiebe]

I am inspecting transmission towers.  I have a simple Yes/No select_one question, but I need the label for the question to reflect the number of insulators on the tower.  I have built a pulldata csv that has my tower number and the label in it, but I can't get the label to show up.  I have tried the following in the label and calculation filed of the select_one and note question types. pulldata('BPIII_pulldata','tld_struct_no','label_phs_insul_clean_plumb',${tld_structure})

here is a sample of my CSV:

tld_struct_no,label_phs_insul_clean_plumb
1,"Correct number of insulators (3x30 dead end; 28 jumper); insulators are clean and strings plumb"
2,"Correct number of insulators (28); insulators are clean and strings are plumb"
3,"Correct number of insulators (3x30 dead end; 28 jumper); insulators are clean and strings plumb"
4,"Correct number of insulators (28); insulators are clean and strings are plumb"
5,"Correct number of insulators (28); insulators are clean and strings are plumb"
6,"Correct number of insulators (28); insulators are clean and strings are plumb"
7,"Correct number of insulators (28); insulators are clean and strings are plumb"
8,"Correct number of insulators (3x30 dead end; 28 jumper); insulators are clean and strings plumb"
9,"Correct number of insulators (28); insulators are clean and strings are plumb"

Thanks, Larry

[JamesTedrick]

Hi Larry,

Currently Survey123 doesn't support modifying the question label text.  You might be able to accomplish something similar with a note that is calculated using the pulldata to create something like:

Correct number of insulators (28)

Insulators are clean and strings are plumb?

[LarryWiebe]

Hi James,  I have been trying as you described, but I can't seem to get the pulldata to work.  I have a note question and use the pulldata syntax/csv from my original post in the calculation cell.  I have to put in a a value in the label or hint or I get an error.  When I put a value in the hint only, I get:

If I put a value in the label only, I only get the value I put in, not the calculation.

Do you see any issues in the syntax of my pulldata function or csv?  Maybe even a limitation on the names used? Quotes issues?

Thanks,

Larry

[JamesTedrick]

Hi Larry,

Without seeing the XLS file, it's little hard to judge if something is right or not.  I've created  quick example from your sample table to illustrate what I was thinking.

[LarryWiebe]

Thanks James, got your sample running... 

Can I private message you my configuration?  From your example, I had been using a text field for my structure, so I switched it to a select-one and I added the choices, but still can't get it working.  Also a select_one is not an option as

I have 3075 structures on this transmission line, not sure if that exceeds some limit.  I prepopulate the structure number passing it from collector in my final deployment.

[JamesTedrick]

Hi Larry, 

E-mail me at jtedrick at esri.com