Two or more data types as their answer on XLSForms

Support
1

I would like to know how I can add a question which have two or more data types as their answer on XLSForms?

For example, for something as simple as entering the name of an individual, I want to give a single selection option for the part- 'Mr./Ms.' and then a text field for them to enter the rest of their name, what would I do?

2

You can use this example test_name.xlsx (8.7 KB)

1 Like
3

This will still be asked as separate questions right? I was looking for a solution where it comes under a single question. Thank you though :slight_smile:

4

If you need your data export to have the data in one cell, you could try to use a calculate type question to combine the parts. Something like:

+-------------------+---------------+---------------+------------+--------------------------------------------+
|       type        |     name      |     label     | appearance |                calculation                 |
+-------------------+---------------+---------------+------------+--------------------------------------------+
| begin group       | name          |               | field-list |                                            |
| select_one titles | title         | Select title: |            |                                            |
| text              | first         | First name:   |            |                                            |
| text              | last          | Last name:    |            |                                            |
| end group         |               |               |            |                                            |
| calculate         | combined_name |               |            | concat(${title}," ",${first}," ",${last}) |
+-------------------+---------------+---------------+------------+--------------------------------------------+

It is also easy to do this after export using formulas in a spreadsheet software such as Excel.

1 Like
5

Thanks you two! Works for me :slight_smile: