Hello, I’m an amateur user of Kobo’s .xls form builder, and I’ve been struggling during the past days while trying to create a form that preloads the answers of the questions by writing the unique ID of a participant. I want to create a form that’s capable of both inscribing a new participant to an education project and updating the profile data of the participants already inscribed. The idea is to fill the ID field, and if the ID had already been registered it should preload the subsequent fields in order for the surveyor to change only the variables that have have different data. I know I can use pulldata for text-type questions, but it returns error when I try to deploy the form:
My guess is that the usage of pulldata with choice questions is the source of the error, so I would like to know how should I deploy the functions for the single choice, or if you consider that it is a totally different issue altogether. I would upload the xls and csv files but since I’m a new user I can’t upload them. Thanks in advance for any help you may provide.
1 Like
I’ve bumped up your ‘trust level’; can you try to upload again the form your are trying to deploy, thanks.
1 Like
Thank you very much for the prompt response. This is the xls form
Borrador - Formulario de Censo de Participantes - HUB Edutech.xlsx (102.0 KB)
And this is the pulldata csv (these are dummies, I’m not using real data yet):
censoOrd.csv (2.6 KB)
Thanks for the help, kind regards.
First, you should run your form thru XLSForm Online to pickup any basic ‘syntax’ errors. Then, after the form deploys to Kobo and runs ok - but it is still misbehaving - post back what your expected vs actual results are, and we can proceed from there.
1 Like
Good morning, thanks for the response. It seems the issue actually aren’t single choice or select multiple type of questions, but rather that I’m trying to pull string data into a geopoint field.
This strikes me as odd, given that I specifically set that particular field as numerical in the response sheet before converting it to csv. This implies that I have to take a totally different approach from what I was trying to do, and more than likely won’t have to preload data to the form. Thank you for your help, it has given me plenty of insight.
Looking at your form, you do appear to be trying to pull in a geopoint from your external censoOrd.csv dataset.
However, the field DireccionResidencia you are pulling it in from is empty (!)
Have you tried actually populating this field with an appropriately formatted geopoint string; eg
10.259034 -85.585049 0 0
1 Like
Hello, that’s actually a very unfortunate accident. I’ve had issues with the function to fill that column, and here I thought I had sorted it. I’ll fix it and let you know how it goes.
Kind regards.
Make sure you get the format precisely right, or it wont work.
Each point is represented as four numbers separated by spaces: latitude, longitude, altitude in meters, and accuracy radius in meters
Specifically, space-separated numbers (not comma), latitude then longitude, and you have to supply an altitude and accuracy value (but you can default these to 0 if you dont have the actual measurement).
1 Like
