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:
choices tab:
Pull Table (CoreCap):
Text field is empty on survey:
@DougBrowning any tips on how to make this work?
Solved! Go to Solution.
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.
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.
@ChristopherCounsell coverting to csv worked. Thanks for the help, much appreciated!