Programming a household survey in XLS and then converting to XML at FormHub. Running into some problems as the sample guidance assumes a minimal competence in XML or assumes knowledge of programming syntax which I don't have.
1. When I used KoBo (I know this is not KoBo forum, keep reading!) it kindly inserts an XML node for each question/indicator (A01, A02, etc.) that then appears in the XML. This is useful to modify the XML since it shows up in the label/hint section as well as the bind/constraint sections. How can I insert a column with numbers or labels for each question? What should the column header read? What are the limts of nodes, may I only use numbers, or alpha-numeric?
2. How can I put a default value in a date field? If the question is to enter respondent birthdate, I would like the date to show (today - 18 years.)
3. How can I put validation on the date so it is not after (today - 18 years) and not before (today - 99 years.)
4. Can I constrain the number of digits in a text field? I want the surveyor to enter a survey number of 4 digits following the country code and year. The question has a default of the country and year, and the surveyor should enter a survey number, but I want to make sure they enter 4 digits and not 3 or 5.
Thanks!