The label column contains the actual text you see in the form. Names can only contain letters, digits, hyphens, underscores, and periods. Names have to start with a letter or an underscore. The name column specifies the unique variable name for that entry. The type column specifies the type of entry you are adding. The survey worksheet has 3 mandatory columns: type, name, and label. Every entry must have values for each of the mandatory columns, but the optional columns may be left blank. Additionally, each worksheet has a set of optional columns that allow further control over the behavior of each entry in the form, but are not essential to have. This also allows a set of choices to be reused for multiple questions (for example, yes/no questions).īoth of these worksheets have a set of mandatory columns that must be present for the form to work. Answer choices with the same list name are considered part of a related set of choices and will appear together for a question. This worksheet is used to specify the answer choices for multiple choice questions. Each row usually represents one question however, there are certain other features described below that you can add to the form to improve the user experience. It contains the full list of questions and information about how they should appear in the form. This worksheet gives your form its overall structure and contains most of the content of the form.
A third optional worksheet called settings can add additional specifications to your form and is described below. Basic formatĮach Excel workbook usually has two worksheets: survey and choices. The XLSForm is then converted to an ODK XForm, a popular open form standard, that allows you to author a form with complex functionality like skip logic in a consistent way across a number of web and mobile data collection platforms. They are simple to get started with but allow for the authoring of complex forms by someone familiar with the syntax described below. XLSForms provide a practical standard for sharing and collaborating on authoring forms. Authoring is done in a human readable format using a familiar tool that almost everyone knows - Excel. XLSForm is a form standard created to help simplify the authoring of forms in Excel.
0 kommentar(er)
