Sample - Randomizing form section order
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRS
1
2
startstarttime
3
endendtime
4
deviceiddeviceid
5
subscriberidsubscriberid
6
simserialsimid
7
phonenumberdevicephonenum
8
9
noteintroWelcome to this sample form design on randomizing form section order! Make your own copy of this form definition to edit and test:

1. Open the "File" menu in Google Sheets in the top left.
3. If you use Excel rather than Google Drive:

Be sure to read the accompanying article to this sample form:

https://support.surveycto.com/hc/en-us/articles/360026396733-Randomizing-form-section-order

introno
10
11
notenote_1Random value is \${randomdraw}no
12
calculaterouteif(\${randomdraw} <= .33,1,if(\${randomdraw} > .33 and \${randomdraw} < .67,2,3))
13
14
notenote_2You have been assigned to route \${route}no
15
16
calculatefirstif(\${route}=1, 'A', if(\${route}=2, 'B', 'C'))ABC
17
calculatesecondif(\${route}=1, 'B', if(\${route}=2, 'C', 'A'))BCA
18
calculatethirdif(\${route}=1, 'C', if(\${route}=2, 'A', 'B'))CAB
19
20
notestart_go_to_aGo to \${grp_a}\${route}=1\${continue} != 1
21
notestart_go_to_bGo to \${grp_b}\${route}=2\${continue} != 1
22
notestart_go_to_cGo to \${grp_c}\${route}=3\${continue} != 1
23
24
begin groupgrp_aSection A\${route}=1 or ((\${route}=2 or \${route}=3) and \${c_fin}=1)
25
notenote_aYou are entering Section Ano
26
27
calculatea_finif(\${colors} != null,1,0)
28
notefrom_a_go_to_bYou have finished Section A. Please go to \${grp_b}\${a_fin}=1 and (\${route}=1 or \${route}=3)\${continue} != 1You must click on the link to go forward
29
notefrom_a_go_to_endYou have finished Section A. Please go to the \${grp_end}\${a_fin}=1 and \${route}=2\${continue} != 1You must click on the link to go forward
30
end group
31
32
begin groupgrp_bSection B\${route}=2 or ((\${route}=1 or \${route}=3) and \${a_fin}=1)
33
notenote_bYou are entering Section Bno
34
35
calculateb_finif(\${shapes} != null,1,0)
36
notefrom_b_go_to_cYou have finished Section B. Please go to \${grp_c}\${b_fin}=1 and (\${route}=1 or \${route}=2)\${continue} != 1You must click on the link to go forward
37
notefrom_b_go_to_endYou have finished Section B. Please go to the \${grp_end}\${b_fin}=1 and \${route}=3\${continue} != 1You must click on the link to go forward
38
end group
39
40
begin groupgrp_cSection C
41
notenote_cYou are entering Section Cno
42
43
calculatec_finif(\${foods} != null,1,0)
44
notefrom_c_go_to_endYou have finished Section C. Please go to the \${grp_end}\${c_fin}=1 and \${route}=1\${continue} != 1You must click on the link to go forward
45
notefrom_c_go_to_aYou have finished Section C. Please go to \${grp_a}\${c_fin}=1 and (\${route}=3 or \${route}=2)\${continue} != 1You must click on the link to go forward
46
end group
47
48
begin groupgrp_endend
49
select_one continuecontinueYou have reached the end. Thanks for your time. \${a_fin}=1 and \${b_fin}=1 and \${c_fin}=1One of the sections is incomplete. Please go back. yes
50
end group