topic Re: Use pulldata() to populate select_one label in ArcGIS Survey123 Questions

Use pulldata() to populate select_one label

LarryWiebe — Fri, 08 Sep 2017 15:39:48 GMT

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

Re: Use pulldata() to populate select_one label

JamesTedrick — Fri, 08 Sep 2017 18:29:23 GMT

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?

Re: Use pulldata() to populate select_one label

LarryWiebe — Fri, 08 Sep 2017 19:21:58 GMT

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

Re: Use pulldata() to populate select_one label

JamesTedrick — Fri, 08 Sep 2017 19:44:49 GMT

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.

Re: Use pulldata() to populate select_one label

LarryWiebe — Fri, 08 Sep 2017 20:13:38 GMT

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.

Re: Use pulldata() to populate select_one label

JamesTedrick — Fri, 08 Sep 2017 20:23:06 GMT

Hi Larry,

E-mail me at jtedrick at esri.com