Google-forms – Google Forms – two required questions – accept with at least one of them

google-forms

I collect links to historical records describing persons falling into certain categories (e.g. secret Protestant or vampire/witch case). User specifies the Category with a checkbox answer (multiple options possible).

I want to add more options, describing professions. But now the checkbox list would be too long.

I want to do either:

Add a separate question Profession. One of the the two questions Profession and/or Category must be filled in (required question) or
Format the Category question so that the options are organized into sections or the checkboxes appear in multiple columns.

I do not want to add additional form page.

Best Answer

There is a paid plugin for Google forms Formfacade that can change layout into 2 columns.

Another option would be to build a form manually and post the response to the Google form.

Related Solutions

Google-forms – Adding Multi-choice Questions faster in Google Forms

In your spreadsheet copy the column of cells with your choices. (Don't copy the whole column.)

In the form's multiple choice question select "Option 1".

Paste in your cells. (CTRL-V or CMD-V on Mac)

Google Sheets – Sort Function Moves Data to Bottom

Cells containing the empty string "" appear empty but are not (isblank returns FALSE for them). They get sorted ahead of nonempty strings, which is not what you want. To avoid this, replace

if(isblank(B1:B), "", datevalue(B1:B))

by the simpler

iferror(datevalue(B1:B))

The command iferror returns its (optional) second argument if there is an error evaluating the first argument; otherwise it leaves the cell blank. Blank cells are sorted to the bottom.

A potential drawback of the above is that misformatted dates are simply ignored, while you may want to see and fix them. This is something you can address separately; e.g., have a column with

if(isblank(B1:B), 0, if(iserror(datevalue(B1:B), 1, 0))

and sum over it to get the total number of nonempty but invalid date cells.

Another potential issue is that you are sorting a range containing arrayformula. The sort may move the formula to another row, creating a mess. It's safer to exclude the header row from sorting. Replacing

var data = JobList.getDataRange();

var data = JobList.getDataRange().offset(1,0);

would do it.

Best Answer

Related Solutions

Google-forms – Adding Multi-choice Questions faster in Google Forms

Google Sheets – Sort Function Moves Data to Bottom

Related Topic