Is it possible to design a survey form where skip questions are auto-filled by "99"?

Support
1

We know unfilled/skipped questions are always blank in the result excel sheet. I want all skipped and unfilled questions are auto-filled by "99". Is it possible? It means there is no empty cell in the excel sheet.

2

Hi @TanzilHuda

I can think of three options (possibly there are more):
a) You set a default response
b) You create a calculate fields with "if" condition replacing skipped and unfilled questions with the value you want (e.g. "99")
c) You make all questions mandatory and add a hint saying "Enter '99' if don't know or refuse to answer"

I hope this helps!

Best,
Andrea

2 Likes