Digestible answers from google forms to spreadsheet, how right?

Question

Google Apps Script

Hello.
There was such a task:
there is incoming data from Google Forms - an inspection act, answers are dumped from it into the table, and there is a problem with only two questions: the type of these questions is "several from the list", and the items are named quite long, and when all the items merge into one line, then working with them is not at all convenient.
Not only do they need to be divided, compared and inverted in order to visually evaluate the result, but also the processing formula in each cell does not leave the computer with free resources.
How to make formula processing by trigger - for example, a line appeared, processing in a formula, output to a sheet?
Or how to set up Forms for a more convenient output?
Ps Breaking into separate questions and changing the type of questions is not an option, the form is filled out from a tablet, and a picture is attached to each item, which the employee points at.

Answer 1

Don't use "formula processing on trigger" in this case. You just need a script that will convert the current data into suitable forms for the report. Without an example, it's hard to say exactly how to split the data, but in the general case it will look something like this https://productforums.google.com/forum/#!topic/doc... There the task is somewhat more complicated than yours, weights of occurrences are calculated for each answer. Copy the Table, the report generation menu will appear in it.
Consultations https://google-apps-script-russian.gitlab.io/page/...