Webform calculated/computed values

Hey Vernond,

Thanks a lot, it did solve my problem. I created a questionnaire using webform at my test site and used your module to calculate the results. Overall, your module did a great job, but it was an overkill for that. All I wanted was to sum-up a bunch of fields, I had to do it in a "chain" and create many calculated fields for that, moreover, for each one of the calculated fields I used a condition of - "if X equals X" in order to make it work. A couple of times I edited the X field, and than I had to recalculate all from scratch.

A couple of ideas -
1.have an option to calculate without a condition
2. longer formulas with more than two variable - maybe even free hand formulas according to the field-key (e.g, field-key1 + field-key2 * field-key3)
3. It would be nice to be able to hide the calculated fields in the form.

I'll keep working with your module and give you more feedback.

thanks again,

Botser.

@vernond, It was my pleasure to test-drive your module, I would be happy to do the same in the future. As for writing my own plugin-module, so indeed I am not a developer, and I don't have a clue on how to do it. I build those forms in order to have online patients well-being questionnaires (you can see some of my research products at my website ). For a non-developer, it was very hard to find calculating form functionality on the web. This functionality is useful beyond the medcial field or creating invoices, for example calculating the result of an online test for students? And Since webform is a very simple to use module, it lets regular users create custom-made forms without being a drupal expert.

As for the calculations, I don't really care about "quick n' easy", as long as it is working well. Although it can be nice to have a simpler solution for the calculations. However, I would like to know how to hide the calculated fields, those make the form look unprofessional.

Thanks again

@vernond, thanks a lot :)
The calculations working great, and the fields are hidden, I couldn't ask for more.
Anyway, I think maybe there should be an option of yes/no for the hidden. When the fields were visible, I have found that if the "Automatically save as draft between pages" option is checked than the calculation results can appear in the next pages. Such an option to make will allow to show the final result on the last page, something like - your score is XX

Anyway, again thanks a lot, you made my day, I would love to feedback your modules whenever you need.

One other issue that came up today while working on the calculations is that the computed fields formulas reset every time a field is moved in the list above it. For example, moving a page-break or creating a field and moving it up deletes all the formulas :(
We are going to work with it anyway, just very carefully.
Do you think it would also happen if you would use the field-keys instead?

Another thing, I am using "conditional rules" module as well, however, its options are in between the CALCULATE and SWITCH-CASE, that is a bit confusing.

@Vernond it is my pleasure, and no prob. with the new calculations.
Anyway, try to think of a solution for the Grid component as well. Take a look the form I have right now , after the 3rd page all questions has the same answers, however, without the Grid it's a mess.

Also, take a look at #1095782: Add a sum up column to report talking about statistics and summing up grid-component in webform-report module. Maybe it can give you an idea of how to do it.

One last thing to consider, in the Grid questions, I'm excluding the N/A answers from the calculations. So, if a patient answered all N/A but one question, his score will be calculated only according to that question. So, I should have an option to count how many were answered not N/A.

Sub

"Dates and times can be used in comparisons assuming you use the same format as they are stored in the database."

How to find the format of value stored in database?
Ok found it in the variables listing in phpmyadmin.

It says
date format %Y-%m-%d

datetime format %Y-%m-%d %H:%i:%s

"Dates and times can be used in comparisons assuming you use the same format as they are stored in the database."

Ok found it in the variables listing in phpmyadmin.

It says
date format %Y-%m-%d
datetime format %Y-%m-%d %H:%i:%s

I am trying to subtract two dates.
Using Drupal 6.17 and the module from http://drupal.org/node/1251902#comment-4922646

Have tried setting site date time format to each of them but each time get the computed value like this 2011-10-102011-09-01

@vernond thanks a lot for the module, for the D7 in particular. I will update as soon as I have some constructive comments.

good job!
can i caculate more than 2 values ? and hope you can make the value caculated by ajax.
thankyou!

@vernond at last I had a chance to evaluate the D7 version. It is working well, although , there are some error messages when creating or updating computed fields.

This is when I create a field

Notice: Undefined index: cid in webform_computed_allow() (line 729 of /home/botser/public_html/hipain.info/sites/all/modules/webform_computed/webform_computed.module).
Notice: Undefined index: cid in webform_computed_allow() (line 729 of /home/botser/public_html/hipain.info/sites/all/modules/webform_computed/webform_computed.module).

And this one when I update a field

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in _form_set_class() (line 3993 of /hipain.info/includes/form.inc).

Anyway to see the computed field in work, you can evaluate your hip using the form I created - at http://www.hipain.info/content/modified-harris-hip-score-mhhs#

this is great. Are you planning to release this as a project on d.o ?

subscribe

+1

very interested and subscribing

Vernond, will this become part of Webform? Or a separate (sub)module? Is there a way to check out the latest version?

Just wondering, so I know where I should place my issues, questions and maybe patches even. I have the feeling this could become a runaway thread very soon. Already support requests, subscribes and general discussion are weaving through each other here. I think there is much interest for this functionality
Downloading the D7 version from #12, will give feedback soon.

Just tell me where ;-)

Like botser in #21 I get the following while using D7 version:
Notice: Undefined index: cid in webform_computed_allow() (line 729 of [installpath]/sites/all/modules/webform_computed/webform_computed.module).
As many times as the number of webform fields already defined.

I believe its because the $component['cid'] on that line. When I chance it to $cid the errors disappear. As far as I can tell the $component array does not contain a 'cid' key. Unfortunately I don't totally understand that bit of code. So I don't know what consequences changing this has (except for making the errors disappear.) Nor can I provide a patch to fix it.