Hi Stephanie,
I love this plugin and have been using it for over a year. The Add-ons are great, too.
I’m not sure how to accomplish this:
I have a restaurant evaluation form that I need to re-create online. It is in table format; there are several Categories (Facility/Environment; Service; Food & Beverage), each Category lists the criteria, and the User assigns points and comments to each criteria. There are about 8-10 criteria listed under each Category.
SERVICE:
Exterior of Restaurant 5 Was neat and clean.
Service 5 We were promptly greeted.
TOTAL FOR THIS CATEGORY: 10
etc.
I would like each Category to have a Total, and then at the end of the form, a Total of all Categories, for a final score.
I inserted a Category using the new Table feature in Form-Plus, and I LOVE the way it looks…but I don’t see how I can add a calculation within the “Points” field in that Table. Is that possible?
I did not see that option,
so I decided not to use the Table feature and instead am using the Scale field.
1. How do I Total the Scale fields for each Category?
2. How do I Total all of the Category scores into one Final Score at the end of the table?
3. How do I insert a “Comment” field to the right of each criteria/scale field?
I don’t know JavaScript at all, but can paste in some PHP code if you tell me where exactly I need to paste it.
Thank you very much in advance for your help. Hope I’ve described my task clearly!!
Elaine
July 13, 2011 at 1:00 pm
I'm not familiar with the table field add-on. That is a question to ask the developer of that plugin.
You can calculate totals for the scale fields by:
1. Add hidden or text read-only fields for each calculation you would like in your form (one for each category and one for the total).
2. Add some javascript or php depending on whether you want to value to be calculated as the user makes selections or after they hit submit. Let me know which you would prefer and I'll point you to some examples.
You can add a comment field next to the scale field with a little change to the customizable HTML.
http://formidablepro.com/help-desk/align-fields-side-by-side/
July 14, 2011 at 8:31 am
Stephanie
Thanks for your response!
The Table field add-on looks great. I didn't realize you were not really connected with that plugin. It would be ideal if the calculations could be added to the Table fields but if not...
I will have to use the Scale field because the calculation aspect of this is the most important part of this evaluation form, SO:
1. I'd definitely like to know how to add the hidden/text read-only fields so that each Category would be totaled, and I would get a final total.
2. It would be great if the user could see the calculations as they go along; they are doing an in-depth review of a restaurant, as "Secret Shoppers." The only thing with this part, honestly, is that I am at a Beginner level in terms of php, and know nothing about Javascript. I AM able to find/open/paste into .php files of course...if you could just tell me where exactly to paste!! :)
I greatly appreciate your responses; my client is eagerly awaiting this form.
ps the form, which is in draft/experimental mode right now, can be seen here: http://dalesgrill.com/secret-shopper/ you'll see that I've used BOTH the Scale field AND the Table field so you can see both. I really like the way the Table field looks!
July 14, 2011 at 7:01 pm
How about this....
I've updated the built-in calculations to cover radio buttons and drop-down select fields. These changes are uploaded in the latest rc version. You can download it here:
http://formidablepro.com/manual_downloads/
July 15, 2011 at 11:47 am
woo hoo! that worked!
FANTASTIC! it looks great!
I will send you a link to the form when it's complete so you can see it in action...it's exactly what I need.
Thank you SO MUCH Stephanie for going the extra 20 miles on this one...
Elaine
July 15, 2011 at 1:12 pm
hi Stephanie,
sorry, one more thing (it's a small thing!):
the form works beautifully except that I am not able to get the 'grand total,' or the total of all the categories. It does not display for the User, nor does it show a total when I fill out and submit the form.
I THINK that's because the Category totals (or we could call them the Subtotal fields) are NOT Scale, Radio Button, or Drop Down fields; they are Text fields containing the sum of the calculations of the Criteria fields above it.
I THINK the only way around this then is to add ALL of the field IDs for all the Criteria fields, NOT the Subtotal fields, in order to get the Grand Total.
Is that correct??
Other than that I'm lovin' this form!
You can see how it's going so far (I will not be displaying it on the website's layout; I just want it to display as a simple Formidable, white background form, but for now I'm just building it and will deal with display later).
thanks!
Elaine
Edit: oops, here's the link: http://dalesgrill.com/secret-shopper/
July 16, 2011 at 11:05 am
Yeah, I think it would work better to total all the fields individually for the Grand total rather then using the Subtotal fields. The reason for this is that some browsers (like IE) might not recognize that those subtotal fields are actually changing.
July 18, 2011 at 10:23 am
OK, got it; I can work it that way and still get the result I need, thanks!
it's always IE, isn't it?! :)
thanks very much, Stephanie!!
Elaine
July 19, 2011 at 10:24 am
Hello, I'm struggling to figure out how the above was done. I've developed a form that helps me see how those in our organization understand our missional purpose. I have 5 categories on the form. Each category has 10 questions with a scale for 1 to 10 on each question. Here's what I want to be able to do.
1. I want to show a average for each category per current user and total average of all users.
2. I want to be able to display in a graph the same info, i.e. average per category per current user and total average of all users.
I've looked through the knowledge base, wiki user manual and I must have over looked this somewhere. Please advise. Thanks CJS
July 19, 2011 at 10:53 am
You can find instructions here:
http://formidablepro.com/knowledgebase/field-calculations/
You must be running the latest version (1.5.4) in order for this to work with scale fields.
1. Add a hidden or read-only field for each calculation (5 in your case). Then follow the instructions on the linked page to insert those calculations.
2. Each of those five fields will have graphs associated with them, just like any other field.
July 19, 2011 at 10:58 am
Okay thanks for quick response will try that. CJS
Topic closed.