Clearing "answer selected" values in a quiz app

In my quiz app…
(1) The user sees one question (and its multi-choice answer options) at a time. This is based on a Helper table, which takes each question one by one from the main data sheet.
(2) I use an Options component to show the multi-choice answer options for each question.
(3) When the user selects their answer, the Options component writes the answer to an “Answer Selected” column in the data sheet.
(4) The Answer Selected is used for various things, such as comparing against the correct answer to see if the user’s choice was right, keeping scores, and “Your answer was…” messages, etc.

The Problem:
If the user retakes the quiz, all of their selected answers from the last time are still there. I have made up a workaround where the “Go to next question” button clears the Answer Selected column in the Helper table, which ensures that at least the question shown on screen has no Answer Selected remaining. But I want to clear selected answers from ALL of the rows of the Alnswer Selected column in the data sheet so that the user takes the whole quiz afresh.

Is it possible to do this? Thanks in advance for your advice.

Do the answers go into a User Specific column?

If yes, then your current approach is really the only way.
If no, then you would be able to clear them using either a server-side workflow, or the API. Both options require a paid plan.

2 Likes

Thanks for responding. Yes, the Answer Selected column is user-specific so… damn.