Do I use Calculated field for submission form? RESOLVED

On my formID=52934584917973 I have a section for requesting a rulebook.

I have realized that if the first or second options are selected we really do not get a value of 1 for either on our submissions.

The third option opens a window to request up to 10 copies and this value appears on the submissions.

I have added a calculated value of 1 to the first two options but now I'm stuck as to how to make the value appear on submissions.

Do I make a calculated field that is hidden and show this value on the submissions form?

Or could I use the existing "Number of books required" field that has a minimum value of 1 only if option 1 or 2 are selected?

TNX,

Robert

The calculation value is used to give the text options a number value for the calculation. If you would like the options to appear as "1" in the form submissions, you could use the "Number of books requested" field approach. 

You can also get the value by adding the field in the calculation. Here's how: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form. 

Let us know if you need help for this.

Yes :) We're here to help, just please let us know if you need one. 

Yes, the conditions should work. But the field is hidden so you will have to change the settings from "Clear Hidden Field Values" to "Dont Clear". Otherwise, the value will be cleared on submit.

Or, show the Number of books requested when the options are selected instead of hiding it from the form.

Please try that and let us know if there are problems.

OK so I did as suggested but the value is not showing up in the number of books requested field in my submissions reports. 

Question:  Do I really have to put a calculated value into the fields, Rulebooks Request, if the Number of books requested field already has a value of 1 as default?

From my point of view, that's not needed, the Number of books requested  field has a default value of "1":

And if Rulebook Request field is equal to "I am a new member, Please mail a copy to me" or "I am a current / renewing member and have not received a hard copy, Please mail a copy to me", a value of "1" will be updated to Number of books requested  field.

So, no really what you are trying to accomplish here.

Hello AA_C,

I did check your form and did not find any issue with that. I cloned your form and tested it with multiple combinations. I am unable to replicate the issue you are having. When I selected "I am a new member, Please mail a copy to me", the value of "Number of books requested" was captured correctly. Please check the screenshot below:

On which submission you had this issue? I did check last several submissions you have received in your form #52934584917973 and none of them have selection of "I am a new member, Please mail a copy to me".

Please let us know the on which submission you have this issue and we will take a look.

We will wait for your response.

Thank you!

On SubmissionID:  326438654221337651                    

As you say the number of people requesting a book is few and far between.

This was not the case early on, before I made the change so perhaps I need to wait for one asking for a book before I see if a problem exists or not.

Thank you

Robert

Hello AA_C,

Have you updated your field "Rulebook Request" recently? The submission you have received have selected value as "Not Required" which is no longer in your form field. Please check the screenshot below:

You have added condition where if the value is "I am a new member, Please mail a copy to me" then only the value will be populated in the textbox. Please check the screenshot below:

You may also like to check the "Calculation Values" setting of your check box question as well and you seems to have only added for two option. Please check the screenshot below:

Thank you!

1. As you see the answer: Not required appears because the form is embedded at our site. I changed the value so the mail recipient only gets required info not a long statement. 

2. On your second point in calculated fields. So should I remove them as they do nothing for the form?

3. For the 4 options values and I only have a 1 for the first 2, you suggest a value for the next two,so perhaps a 0 for fourth but the third can be a value between 1 and 10, should be be set to 1 or what value would you put there.

TNX

Robert

1. Did you embed your form using source code? If the form is embedded using normal Javascript embed method or iframe embed method, the form should be automatically updated on your webpage. If you have embedded the form using source code, you'll need to re-embed the form with the updated source code again.

2. The condition may be updated as shown below to simplify the calculation. 

This would help in inserting the RuleBook calculation value to No. of books requested field. The calculation values for the field Rulebook request can be set as shown below.

Since the number of books requested field is displayed only when extra copies option is selected, the default option will be shown as 1 and can be increased upto 10. 

Hope this information helps!

Hi,

I embed using source code and always update my changes.

The information is very helpful.

Many thanks to all,

Robert

This may be a new post.

TNX

Robert

Hi,

On behalf of my colleagues, you are welcome.

Your second question has been moved to this thread : 

http://www.jotform.com/answers/730068 

This is in order to avoid any confusion and assist you better.

Thanks.

Hi, I just received a new submission and the field had a value. So it works as planned.

We can considered this one RESOLVED.

Many Thanks To One and All for a job well done, AGAIN!

Seasons Greetings from the AAC

Robert

Hello Robert,

On behalf of my colleagues, you are welcome.

I am glad to know that your issue is resolved.

Do get back to us if you have any questions.

Thank you!