Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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.

share|improve this question

closed as off-topic by Eight Days of Malaise, Alex, Jacob Jan Tuinstra, Vidar S. Ramdal, jonsca Mar 15 at 10:48

This question appears to be off-topic. The users who voted to close gave these specific reasons:

  • "It is a question about creating/developing a web application." – Vidar S. Ramdal, jonsca
  • "Application/website recommendations are off-topic and out of scope. It is better instead to use a particular web app or website and ask for help in any issues you have with it specifically." – Eight Days of Malaise, Alex, Jacob Jan Tuinstra
If this question can be reworded to fit the rules in the help center, please edit the question.

5 Answers 5

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.

share|improve this answer

Disclosure: I work for Ragic.

Ragic is a spreadsheet style online form builder (says so right on the homepage). And as for your requirements:

  1. Ragic supports a lot of Excel formulas (to do your cost calculations).
  2. Ragic supports Excel LOOKUP function, and linked sheets to look up value from other sheets.
  3. Provide checkboxes to select multiple events.
  4. Notification ability to notify you of the latest entries and updates.
  5. And you build your form just like creating a spreadsheet form like you're used to.
share|improve this answer
    
You need to disclose your affiliation. –  Jacob Jan Tuinstra Aug 30 '13 at 7:47

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.

share|improve this answer
    
I've done some Googling, and I think that the validation code is only run after submission, which means that I can't put logic into the design of the form questions - is that right? I think that I need to construct everything with a script, but I can't yet see how to get forms functionality from a script. –  EML Jan 16 '13 at 11:51
    
you could send AJAX requests to the spreadsheet api and fill the forms with the necessary values. and you dont really need to learn sql to do that if your using google spreadsheet –  Mevin Babu Jan 17 '13 at 7:50
    
The question has nothing to do with validation, and the whole point of Forms/GAS/etc is to avoid Ajax. I've written the code as GAS; it's far too complicated for Google Forms. –  EML Jan 23 '13 at 17:06

This maybe of use and won't cost anything , it's a script you install in Goggle script gallery: tutorial: http://www.youpd.org/formranger

This may not be able to do exactly what you want , but I think youpd has an extra script, but I can't remember what it is. Take a look at the script gallery

share|improve this answer

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

share|improve this answer
    
Please disclose your affiliation with the service in your answer, otherwise it will be considered spam and treated accordingly. Thanks! –  Alex Jan 23 '13 at 11:24
    
As I said in my other comment, this has nothing to do with validation. If you're going to plug your product, you could at least read the question. –  EML Jan 23 '13 at 17:08
    
Yes, I did read. Just giving an option with out writing technical code. –  Athar Jan 24 '13 at 8:59

Not the answer you're looking for? Browse other questions tagged or ask your own question.