Hello, I am new to make and I am trying to bulk update my rows from a multiple choice grid in google forms, If anyone could help me would be much appreciated.
Just for clarification I am trying to test this process by asking favourite soft drinks with their variations. E.g coke - coke zero - coke no sugar - diet coke
fanta - fanta no sugar - raspberry fanta.
The probem I am having is that I only want the selected drinks to be transfered to the google sheet and I want it to include the question name (fanta) + the variation. Cheers
Hi Monty,
google forms has internal automation with google sheets where it will store responses in sheets directly. Wouldn’t this work? Or do you need to process the responses before storing them?
Im not really sure. I just want to make it so that only my selected answers are transferred because some will be left blank. Not really sure how to map that in my value box for the sheets module.