Select to view content in your preferred language

Use existing data in your survey - the pulldata( ) function

60
1
3 hours ago
dwold
by
Occasional Contributor III

I am trying to pull data from a excel file in my media folder to populate a note/text field. I am having issues getting the value I need to render in the form. See anything I am doing wrong?

survey tab:

dwold_3-1721158879296.png

choices tab:

dwold_2-1721158831892.png

Pull Table (CoreCap):

dwold_1-1721158617194.png

Text field is empty on survey:

dwold_4-1721158911489.png

@DougBrowning any tips on how to make this work?

 

 

0 Kudos
1 Reply
ChristopherCounsell
MVP Regular Contributor

Excel files aren't supported it has to be a CSV.

Can you share the CSV files and xlsform? Usually these issues are tied to formatting of the CSV. Otherwise the screenshots look OK.

You also don't have to use underscores in select one. The S123 team have confirmed that it's ok to have some special characters including spaces for single choice. It's only multiple choice that has the no spaces requirement.

0 Kudos