Hallo guys, I hope you are all doing well, i have a question about the default item in ODK XLSForm,
Is it possible if i select and option for the first time it can remain the default answer for consequent number of times i will be using that form, Like the name or the location remain when doing follow up on a particular state?
Thanks in advance
Hi Nicholas, there isn't an easy way to store data across form-filling sessions.
If you are doing a baseline/follow up style campaign where you want to reduce data entry, you can preload data from the CSV and let users confirm/correct that data. http://xlsform.org/#pre-loading-csv-data has a good write up on how to do that.
The ability to remember data across sessions (e.g., a historical auto-complete) is a cool idea, so I'm moving this topic to Features so we can see what the interest in the community is.
Am using XLSform to create the forms.
A good example of this is, when i take a survey of a place, and i want to do a follow up for the same to check on progress,, when i go back and select that particular place, i would like to have some fields/answers remain the same as selected in the first time of survey
We're currently doing something similar, but the time period is longer. When we need to auto-fill certain sections of the form, or look-up data from previous surveys, we attach the data as a media file and code the xlsxform to "pull" data from the labelled fields. Since we update this media folder data and our forms monthly, this works for us.
Now can you please explain how to do that from an xlsform since this is exactly what am looking for, i need some fields to be filled with previous data, how do i save the previous submitted data in order to access it the next time i upload it as a media file
We're using a workaround to get the data in the format we require. At the end of the form, we have a small section populated with 'calculate' fields that stores the inputted data in the format we require. At the end pf the month, when we export the form as a .csv, we simply copy the data from the 'calculate' fields and add it to the next month's media file.
Note: We're using the 'calculate' function because we have multiple entry points for the same data, and so we need to concatenate this data into a single field. If you dont have this constraint, you could simply copy the data from your column to one in the media file.
Doing this, we are able to use Month 1's inputted data, such as names, addresses, phone numbers, unique ID's etc, and have them availble to search in Month 2's data collection form.
XLSForm.org has details on how to calculate and pull data from preloaded CSVs.
Hope this helps! If anyone has a simpler solution, please let us know!