- nextstepdublinAsked on April 15, 2014 at 05:56 PMI have just made a form to use with some of my clients who are working with low self esteem.The form has 30 questions and each question has a drop down response with 5 possible answers scored from 1 to 5. The score interpretations are as follows:SCORE INTERPRETATION 0–30 Not affected by low self–esteem. 31–45 Traces of low self–esteem. Take preventive action to reduce its impact on your life. 46–61 Presence of mild low self–esteem in your life. Take steps to treat this. 62–90 Presence of moderate low self–esteem. Take steps to treat this as soon as possible. 91–120 Presence of severe low self–esteem. Take steps to treat this immediately. 121–150 Presence of profound low self–esteem. Take immediate step to treat this and seek out professional help to assist you in this process.How could I arrange so when a client fills out a form, it is automatically sent to excel or equiv. and scored. What would be great would be for the score along with the above interpretation to be emailed back to the person who filled out the form. Or am I just engaging in wishful thinking?Thanks
- jedcadornaAnswered on April 15, 2014 at 11:04 PM
How could I arrange so when a client fills out a form, it is automatically sent to excel or equiv and scored.
You can use our integration to autamatically send your submission to your Google Spreadsheet account but the calcuation would be done by downloading your form source and making a custom script to compute base on your requirements.
Here's a guide on how to integrate your form to spreadsheet http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet
What would be great would be for the score along with the above interpretation to be emailed back to the person who filled out the form.
You can setup an autoresponder here and add an email field and make it required so user will be required to fill in the email field and once the form gets submitted the user receives the result base on the custom script with a field (Total score).
- nextstepdublinAnswered on April 16, 2014 at 04:31 AMGreat advice. Happy bunny now. Many thanks.