I have created a 40 question language test using Webflow Forms on my site which at the moment just sends an email with the answers. I am now looking to see if I can automate the scores so we do not have to work this out each time. After doing some searching it looks like I need js code to do this but I have no idea how as I have never done web dev before. I guess that means I have 2 possible options…
Option 1 - Javascript - Is this crazy hard or would I be able to take an example bit of code and edit as needed?
Option 2 - Zapier - I thought about maybe using Zapier and sending the results to some other form builder where I can add IF/Case statements but then I thought it seemed a bit crazy building a webflow form to send the results to another form builder.
So in short I was just after some advice on where and how I could proceed. My preference is to keep it all webflow if possible.
PS Thanks in advance for taking the time to read my question.
Mark
OK, Thanks. JavaScript it is!
However as someone with 0 javascript experience is this something I can realistic do?
My background is ETL/SQL so I literally have no idea where to start.
I do something similar, just not on a website. I track my car gas mileage pretty religiously, when I fill up I enter in the fillup details, then open my spreadsheet that has some formulas there already. I would like to develop it a bit further but I would really need to get into a database of some sort for that really.
In another spreadsheet, for my taxes, I input some expenses, choose a classification option, which then puts the amount added to another section to give me a total for that class of spending (i.e. meals, transportation…). For this, you’ll need to look into Create an in-cell dropdown list - Computer - Google Docs Editors Help to help with that. Works great once setup.