Online forms with spreadsheet functionality?

Question

I had hoped to get this from Google forms but, after a quick run through the online docs, it doesn't look nearly sophisticated enough.

Problem: I need an online form where the questions asked are a function of spreadsheet calculations. More specifically, this is for a kid's swimming club, where the user first has to enter a name from a pulldown list. At this point, the form must itself look up a date of birth, and decide for itself which events a child can be entered for, based on the date of birth, the qualification times, and the actual achieved times. Once the app has all this information, it presents a list of checkboxes to the user, asking them which event he/she wants to enter. Finally, it adds up the number of entered events, and tells the user what the entry cost will be, before sending me the name, the list of events, and the cost.

So, basically, it's an online spreadsheet, but with the smarts to send me back each user's entry list and entry cost.

Can I get this from an online app somewhere, or do I have to write it myself? If not, I can write the front-end in JavaScript, and talk to a server in Ajax, but I don't have any clear idea on how to handle the back-end database stuff. Ideally, this would be a CGI app that runs 'queries' on a spreadsheet; I don't want to learn SQL for something this simple.

Thanks.

Answer 1

Many online form builders let you do this through branching where branching is just simple logic. If a user answers one way show this question, if they answer another way show this other question.

Wufoo and Formstack are two form building software that support this.

Links point to the feature page on branching/conditional logic.

Answer 2

This can be done using Google forms and spreadsheet together. Googling google forms validation can bring up lots of javascript libraries which enable you to do this.All you have to do is use the google spreadsheet API and google forms together via the JS libraries.

Answer 3

Online forms with spreadsheet functionality is definitely in here. No, you need not have to write any technical code for this. You can automatically generate online form with all built-in validation constraints for data collection also collect error-free validated data from multiple sources or team members using ready online forms by embedding in your website or via public URL. Check CollateBox forms.

Athar,

Evangelist @CollateBox