How to limit what is Added to my sheet to information associated with just one Choice

I have an Add Screen on which there is a question with 3 Choice components (A, B, C), each with their own unique followup questions. Answers to each choices followup question go to unique columns on my Sheet.

I would like to enable users to make just one choice (A, B or C) and to answer the followup questions to that choice before adding.

How do I prevent a user from making a given choice (say A) filling out the following up questions - then changing their mind and making another choice (say B) and filling out B’s followup questions before Adding? Obviously, if this were to happen, I would have data from both Choices in my sheet with no way of knowing which choice is the correct one. Ideally, there would be a way of automatically ‘clearing’ all the data associated with one (eg. A) if the user selects another choice (say B) before Adding - but I did not see such an option.

Any help or insight would be appreciated.

Screenshots attached.

Screen Shot 2020-08-15 at 4.22.17 PM Screen Shot 2020-08-15 at 4.24.41 PM

Well, technically you would still know which answered questions are the ones to use and which ones to ignore, because your ABC choice would be saved to the form as well. I have this same problem in a few places in my app, but I haven’t worried about it too much. I don’t think there is currently a way to clear the fields (short of using a script in the google sheet), but if necessary, you could probably use if/then columns or conditional visibility to only display the answers that are associated with ABC choice. Not ideal in all cases, but an option for now. That’s a tough situation, because I’m sure there are other situations where you want to hide the entry, but still retain it’s entered value.

2 Likes