I have a Google Form with some questions for which the user has to choose an answer from dropdown. The answers in the dropdown lists are fed from a Google Sheet.
Because I would like those dropdowns to be dynamic, I was wondering if there was any way in which I could instantly get the answer given by the user on a dropdown written to a Google Sheet. That way, I could change what came up in the next dropdown list.