Bienvenido, Invitado
Recordarme

TEMA:

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 7 meses 1 semana antes #257717

  • Autor del tema
  • dvddvddvd
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 13
  • Gracias recibidas: 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!

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Última Edición: Post by dvddvddvd.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 7 meses 1 semana antes #257732

  • Avatar de tihana.krivic
  • tihana.krivic
  • Fuera de línea
  • Moderator
  • Moderator
  • Mensajes: 7785
  • Karma: 3
  • Gracias recibidas: 549
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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 7 meses 1 semana antes #257740

  • Autor del tema
  • dvddvddvd
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 13
  • Gracias recibidas: 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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 7 meses 1 semana antes #257742

  • Avatar de tihana.krivic
  • tihana.krivic
  • Fuera de línea
  • Moderator
  • Moderator
  • Mensajes: 7785
  • Karma: 3
  • Gracias recibidas: 549
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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 7 meses 1 semana antes #257743

  • Autor del tema
  • dvddvddvd
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 13
  • Gracias recibidas: 0
thank you very much

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

FIELD IN CSV EXPORT FILE WITH SCORE CALCULATION AND COUNTING OF CHECK ITEMS 7 meses 1 semana antes #257819

  • Avatar de tihana.krivic
  • tihana.krivic
  • Fuera de línea
  • Moderator
  • Moderator
  • Mensajes: 7785
  • Karma: 3
  • Gracias recibidas: 549
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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

  • Página:
  • 1
  • 2
  • 3
Tiempo de carga de la página: 0.057 segundos