Survey
177
en
gid
sid
group_name
group_order
description
language
randomization_group
grelevance
2
36161
G1
0
en
qid
parent_qid
sid
gid
type
title
question
preg
help
other
mandatory
question_order
language
scale_id
same_default
relevance
15
0
36161
2
M

# afSrcFilter

Which rows should appear below?
Y
N
0
en
0
0
1
16
0
36161
2
N

# min

Enter a number
N
N
17
en
0
0
1
17
0
36161
2
N

# max

Enter a larger number
N
N
19
en
0
0
1
18
0
36161
2
K

# afK

Enter some numbers{if(is_empty(min) || is_empty(max),'', implode('',' between ', min, ' and ', max, '. The sum must equal ', (min * max)/2))}.
N
N
20
en
0
0
1
19
0
36161
2
K

# afeK

Enter some numbers.{if(is_empty(min) ||is_empty(max),'',implode('',' The sum must be between ', min, ' and ', max, '.'))}
N
N
21
en
0
0
1
20
0
36161
2
X

# Notes

Note that we can accurately track the number of questions answered, even if they are array_filtered:<br/><br/> You answered <b>{count(afK_sq1.NAOK,afK_sq2.NAOK,afK_sq3.NAOK,afK_sq4.NAOK,afK_sq5.NAOK,afK_other.NAOK)}</b> questions in <b>afK</b> (sum = {sum(afK_sq1.NAOK,afK_sq2.NAOK,afK_sq3.NAOK,afK_sq4.NAOK,afK_sq5.NAOK,afK_other.NAOK)}).<br/> and <b>{count(afeK_sq1.NAOK,afeK_sq2.NAOK,afeK_sq3.NAOK,afeK_sq4.NAOK,afeK_sq5.NAOK,afeK_other.NAOK)}</b> questions in <b>afeK</b> (sum = {sum(afeK_sq1.NAOK,afeK_sq2.NAOK,afeK_sq3.NAOK,afeK_sq4.NAOK,afeK_sq5.NAOK,afeK_other.NAOK)}).
N
N
22
en
0
0
1
qid
parent_qid
sid
gid
type
title
question
preg
help
other
mandatory
question_order
language
scale_id
same_default
relevance
21
15
36161
2
T

# sq1

First sub-question
N
N
2
en
0
0
22
15
36161
2
T

# sq2

Second sub-question
N
N
5
en
0
0
23
15
36161
2
T

# sq3

Third sub-question
N
N
9
en
0
0
24
15
36161
2
T

# sq4

Fourth sub-question
N
N
13
en
0
0
25
15
36161
2
T

# sq5

Fifth sub-question
N
N
16
en
0
0
26
18
36161
2
T

# sq1

First sub-question
N
N
1
en
0
0
27
18
36161
2
T

# sq2

Second sub-question
N
N
2
en
0
0
28
18
36161
2
T

# sq3

Third sub-question
N
N
3
en
0
0
29
18
36161
2
T

# sq4

Fourth sub-question
N
N
4
en
0
0
30
18
36161
2
T

# sq5

Fifth sub-question
N
N
5
en
0
0
31
18
36161
2
T

# other

{if(afSrcFilter_other,afSrcFilter_other,'Other')}
N
N
6
en
0
0
32
19
36161
2
T

# sq1

First sub-question
N
N
1
en
0
0
33
19
36161
2
T

# sq2

Second sub-question
N
N
2
en
0
0
34
19
36161
2
T

# sq3

Third sub-question
N
N
3
en
0
0
35
19
36161
2
T

# sq4

Fourth sub-question
N
N
4
en
0
0
36
19
36161
2
T

# sq5

Fifth sub-question
N
N
5
en
0
0
37
19
36161
2
T

# other

{if(afSrcFilter_other,afSrcFilter_other,'Other')}
N
N
6
en
0
0
qid
attribute
value
language
15
array_filter
15
array_filter_exclude
15
assessment_value
1
15
display_columns
2
15
exclude_all_others
15
exclude_all_others_auto
0
15
hidden
0
15
hide_tip
1
15
max_answers
15
min_answers
15
other_numbers_only
0
15
other_replace_text
en
15
page_break
0
15
public_statistics
0
15
random_group
15
random_order
0
15
scale_export
0
16
hidden
0
16
hide_tip
1
16
max_num_value_n
16
maximum_chars
16
min_num_value_n
16
num_value_int_only
0
16
page_break
0
16
prefix
en
16
public_statistics
0
16
random_group
16
suffix
en
16
text_input_width
17
hidden
0
17
hide_tip
1
17
max_num_value_n
17
maximum_chars
17
min_num_value_n
min
17
num_value_int_only
0
17
page_break
0
17
prefix
en
17
public_statistics
0
17
random_group
17
suffix
en
17
text_input_width
18
array_filter
afSrcFilter
18
array_filter_exclude
18
em_validation_q
18
em_validation_q_tip
18
em_validation_sq
18
em_validation_sq_tip
18
equals_num_value
(min * max) / 2
18
hidden
0
18
hide_tip
1
18
max_answers
18
max_num_value
18
max_num_value_n
max
18
maximum_chars
18
min_answers
18
min_num_value
18
min_num_value_n
min
18
page_break
0
18
prefix
en
18
public_statistics
0
18
random_group
18
random_order
0
18
slider_accuracy
18
slider_default
18
slider_layout
0
18
slider_max
18
slider_middlestart
0
18
slider_min
18
slider_separator
18
slider_showminmax
0
18
suffix
en
18
text_input_width
19
array_filter
19
array_filter_exclude
afSrcFilter
19
em_validation_q
19
em_validation_q_tip
19
em_validation_sq
19
em_validation_sq_tip
19
equals_num_value
19
hidden
0
19
hide_tip
1
19
max_answers
19
max_num_value
max
19
max_num_value_n
19
maximum_chars
19
min_answers
19
min_num_value
min
19
min_num_value_n
19
page_break
0
19
prefix
en
19
public_statistics
0
19
random_group
19
random_order
0
19
slider_accuracy
19
slider_default
19
slider_layout
0
19
slider_max
19
slider_middlestart
0
19
slider_min
19
slider_separator
19
slider_showminmax
0
19
suffix
en
19
text_input_width
20
hidden
0
20
page_break
0
20
random_group
20
time_limit
20
time_limit_action
1
20
time_limit_countdown_message
en
20
time_limit_disable_next
0
20
time_limit_disable_prev
0
20
time_limit_message
en
20
time_limit_message_delay
20
time_limit_message_style
20
time_limit_timer_style
20
time_limit_warning
20
time_limit_warning_2
20
time_limit_warning_2_display_time
20
time_limit_warning_2_message
en
20
time_limit_warning_2_style
20
time_limit_warning_display_time
20
time_limit_warning_message
en
20
time_limit_warning_style
sid
admin
expires
startdate
adminemail
anonymized
faxto
format
savetimings
template
language
additional_languages
datestamp
usecookie
allowregister
allowsave
autonumber_start
autoredirect
allowprev
printanswers
ipaddr
refurl
publicstatistics
publicgraphs
listpublic
htmlemail
sendconfirmation
tokenanswerspersistence
assessments
usecaptcha
usetokens
bounce_email
attributedescriptions
emailresponseto
emailnotificationto
tokenlength
showxquestions
showgroupinfo
shownoanswer
showqnumcode
bouncetime
bounceprocessing
bounceaccounttype
bounceaccounthost
bounceaccountpass
bounceaccountencryption
bounceaccountuser
showwelcome
showprogress
questionindex
navigationdelay
nokeyboard
alloweditaftercompletion
googleanalyticsstyle
googleanalyticsapikey
36161
N
G
N
default
en
N
N
N
Y
0
N
N
N
N
N
N
N
Y
Y
Y
N
N
D
N
15
Y
B
Y
X
0
N
Y
Y
0
0
N
N
surveyls_survey_id
surveyls_language
surveyls_title
surveyls_description
surveyls_welcometext
surveyls_endtext
surveyls_url
surveyls_urldescription
surveyls_email_invite_subj
surveyls_email_invite
surveyls_email_remind_subj
surveyls_email_remind
surveyls_email_register_subj
surveyls_email_register
surveyls_email_confirm_subj
surveyls_email_confirm
surveyls_dateformat
surveyls_attributecaptions
email_admin_notification_subj
email_admin_notification
email_admin_responses_subj
email_admin_responses
surveyls_numberformat
attachments
36161
en
Sub-Question Relevance Test
Shows how array_filter and array_filter_exclude can be mixed with calculations, and only relevant sub-questions contribute to those calculations.
Invitation to participate in a survey
Dear {FIRSTNAME},<br /><br />you have been invited to participate in a survey.<br /><br />The survey is titled:<br />"{SURVEYNAME}"<br /><br />"{SURVEYDESCRIPTION}"<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}<br /><br />If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />{OPTOUTURL}
Reminder to participate in a survey
Dear {FIRSTNAME},<br /><br />Recently we invited you to participate in a survey.<br /><br />We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.<br /><br />The survey is titled:<br />"{SURVEYNAME}"<br /><br />"{SURVEYDESCRIPTION}"<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}<br /><br />If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />{OPTOUTURL}
Survey registration confirmation
Dear {FIRSTNAME},<br /><br />You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br /><br />To complete this survey, click on the following URL:<br /><br />{SURVEYURL}<br /><br />If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.
Confirmation of your participation in our survey
Dear {FIRSTNAME},<br /><br />this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br /><br />If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.<br /><br />Sincerely,<br /><br />{ADMINNAME}
1
Response submission for survey {SURVEYNAME}
Hello,<br /><br />A new response was submitted for your survey '{SURVEYNAME}'.<br /><br />Click the following link to reload the survey:<br />{RELOADURL}<br /><br />Click the following link to see the individual response:<br />{VIEWRESPONSEURL}<br /><br />Click the following link to edit the individual response:<br />{EDITRESPONSEURL}<br /><br />View statistics by clicking here:<br />{STATISTICSURL}
Response submission for survey {SURVEYNAME} with results
<style type="text/css"> .printouttable { margin:1em auto; } .printouttable th { text-align: center; } .printouttable td { border-color: #ddf #ddf #ddf #ddf; border-style: solid; border-width: 1px; padding:0.1em 1em 0.1em 0.5em; }

.printouttable td:first-child { font-weight: 700; text-align: right; padding-right: 5px; padding-left: 5px;

} .printouttable .printanswersquestion td{ background-color:#F7F8FF; }

.printouttable .printanswersquestionhead td{ text-align: left; background-color:#ddf; }

.printouttable .printanswersgroup td{ text-align: center; font-weight:bold; padding-top:1em; } </style>Hello,<br /><br />A new response was submitted for your survey '{SURVEYNAME}'.<br /><br />Click the following link to reload the survey:<br />{RELOADURL}<br /><br />Click the following link to see the individual response:<br />{VIEWRESPONSEURL}<br /><br />Click the following link to edit the individual response:<br />{EDITRESPONSEURL}<br /><br />View statistics by clicking here:<br />{STATISTICSURL}<br /><br /><br />The following answers were given by the participant:<br />{ANSWERTABLE}
0