x

Glavna poglavja

  1. LimeSurvey Cloud proti LimeSurvey CE
  2. LimeSurvey Cloud – Hitri vodnik
  3. LimeSurvey CE - Montaža
  4. Kako oblikovati dobro anketo (Vodnik)
  5. Začetek
  6. Konfiguracija LimeSurvey
  7. Uvod - Ankete
  8. Oglejte si nastavitve ankete
  9. Ogled menija ankete
  10. Oglejte si strukturo ankete
  11. Uvod - Vprašanja
  12. Uvod – skupine vprašanj
  13. Uvod – Ankete – Upravljanje
  14. Možnosti orodne vrstice ankete
  15. Večjezična anketa
  16. Vodnik za hitri začetek - ExpressionScript
  17. Napredne funkcije
  18. Splošna pogosta vprašanja
  19. Odpravljanje težav
  20. Rešitve
  21. Licenca
  22. Dnevnik sprememb različice
  23. Vtičniki – napredno
 Actions

Primeri ExpressionScript

From LimeSurvey Manual

Revision as of 08:51, 19 December 2023 by Maren.fritz (talk | contribs) (Created page with "- {q2_SQ001.vprašanje}: {q2_SQ001.prikazano}")

Template:Opomba


Struktura

V prvem delu članka bo opisano, za kaj se lahko uporabljajo izrazi in kje najti/dodati izraz. Drugi del vsebuje primere uporabe izraza.


Kategorije izrazov

LimeSurvey uporablja izraze za naslednje namene:


Ustreznost

Namen: Skrivanje skupin vprašanj/vprašanj

Ustreznost nadzira, ali je skupina vprašanj ali vprašanje prikazano ali skrito. Če je rezultat izraza "true" (tj. 1), bo element prikazan. V nasprotnem primeru (če je rezultat izraza "false" (tj. 0)), bo element skrit.

Vrsta Prikaže/skrije Kje najti Posnetek zaslona
Skupina vprašanj Ustreznost skupina vprašanj Ustvari/Uredi skupino vprašanj -> "Enačba ustreznosti:" 30px
Ustreznost vprašanja vprašanje Ustvari/uredi vprašanje -> "Enačba ustreznosti:" 30px
Ustreznost podvprašanja podvprašanje Uredi podvprašanja -> "Enačba ustreznosti:" 30px


Potrjevanje

Namen: Potrjevanje vnosa/dejanja na vprašanja/podvprašanja/odgovore

Validacija nadzira, ali je anketirančev vnos v vprašanje ali dejanje veljaven ali ne. Če je rezultat izraza "true" (tj. 1), bo razred "good" uporabljen za element in potrditveno sporočilo. V nasprotnem primeru, če je rezultat izraza "false" (tj. 0)), bo razred "napaka" uporabljen za element in potrditveno sporočilo. Slog za te razrede lahko deklarirate v template.css.

Type Validates Kje najti Screenshot
Validacija vprašanja vprašanje Ustvari/uredi vprašanje -> "Zavihek Logika" - > "Enačba validacije vprašanja" 30px
Validacija podvprašanja podvprašanja Ustvari/uredi vprašanje -> "Zavihek Logika" -> " Enačba preverjanja podvprašanja" 30px

Izpis besedila

Nameni: (Naredi nekaj) in napiši nekaj besedila

Izraz se lahko uporabi za pisanje besedila. Na primer, lahko preizkusite ali izračunate nekaj in določite rezultat glede na rezultat preizkusa ali izračuna. Uporablja se lahko tudi za vstavljanje besedila vprašanja, odgovorov, vrst vprašanj ... vprašanja, uporabljenega pred uporabo izraza. Izhod besedila je mogoče uporabiti povsod, kjer je prikazano besedilo, in lahko vrne vse vrste rezultatov.

Primer uporabe Opis
Mikro krojenje Prilagodite besedilo, npr. napišite »gospod« ali »gospa«, odvisno od vprašanja o spolu, postavljenega prej
Izračun Izračunajte vrednost in jo izpišite, npr. "Vaš družinski dohodek je xxx"
Referenca Vstavite besedilo iz elementa, npr. "Ime ti je xxx. Koliko si star?"


Shranjevanje odgovorov

Nameni: (Narediti nekaj,) (napisati nekaj besedila) in shraniti nekaj v bazo

Vrsta vprašanja enačbe se lahko uporablja za shranjevanje nečesa v zbirko podatkov. Nekaj lahko naredite z izrazom, prikažete vprašanje enačbe (ki je podobno prikaz besedila) in shranite rezultat izraza v zbirko podatkov. Odgovor shrani v tabelo odgovorov. Nato lahko rezultat uporabite v statistični funkciji ali pa ga lahko tudi uvozite v enega od formatov, ki jih ponuja funkcija izvoza LimeSurvey.

Primeri za izraze

Vstavi odgovor iz prejšnjega vprašanja

Namen Vstavi odgovor iz prejšnjega vprašanja
Vrsta Sklic
Primer Prvo vprašanje (koda vprašanja " Q00"): V katerem mestu živiš?
Drugo vprašanje (koda vprašanja "Q01") Kako dolgo že živite v CITY?
Narediti: Uporabite odgovor iz prvega vprašanja namesto "CITY" iz drugega vprašanja.
Izraz {QOO}
Opis Odgovor v Q00 nadomešča polje Q00 iz drugega vprašanja
Koraki Ustvari/Uredi drugo vprašanje
Vstavite "Kako dolgo ste živeli v {QOO} (let)?" v besedilno polje vprašanja

Uporaba vprašanja s skrito enačbo za samodejno izpolnjevanje odgovora

Problem:

Predstavljajte si, da imate dve vprašanji Q1 in Q2. Q1 vpraša anketirance po njihovi starosti. Q2 razdeli anketirance v tri skupine: starost je manjša od 20 let, starost je 20 let, starost je več kot 20. 

Torej, Q2 naj uporablja vrednosti "1", "2", "3", ki ustrezajo zgornjih pogojev. Prav tako ne smemo pozabiti narediti Q2 nevidnega (vprašanje ne bo prikazano v anketi, ampak bodo vrednosti preko "postopka v ozadju" v tabeli odgovorov).

Če želite izpolniti zbirko podatkov z uporabo vprašanja Equation, vnesite:

  • Najprej ustvarite vprašanje s kodo Q1 kot vprašanje za numerični vnos.
  • Nato ustvarite drugo vprašanje s kodo Q2 kot vprašanje enačbe .
  • V poglavju zavihka "Nastavitve zaslona" v Q2:
    • nastavite polje "Vedno skrij to vprašanje" kot "Vklopljeno"
    • v polje "Enačba" vnesite izraz:
 {if(Q1.NAOK < 20, "1", if(Q1.NAOK > 20, "3", "2"))}

Ustvarite stran s povzetkom z ogradami

Ta vadnica prikazuje, kako lahko na koncu ankete ustvarite pregled, v katerem navedete vsa vprašanja in odgovore prek oznak mesta ExpressionScript. Pokaže tudi, kako omejite tak pregled samo na vprašanja z odgovori.

Naš primer lahko prenesete od tukaj: Primer ankete o označbah mesta.


Tukaj uporabljene vrste vprašanj:'

'1. Vprašanja z eno izbiro / eno besedilo/številska vprašanja

  • Seznam (spustni meni)
  • Seznam (radio) [L]
  • Da/Ne [Y]
  • Dolgo prosto besedilo [T ]
  • Kratko prosto besedilo [S]
  • Numerični vnos [N]
  • Enačba [*]


'2. Vprašanje s podvprašanji

  • Večkratno kratko besedilo [Q]
  • Večkratna izbira [M]
  • Matrika [F]
  • Matrika (Da/Ne/Negotovo) [C]
  • Matrika (izbira 10 točk) [B]


'3. Vprašanja z 2 lestvicama

  • Dvojna lestvica polja [1]


'4. Vprašanja z lestvicami X in Y

  • Array (Numbers) [:]


'5. Vprašanja maske

  • Prikaz besedila [X]


V tem preprostem primeru bo naš pregled preprost seznam z:

- Besedilo vprašanja: Uporabnikov odgovor


Vprašanja z eno izbiro/vprašanja z enim besedilom/številska vprašanja

Za vse te vrste vprašanj bo Limesurvey shranil en odgovor:

  • Seznam (spustni)
  • Seznam (radio)
  • Seznam s komentarjem
  • Izbira 5 točk
  • Da/Ne
  • Kratko prosto besedilo
  • Dolgo prosto besedilo!N !*Ogromno prosto besedilo
  • Številski vnos
  • Enačba
  • Datum
  • Spol

Ob predpostavki, da je koda vprašanja q1, se lahko sklicujemo na besedilo vprašanja in odgovorimo z:

- {q1.vprašanje}: {q1.prikazano}

primer:

- Koliko si star?: 25


Če želite preveriti, ali je bilo na to vprašanje odgovorjeno, lahko okrog svojega izhoda postavite stavek IF:

{if(!is_empty(q1),join("- ",q1.question,": ",q1.shown),"")}

To se "prevede" v: ČE vprašanje s kodo q1 ni prazno, izpis "- " IN besedilo vprašanja IN ": " IN besedilo odgovora (funkcija join() združi elemente kot nov niz; DRUGAČE: izhod ni nič (" " pomeni prazen niz).

Vprašanje s podvprašanji

Za vse te vrste vprašanj LimeSurvey uporablja podvprašanja:

  • Večkratno kratko besedilo
  • Večkratna izbira
  • Večkratna izbira s komentarji
  • Matrika
  • Matrika (izbira 5 točk)
  • Matrika (izbira 10 točk)
  • Matrika (da /Ne/Negotovo)
  • Matrika (povečanje/enako/zmanjšanje)
  • Matrika po stolpcu

Ob predpostavki, da je koda vprašanja vprašanja q2 in da so podvprašanja oštevilčena SQ001, SQ002 (samodejno oštevilčenje izvaja LimeSurvey), se lahko sklicujemo na besedilo vprašanja in odgovor z uporabo:

- {q2_SQ001.vprašanje}: {q2_SQ001.prikazano}

- {q2_SQ002.vprašanje}: {q2_SQ002.prikazano}

For multiple choice questions it makes sense to now show the text of the ticked subquestion but to show a Y for each selected option:

- {q2_SQ001.question}: {q2_SQ001}

- {q2_SQ002.question}: {q2_SQ002}

...

Note that currently it is not possible to output the question text of questions with subquestions, see this feature request.


Example 1 (assuming question type is multiple choice)

- Do you know these car brands?

-- Mercedes: Y

-- Audi: N

-- Volvo: Y


If you want to output checked items only you can put an IF statement around your output and check for the checkbox value:

{ if( q2_SQ001=="Y", join( "- ", q2_SQ001.question, ": ", q2_SQ001.shown ), "" ) }


Use the listifop function if you want to output a list of only the selected items, eg: Mercedes, Volvo

{ listifop( 'value', '==', 'Y', 'question', ', ', that.q2.sgqa ) }


Where  that.q2  expands to all of q2's subquestions. See self, this and that for more detail.


Example 2 (assuming question type is Array (10 point choice))

- Please rate the quality of the car brands below on a scale from 1=very bad to 10=very good?

-- Mercedes: 7

-- Audi: 9

-- Volvo: 9


If you want to output rated items only you can put an IF statement around your output and check if the current sub question was answered by using:

{ if( ! is_empty( q3_SQ001 ), join( "- ", q3_SQ001.question, ": ", q3_SQ001.shown ), "" ) }


Use the listifop function if for example you want to only output a list of the selected items greater than eight, eg: Audi / Volvo

{ listifop( 'value', '>', 8, 'question', ' / ', that.q3.sgqa ) }


Question with two scales

This applies to the dual scale question type only.


Let's assume that the following codes are being used:

  • Question code: q4
  • Subquestion codes: SQ001, SQ002, ...
  • Answer codes scale 1: A1, A2, ...
  • Answer codes scale 2: B1, B2, ...


To refer to the result of a certain subquestion on a certain scale, you need to use QuestionCode . '_' . SubQuestionCode . '_' . ScaleID. Note that "ScaleID" is 0 for the first scale and 1 for the other!
Example for referring to the answer of the third subquestion and second scale: q4_SQ003_1 - Question 4, subquestion 3, second scale.


Let's output the results for both scales and the first two subquestions:

- {q4_SQ001_0.question}: {q4_SQ001_0.shown} / {q4_SQ001_1.shown}

- {q4_SQ002_0.question}: {q4_SQ002_0.shown} / {q4_SQ002_1.shown}

To output the subquestion text, you need to add the scale ID to the placeholder (though the texts are the same for both scales). So instead of {q4_SQ001.question} we have to use {q4_SQ001_0.question} or {q4_SQ001_1.question}.

If you want to export/display the results of subquestions with at least one answer only, use this syntax for each subquestion:

{if(count(q4_SQ001_0,q4_SQ001_1)>0,join("- ",q4_SQ001_0.question,": ",q4_SQ001_0.shown," / ",q4_SQ001_1.shown),"")}

Question with X and Y scales

This applies to all matrix questions which allow an answer for every cell (not just every row as shown previously):

  • Array Texts
  • Array Numbers


Assumed codes used:

  • Question code: q5
  • Subquestion codes: SQ001, SQ002, ...
  • Answer codes: A1, A2, ...

To refer to the result of a certain subquestion from a certain column, you need to use QuestionCode . '_' . SubQuestionCode . '_' . AnswerCode. Example for referring to the answer of the third subquestion and second column: q5_SQ003_A2.

Let's output the results for columns 1-3 of the first two subquestions:

- {q5_SQ001_A1.question}: {q5_SQ001_A1.shown} | {q5_SQ001_A2.shown} | {q5_SQ001_A3.shown}

- {q5_SQ002_A1.question}: {q5_SQ002_A1.shown} | {q5_SQ002_A2.shown} | {q5_SQ002_A3.shown}


Since for these question types each cell (combination of X axes and Y axes) equals one answer option, a test for existing data needs to be done for each cell. Example:

{if(!is_empty(q5_SQ001_A1),join("- ",q5_SQ001_A1.question,": ",q5_SQ001_A1.shown),"")}


To output the subquestion text you need to add the answer code to the placeholder (though the texts are the same for all answer options). So instead of {q5_SQ001.question} we have to use {q5_SQ001_A1.question} or {q5_SQ001_A2.question}.

Hide question if answer from previous question is empty

Purpose Hide question if answer from previous question is empty
Type Question Relevance
Example Question one: question code "name", question text "What's your name?"
Question two: question text "{name}, how old are you?"
To do: Hide question two if the textfield of question one is empty
Expression !is_empty(name)
Description is_empty() determines whether a variable is considered to be empty. The "!" negates the result. So if the variable is not empty the Expression will be true and the question is shown
Steps Create/edit question two
Insert "!is_empty(name)" into "Relevance equation:"
Sample File Hide_question_if_empty_question_group.zip


Hide question group if answer from previous question is Yes or No

Purpose Hide question group if answer from previous question is Yes or No
Type Question group Relevance
Example Page one, Question Group one, Question one: question code "PET", question text "Do you have a pet?" -Yes -No
Page two, Question Group two: Title "About your pet(s)"
To do: Show/Hide question group two if answer from question one is Yes/No
Expression PET == "Y"
Description PET is the question code for the question you want to check the answer. If you don't use a suffix EM will use "Qcode.code". So you compare the answer code from the PET question to the value "Y". If the participant answers "Yes" the Expression is true and the question group "About your pet(s)" will be shown.
Steps Create/edit question group two
Insert "PET == "Y"" into "Relevance equation:"
Sample File Hide_question group_if_answer_from_previous_question_is_Yes_or_No.zip


Display value of a multiple answer input question field

Purpose Display value of a multiple answer input question field
Type Reference
Example Question one: question code "AskChildAge", question text "How old are your children?". Subquestions codes -Child1 -Child2 -Child3 - ChildXXX
Question two: question code "ReportChildAge" question text "About your first child: - CHILD1 is AGE1."
Expression {AskChildAge_Child1.question}, {AskChildAge_Child1.value}
Description You want to use the value of a subquestion in a following question. You can access the subquestion value with this kind of expression: QcodeQuestion_QcodeSubquestion.value
Steps Create/edit the second question
Insert this text in the description: "About your first child: - {AskChildAge_Child1.question} is {AskChildAge_Child1.value}."
Sample File Display_value_of_a_multiple_answer_input_question_field.zip

Validate number of boxes ticked per row for an "Array (Numbers) Checkbox" question

Purpose Validate number of boxes ticked per row
Type Validation
Example Question of type "Array Numbers (Checkbox Layout)"
Expression sum(...)
Description (sum(Test_A_1, Test_A_2, Test_A_3, Test_A_4, Test_A_5) <= X) determines whether at least X checkboxes in row A are checked.
If you want to check all three rows (A, B, C), you can connect the expression using "&&":
(sum(Test_A_1, Test_A_2, Test_A_3, Test_A_4, Test_A_5) <= X)
&& (sum(Test_B_1, Test_B_2, Test_B_3, Test_B_4, Test_B_5) <= X)
&& (sum(Test_C_1, Test_C_2, Test_C_3, Test_C_4, Test_C_5) <= X)
Steps Create/edit question of type "Array Numbers (Checkbox Layout)".
Insert the above expression into "Question validation equation" at the advanced question settings (you might have to adjust variable namings!).
Sample File Validate number of boxes ticker per row for an Array (Numbers) Checkbox.lss

Calculate difference between two dates

Purpose Calculate difference between two dates
Type Relevance / Equation question type / Validation
Example Question one (date/time, code: DOB): What is your date of birth?
Question two (date/time, code: datetoday): What is the date today?
Question three (boilerplate): You are XXXX days old.
To do: Calculate and display the number of days between the date given in question 1 and the question 2.
Expression {(strtotime(datetoday)-strtotime(DOB))/60/60/24}
Description strtotime calculates the number of seconds between the 1st of January 1970 and the given date. The above expression calculates the number of seconds between the two given dates. The term "/60/60/24" just calculates the number of days from the number of seconds.
Instead of asking for the "datetoday", you can also use strtotime('now') or simply time(), which directly returns the number of seconds from January 1970 until now (i.e. the time the survey was taken). Thus you could quickly figure out the age of a person in years with the equation {(time() - strtotime(DOB)) / 60 / 60 / 24 / 365.25} In any of these cases, it is critical that the date is entered in a proper format, otherwise the strtotime() function will not work right.
Steps Create two date questions (for the date of birth and for today's date) and a boilerplate question.
In the question text of the boilerplate question insert: "On {datetoday} you were {(strtotime(today)-strtotime(dob))/60/60/24} days days old."

Please note: The function strtotime can work with MANY but not all date formats. If you run into problems set your survey's date format to mm/dd/yyyy or yyyy-mm-dd or dd.mm.yyyy"
Sample File Date_difference.zip

Using ExpressionScript for Assessments

Here comes another example on how to use the ExpressionScript with Array type questions and assessments:</ br>

Let's say you have 2 array questions and you want to save the results of the calculation data to your database. It is actually simple, you will need to create and test your arrays and submit a dummy response to see if it works and gives you the results in the completed page.


Implementation details:

  • add a question of type equation
  • add the following line assuming that Q1 is your array question code while Q2 is the second one:
    • {sum(Q1_SQ001.value,Q2_SQ001.value)}

Note that SQ001 is the default code for any subquestion. If you change the subquestion code, adjust the equation above accordingly.


Using em_validation_q in array

You can use the question validation equation to control an array with any condition.


Implementation details:

  • for the first array : array of single choice
    • Question code is ARRAY
    • Sub question code are SQ01,SQ02,SQ03 and SQ04
    • update the Whole question validation equation and put
      !is_empty(ARRAY_SQ01) and !is_empty(ARRAY_SQ03) 
  • for the second array : array of text
    • Question code is ARRAYTEXT
    • Sub question at Y axis code are SY01,SY02,SY03, and SY04
    • Update the Whole question validation equation and put
      count(self.sq_SY01 >= 1) and count(self.sq_SY03 >= 3)