nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

pass name and the label from select-one pull table

AndrewPriest

hi, I'm guessing this is an easy one, but it's got me stumped. I'm pulling a .CSV for a select_one question. it's passing the name fine, but I also want to pass the label value to the point feature class. would the jr:choice-name formula pass both? or is there a way to set up some sort of table join? thanks

Find more posts tagged with

Accepted answers

All comments

ZacharySutherby

Hello @AndrewPriest,

The jr:choice-name() function is the way to extract the choice label from the selected choice. You could store the label in a separate hidden question (field in the feature service), or concatenate the choice name from the select_one question and the choice label using the jr:choice-name() function in a separate question (field) to store both in the same location.

LaurenceTait

What do you mean when you say that you are pulling a .CSV for a select_one question? Do you mean that you are using the select_one_external function? Or that you are setting the default for the select_one question using a a pulldata function? Or that you are using the answer from the select_one in a pulldata calculation in another field? Or something else?

AndrewPriest

hello. the question type is:

select_one_from_file MySpreadsheet.csv

the .csv is in the media folder

the calculation is:

pulldata('MySpreadsheet','name','label', ${Field})

thanks for the reply! any insight on how I can calculate the Label in a new field would be greatly appreciated

LaurenceTait

OK, I think see what you're doing.

There's two ways of calculating the label in a new field. You can either pull the label from the csv or use jr:choice-name to calculate it from the selected answer.

Example attached below

Form 6.xlsx

Book1.csv

AndrewPriest

Thanks! I'll give it try

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.