The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/printthread.php 76 forum_permissions
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
calculate average results - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: calculate average results (/showthread.php?tid=1317)



calculate average results - rnog - May 17th, 2011

Hi,

I installed form tools a few days and currently I'm testing. My first impression is that seems a very good application.
Right now I have a doubt: it is possible to form tools, through viewing or print export, display the average result of a particular field? ie, for example, a form asks, in last field, to evaluate (1-5) a certain theme. is possible to form tools calculate an present the average of the results achieved to date?

Regards
Thanks

Rui


RE: calculate average results - Ben - May 19th, 2011

Hi Rui,

Neat problem! So do you need the information stored anywhere, or just calculated and displayed?

- Ben


RE: calculate average results - rnog - May 21st, 2011

Hi Ben,

First, thanks for your replay.

Honestly, I do not know if I liked that the information be stored (because it is constantly being modified with new entries).
I'm imagining creat a "view" that have an extra form in the database only for calculations, where each field of this form would be allowed to create a formula for calculations (sum, average, ....) their results will be presented at the end of the list of the "view. " Do you see what I'm saying?
What I describe is will be ideal for what I intend to do, but there may be a simpler way.

thanks
rui


RE: calculate average results - Ben - May 22nd, 2011

Hmm.. tricky! So I've given it some thought and no matter how you approach it, you'll need a separate module to do this. Even if it doesn't store anything in memory, it will still need to parse all the submissions and do the math. Then, it would need to display the result in the page somehow.

The simpler solution would be to just use the CSV or Excel export and within Excel, add a rule to calculate that information for you. Would that be feasible in your case?

- Ben




RE: calculate average results - rnog - May 26th, 2011

Ben,

Export to excel certainly achieves the desired result. However the project I'm considering using Form Tools considers that users only have access to data via web. when the amount of data is too large, the best way of reading is summarizing the results (number of form responses, average evaluation ...) It would be interesting to have a reporting tool in the Form Tools
I will continue explore this tool as it is now very interesting and has good potential

Regards
Rui