I have no programming experience and want to create a website or application for entering data through a questionnaire with many conditional questions and possibly repeating sections. The questionnaire should be able to populate answers based on earlier responses, skip questions, and dynamically add questions when needed.
The destination Excel file already exists and was originally designed for a paper questionnaire. I cannot change its structure. After someone completes the questionnaire, I would like their responses to populate that Excel file and allow them to download a report in PDF or Excel format.
I tried using Google Forms, but its conditional logic is not flexible enough for what I need. I am currently considering SurveyJS, although I am open to other recommendations. What would be the best approach or tools for building this, and what should I plan before getting started?
1 Answer
This is more than just creating a form. You’ll need a questionnaire interface, conditional-logic handling, storage for responses, mapping from each answer to the correct cells in the existing workbook, and a PDF or Excel export process. SurveyJS may handle the form and branching, but you’ll likely still need JavaScript code and possibly a server-side component for safely generating files. Since you’re starting from zero, build a very small prototype first—perhaps five questions and one export path—or consider a low-code consultant if the workbook and branching rules are complex.
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically