Response validation using only certain words in Google Forms
I have a Google Forms with the question "What is your name?" and the answer specified to be Short answer. However I want to allow only certain answers like Tom or Peter.
I know in this easy case I could use a Drop-down instead and put in the names as options. But in reality I have a long list of valid answers which would be too long for a Drop-down. I want to rather use the Response validation feature combined with Regular expressions to check if the answer is either Tom or Peter. So I want a correct answer to be Tom or Peter but nothing like Tom Peter and nothing else like Tree.
I tried to set Regular Expression Contains ("Tom"|"Peter") but it doesn't work. What am I doing wrong?
regex validation google-form
asked Nov 15 '18 at 22:30
philmcolephilmcole
1246
add a comment |
I have a Google Forms with the question "What is your name?" and the answer specified to be Short answer. However I want to allow only certain answers like Tom or Peter.
I know in this easy case I could use a Drop-down instead and put in the names as options. But in reality I have a long list of valid answers which would be too long for a Drop-down. I want to rather use the Response validation feature combined with Regular expressions to check if the answer is either Tom or Peter. So I want a correct answer to be Tom or Peter but nothing like Tom Peter and nothing else like Tree.
I tried to set Regular Expression Contains ("Tom"|"Peter") but it doesn't work. What am I doing wrong?
regex validation google-form
asked Nov 15 '18 at 22:30
philmcolephilmcole
1246
1
Don't use the double quotes inside your regex., it should be: (Tom|Peter)
– Poul Bak
Nov 15 '18 at 22:34
@PoulBak Thanks, that seems to work. However also Tom Peter and Peter46 works.
– philmcole
Nov 15 '18 at 23:14
Try: ^(Tom|Peter)$ - This Means start and end of string.
– Poul Bak
Nov 15 '18 at 23:16
That works. Thanks so much!
– philmcole
Nov 15 '18 at 23:20
add a comment |
I have a Google Forms with the question "What is your name?" and the answer specified to be Short answer. However I want to allow only certain answers like Tom or Peter.
I know in this easy case I could use a Drop-down instead and put in the names as options. But in reality I have a long list of valid answers which would be too long for a Drop-down. I want to rather use the Response validation feature combined with Regular expressions to check if the answer is either Tom or Peter. So I want a correct answer to be Tom or Peter but nothing like Tom Peter and nothing else like Tree.
I tried to set Regular Expression Contains ("Tom"|"Peter") but it doesn't work. What am I doing wrong?
regex validation google-form
asked Nov 15 '18 at 22:30
philmcolephilmcole
1246
I have a Google Forms with the question "What is your name?" and the answer specified to be Short answer. However I want to allow only certain answers like Tom or Peter.
I know in this easy case I could use a Drop-down instead and put in the names as options. But in reality I have a long list of valid answers which would be too long for a Drop-down. I want to rather use the Response validation feature combined with Regular expressions to check if the answer is either Tom or Peter. So I want a correct answer to be Tom or Peter but nothing like Tom Peter and nothing else like Tree.
I tried to set Regular Expression Contains ("Tom"|"Peter") but it doesn't work. What am I doing wrong?
regex validation google-form
regex validation google-form
asked Nov 15 '18 at 22:30
philmcolephilmcole
1246
asked Nov 15 '18 at 22:30
philmcolephilmcole
1246
asked Nov 15 '18 at 22:30
philmcolephilmcole
1246
asked Nov 15 '18 at 22:30
philmcolephilmcole
1246
asked Nov 15 '18 at 22:30
philmcolephilmcole
1246
1246
1
Don't use the double quotes inside your regex., it should be: (Tom|Peter)
– Poul Bak
Nov 15 '18 at 22:34
@PoulBak Thanks, that seems to work. However also Tom Peter and Peter46 works.
– philmcole
Nov 15 '18 at 23:14
Try: ^(Tom|Peter)$ - This Means start and end of string.
– Poul Bak
Nov 15 '18 at 23:16
That works. Thanks so much!
– philmcole
Nov 15 '18 at 23:20
add a comment |
1
Don't use the double quotes inside your regex., it should be: (Tom|Peter)
– Poul Bak
Nov 15 '18 at 22:34
@PoulBak Thanks, that seems to work. However also Tom Peter and Peter46 works.
– philmcole
Nov 15 '18 at 23:14
Try: ^(Tom|Peter)$ - This Means start and end of string.
– Poul Bak
Nov 15 '18 at 23:16
That works. Thanks so much!
– philmcole
Nov 15 '18 at 23:20
1
1
Don't use the double quotes inside your regex., it should be: (Tom|Peter)
– Poul Bak
Nov 15 '18 at 22:34
Don't use the double quotes inside your regex., it should be: (Tom|Peter)
– Poul Bak
Nov 15 '18 at 22:34
@PoulBak Thanks, that seems to work. However also Tom Peter and Peter46 works.
– philmcole
Nov 15 '18 at 23:14
@PoulBak Thanks, that seems to work. However also Tom Peter and Peter46 works.
– philmcole
Nov 15 '18 at 23:14
Try: ^(Tom|Peter)$ - This Means start and end of string.
– Poul Bak
Nov 15 '18 at 23:16
Try: ^(Tom|Peter)$ - This Means start and end of string.
– Poul Bak
Nov 15 '18 at 23:16
That works. Thanks so much!
– philmcole
Nov 15 '18 at 23:20
That works. Thanks so much!
– philmcole
Nov 15 '18 at 23:20
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53328784%2fresponse-validation-using-only-certain-words-in-google-forms%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53328784%2fresponse-validation-using-only-certain-words-in-google-forms%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Don't use the double quotes inside your regex., it should be: (Tom|Peter)
– Poul Bak
Nov 15 '18 at 22:34
@PoulBak Thanks, that seems to work. However also Tom Peter and Peter46 works.
– philmcole
Nov 15 '18 at 23:14
Try: ^(Tom|Peter)$ - This Means start and end of string.
– Poul Bak
Nov 15 '18 at 23:16
That works. Thanks so much!
– philmcole
Nov 15 '18 at 23:20