@Kimberley, we with @Helena have found one more way to delete answers for question(s) > via exporting/importing answers table:
- You need to create an export definition (1) with the embedded import definition = custom (2) and data set = answers (3) filtered by question (4) you want to remove. After saving this export definition you will see “Generate import definitions” button > click on it > import definitions will appear in the grid below (5).
Export answers table.
-
Go to this import definition > set “Don’t add new records” = true (2) > go through the field (3) and empty them (BUT keep the GUID field, it is our key value (7)). To empty field > set “Use advanced expression” = true (4) and “Allow null value” = true (5) and advanced target expression = null (6) via the getnull() expression.
-
Validator will help you with the type that is wanted in the advance target expression field (1). Then remove source field (2).
-
Create an import record > set mode = import with an embedded definition and attach the file with answers you have just exported. Click import. The anwers will be emptied, and you can remove the question you wanted.
