TOPIC:

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 5 months 22 hours ago #257717

  • Topic Author
  • dvddvddvd
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 13
  • Thanks: 0
Hello,

1.- It is possible to create in the export csv file a field where the mean of the score obtained in an element that is radio group with punctuation from 1 to 5 is calculated:
0; 1 - Poor; 1
0; 2 - Must Improve; 2
0; 3 - Good; 3
0; 4 - Very good; 4
0;5 - Excellent; 5

2.- It is possible to create a field in the export csv file that contains the different options that have been selected in the form within a Check Box Group element:

0; Through organization people and speakers; Through organization people and speakers
0; Through social networks / Internets; Through social networks / Internet
0; Through UPL; Through UPL
0; Through friends; Through friends
0; Others; Others

Thanks!

Please Log in or Create an account to join the conversation.

Last edit: Post by dvddvddvd.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 5 months 10 hours ago #257732

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6916
  • Karma: 3
  • Thanks: 492
Hi,

the csv file export contains records of some forms.

Basically, if you have those radio button group and checkbox group in your form, selected values will be stored in manage records on submit, and you can export this.
E.g.
-if you select radio button 4-Very good, in csv export for this will be shown 4
-if you select checkbox Through organization people and speakers, in csv export will be shown Through organization people and speakers

If I missed something, please let me know

Regards,
Tihana

Please Log in or Create an account to join the conversation.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 5 months 8 hours ago #257740

  • Topic Author
  • dvddvddvd
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 13
  • Thanks: 0
Hi Tihana,

I think I have not explained myself well.
What I want to do is:

1.- calculate the arithmetic mean in the case of the element that is radio group with punctuation from 1 to 5. For example if there are the following records: 5,4,3,2,1. Calculate and appear a field in the exported CSV file that is the result in this case 3.
2.- In the second case, which is Check Box Group, I would like to see a field in the exported csv file with the number of times it appears each time each of the check box options has been selected. For example:
number of times selected "Through organization people and speakers": ...
number of times selected "Through social networks / Internets": ...
number of times selected "Through UPL": ...
number of times selected "Through friends": ...
number of times selected "Others": ...

Thanks

Please Log in or Create an account to join the conversation.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 5 months 8 hours ago #257742

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6916
  • Karma: 3
  • Thanks: 492
Hi,

I think this can be done in form, but first I need to test it to be sure.

Give me some time, I will test this and get back to you with information

Regards,
Tihana

Please Log in or Create an account to join the conversation.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 5 months 8 hours ago #257743

  • Topic Author
  • dvddvddvd
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 13
  • Thanks: 0
thank you very much

Please Log in or Create an account to join the conversation.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 4 months 4 weeks ago #257819

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6916
  • Karma: 3
  • Thanks: 492
Hi,

I tested it.

In your case, you can count number of records like this:
crosstec.org/en/blog/939-count-number-of-records.html
in specific field and show this in csv.

I hope this is ok for you

Let me know if you need more help

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Time to create page: 0.051 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!