Simple checklist
Hi ! I would like to create a simple checklist for a client. It has a list of 50 items, and all I need is for them to click on a check box if they want that item. Simple as that.
It would be nice if they could backtrack in the list if they change their mind about something.
Other things that would be nice to have:
- an option to leave a comment (for example, 'I need 2 of these')
- an option for me to group items into categories, so they see all of the items in each category at one time. For example, they see a list of animals and select the ones they want. Then they move on to a list of cars and make more selections there. If they want, they can go back to animals and change their selections before submitting.
How do I do this?
Best Answer
-
Do you want something like this?
You can use a Dropdown list column type with the "Allow multiple values per cell option."
Sheet
Form
Answers
-
Do you want something like this?
You can use a Dropdown list column type with the "Allow multiple values per cell option."
Sheet
Form
-
Brilliant! Many thanks. Works perfectly. Much appreciated.
-
Actually, one more question on this... is there a simple way to add a 'select all' checkbox that would automatically check all the other checkboxes? If the client likes all animals except one, then they might appreciate being able to Select All, and then deselect the odd one out.
-
Unfortunately, a form does not have a Select-All button, as a Sheet does.😅
You can pre-select all items as default, as shown below, or add an All button.
-
Another technique would be to use the form logic.
- Add helper columns, such as Animal from all and Car from top 20*.
- (*) The maximum number of multi-select dropdown lists is 20.
- Add to the dropdown list the 'from All' selection.
- Using the from logic, show the Animal from all and Car from top 20 fields when the "from All" is selected.
- Add helper columns, such as Animal Selection and Car Selection.
- Decide user selection using a formula like this;
- =IF(Animal@row = "from All", [Animal from ALL]@row, Animal@row)
- Add helper columns, such as Animal from all and Car from top 20*.
