I have a question about the pulldata function.
I have done all the exercises from http://xlsform.org/en/ but cant get the pulldata function to work.
All that the ODK Collect says when I upload the form is "The fruit is pulled from csv."
What am I doing wrong?
I would really appreciate all help, thanks!
The form looks like this:
Hi Matti,
Here is a sample from my calculation column and this works for me.
csv file name: verification
HHH Name: name to display from the csv file
Code: Code is also a column on the csv file
barcode_test: this is a field on ODK.
Thanks for your reply. I got it working now.
Seems that the csv files info has to be separated with commas and not with semicolons as Excel saves it as.
Just replaced the semicolons with commas and it started working.
But now I have an other question.
How can I edit the information that I brought from the csv file in Collect?
Or is it even possible?
In the csv file I have just one thing that I would have to edit. For example, I have this written in the file "/3" and I would have to just put a number in front of the slash like this for example "2/3".
Is it possible to do this with collect?
Hi Joseph, what is "${barcode_test}? is it the name of the calculation field or is it another field?
I got this error:
FormLogicError: pulldata with incorrect number of parameters found: pulldata('localidades', 'localidad', 'IDPC_key')
localidades is my csv file
localidad is the data I want to include in the form
IDPC_key is the unique identifier.
the field calculate name is "localidad"...
The "mango" part of the example confuses me a bit, because I don´t know if this is the first record of the row in my CSV, a field that the user selects or the field that "recieves" the data.
Hi,
I am experiencing the same problem with 'search' and 'pulldata' functions on my spreadsheet. I have changed the csv to the recommended format on Ona but still nothing. Also, downloaded the fruits example to see if it would work but I only get the label option 'name' from the choices sheet instead of the actual fruit names in the CSV.
Please help. REF Questionnaires Sacco 12.04.2019.xlsx (16.3 KB) sacco_details2.csv (2.2 KB)