As far as I know, LimeSurvey can't auto update a spreadsheet with the answers.
But LimeSurvey has its advantages:
- it's in PHP, and our whole infra is already using it (WordPress and Nextcloud). So it's easier to setup and if we want bridges between these tools, it'll be easier.
- AFAIR, it doesn't require JS when filling a form and in particular, it's not a React app.
We have used LimeSurvey in the past, we got rid of it but I don't remember why, I should look into it another time.
Two other big requirements we have is solid conditional field support and easy to use form builder.
Reason why I ask is that there are many form/survey builders out there, as people often underestimate the complexity it takes to set one up that supports things like max diff, routing etc.
Looking at the forums I can see that some have managed to achieve what you need via plugins (albeit the one I see that is confirmed working seems to be paid…)
Just thinking contributing an open source plugin to a great open source scripting tool would save you headaches down the road :)
