# Is this Form Setup possible?

• George Marinov
Asked on March 10, 2017 at 03:35 PM

I apologize if this message has been duplicated, Im just uncertain whether or not it got sent.

Hello dear JotForm reps!

I am currently in the process of building a digital goods website on Wix, which requires users to fill out a questionnaire, which would then redirect them to the specific digital product.

I've been looking through only form creating services, and I have to say, you guys seem to have made it super-awesomely easy to do, which is great considering our technical skills extend to pretty much the first season of Mr. Robot and whatever we can scrape off google in half-a-frustrated hour.

But here is what we would like for our website form to be able to, and we really hope this would be possible through your service:

- The user completes the q-nnaire at his/her leisure;

- Afterwards, we would like, if possible, for the questionnaire

a) reverse score the answers to certain questions we have set up  (i.e. a score of 7 would be = 1, 6 = 2 etc.)
b) sum those answers with the answers to other questions specified by us  (i.e.  Q2 is reverse scored so IF Q2 score = 7; then Q2 becomes =1) (Then we add Q2 score =1 and Q3 score= 5; so together they make QSet1 = 6)
c) Afterwards find the average of all such question combinations we have specified ((Q2+Q3)/2;(Q4+Q7+Q6)/3;(Q5+Q9)/2 etc.) and compare them.
d) depending on which one is the largest, redirect them to pages X,Y,N,Z etc.

So basically something like this:

How much do you agree with the following statements:

Q1:I am a very good form creator
1 - Disagree strongly 2 - Disagree  3 - Slightly Disagree 4- No opinion 5- Slightly Agree 6-Agree 7-Strongly Agree

Q2: I am a very hard to use form creator:
1 - Disagree strongly 2 - Disagree  3 - Slightly Disagree 4- No opinion 5- Slightly Agree 6-Agree 7-Strongly Agree

Q3:I am a very happy person
1 - Disagree strongly 2 - Disagree  3 - Slightly Disagree 4- No opinion 5- Slightly Agree 6-Agree 7-Strongly Agree

Q4:I am a very sad person
1 - Disagree strongly 2 - Disagree  3 - Slightly Disagree 4- No opinion 5- Slightly Agree 6-Agree 7-Strongly Agree

So lets say the Use gives the following score: Q1 - 7; Q2-1; Q3 - 6; Q4 - 1. We would like to previously have specified that Q2 and Q4 are both reverse scored.
Then the questionnaire calculates scores in the following sets, which we have previously set up:

(Q1 + Q2)/2 - "Form Liking Score"
(Q3 + Q4)/2 - "Happiness Score"

Because Q2 is reversed, the scores for the first set then becomq (7 + 7)/2 = 7 Overall "Form Liking Score"
Because Q4 is also reversed, the scores for the 2nd set become (6 +7)/2 = 6.5 Overall "Happiness Score"
And because Overall "Form Liking Score" is larger than Overall "Happiness Score" the user gets redirected to page X, and if the reverse were true, he would be redirected to page Y.

Basically this is my desired setup. From what I saw, this can be accomplished by creating rules. The problem is that the actual questionnaire is 15 questions long, with 3 questions per set, each set with at least 1 reverse scored question, again with these 7 possible answers. So the number of IF>THEN rules that have to be created I believe become quite substanial in number and complexity, and as such the chances of me missing something or there being an error somewhere along the way is quite substanial. Or I might be mistaken of course.

If the described setup is not possible, any workaround that will produce the same effect will be more than acceptable.

I would like to also ask if this survey can be implemented into a Wix site, with no real hassle.

I look forward to hearing from you, and I pray that my described setup can be achieved through your services because god forbid i have to return to those disinterested folks at 123forms, whose response I still await after 4 consecutive business days....

Have a nice day for now,
George Marinov

• EltonCris
Answered on March 10, 2017 at 09:37 PM