TOPIC:

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!

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

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

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

thank you very much

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