Styjun

nginx serves wrong domain site. It doenst shows default site if no configuration applies

Mbed Cortex-m hardfault when sending data via TCP

Is this floating-point optimization allowed?

Is killing off one of my queer characters homophobic?

How many matrices satisfy this equality?

Am I testing diodes properly?

Alternatives to using writing paper for writing practice

Why does the trade federation become so alarmed upon learning the ambassadors are Jedi Knights?

Where is my understanding of TikZ styles wrong?

Ways to express "The reader may wish to..." / "The reader may want to..."

Can I call 112 to check a police officer's identity in the Czech Republic?

Are lithium batteries allowed in the International Space Station?

Supporting developers who insist on using their pet language

Robbers: The Hidden OEIS Substring

The monorail explodes before I can get on it

What does `[$'rn']` mean?

Fix /dev/sdb after using dd with no device inserted

Can I intentionally omit previous work experience or pretend it doesn't exist when applying for jobs?

QGIS Linestring rendering curves between vertex

How is the idea of "X comes a distant third" commonly expressed in Russian?

Do native speakers use ZVE or CPU?

What is this welding tool I found in my attic?

School House Points (Python + SQLite)

Extract an attribute value from XML

Is there a way to integrate macros with google forms?

How to change the next row that a Google Form will populate in a Google SpreadsheetAllow only one Google Form submission per usercolor code google form answers automaticallyGoogle Form. Confirmation Email Script. With edit urlGoogle Spreadsheet, Creating multiple rows on form submitCustom Redirect after Submitting a Prefilled Google FormDisplaying a Google form on sheetsMake rows of a Google spreadsheet editable in a Google formCreate Unique ID Google FormHandling edits to a Google Form response

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have a basic google form with a short answer input. I'd like to split the input of the form by commas so text input like

aaa, bbb, ccc

would appear in the spreadsheet as

I've tried adding the following macro to column C

=ArrayFormula(split(B1:B500, ","))

but the problem is that new form submissions will just create a new row without the macro applied to columns C, D, E, etc. Is there a way to ensure the macro gets applied to new rows created from users submitting the google form?

google-form

share|improve this question

edited Mar 26 at 6:41

jmdeamer

asked Mar 26 at 5:20

jmdeamerjmdeamer

1231212 bronze badges

add a comment | 

0

I have a basic google form with a short answer input. I'd like to split the input of the form by commas so text input like

aaa, bbb, ccc

would appear in the spreadsheet as

I've tried adding the following macro to column C

=ArrayFormula(split(B1:B500, ","))

but the problem is that new form submissions will just create a new row without the macro applied to columns C, D, E, etc. Is there a way to ensure the macro gets applied to new rows created from users submitting the google form?

google-form

share|improve this question

edited Mar 26 at 6:41

jmdeamer

asked Mar 26 at 5:20

jmdeamerjmdeamer

1231212 bronze badges

add a comment | 

I have a basic google form with a short answer input. I'd like to split the input of the form by commas so text input like

aaa, bbb, ccc

would appear in the spreadsheet as

I've tried adding the following macro to column C

=ArrayFormula(split(B1:B500, ","))

but the problem is that new form submissions will just create a new row without the macro applied to columns C, D, E, etc. Is there a way to ensure the macro gets applied to new rows created from users submitting the google form?

google-form

share|improve this question

edited Mar 26 at 6:41

jmdeamer

asked Mar 26 at 5:20

jmdeamerjmdeamer

1231212 bronze badges

=ArrayFormula(split(B1:B500, ","))

share|improve this question

edited Mar 26 at 6:41

jmdeamer

asked Mar 26 at 5:20

jmdeamerjmdeamer

1231212 bronze badges

share|improve this question

edited Mar 26 at 6:41

jmdeamer

asked Mar 26 at 5:20

jmdeamerjmdeamer

1231212 bronze badges

asked Mar 26 at 5:20

jmdeamerjmdeamer

1231212 bronze badges

asked Mar 26 at 5:20

jmdeamerjmdeamer

1231212 bronze badges

1 Answer
1

active

oldest

votes

0

It seems like the solution was to change the macro formula from

=ArrayFormula(split(B1:B500, ","))

to

=ArrayFormula(split(B1, ","))

then manually drag the formula down as many rows as needed. Not really sure why this was the case.

share|improve this answer

answered Mar 26 at 19:55

jmdeamerjmdeamer

1231212 bronze badges

add a comment | 

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
);



);

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55350332%2fis-there-a-way-to-integrate-macros-with-google-forms%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

It seems like the solution was to change the macro formula from

=ArrayFormula(split(B1:B500, ","))

to

=ArrayFormula(split(B1, ","))

then manually drag the formula down as many rows as needed. Not really sure why this was the case.

share|improve this answer

answered Mar 26 at 19:55

jmdeamerjmdeamer

1231212 bronze badges

add a comment | 

0

It seems like the solution was to change the macro formula from

=ArrayFormula(split(B1:B500, ","))

to

=ArrayFormula(split(B1, ","))

then manually drag the formula down as many rows as needed. Not really sure why this was the case.

share|improve this answer

answered Mar 26 at 19:55

jmdeamerjmdeamer

1231212 bronze badges

add a comment | 

It seems like the solution was to change the macro formula from

=ArrayFormula(split(B1:B500, ","))

to

=ArrayFormula(split(B1, ","))

then manually drag the formula down as many rows as needed. Not really sure why this was the case.

share|improve this answer

answered Mar 26 at 19:55

jmdeamerjmdeamer

1231212 bronze badges

=ArrayFormula(split(B1:B500, ","))

=ArrayFormula(split(B1, ","))

share|improve this answer

answered Mar 26 at 19:55

jmdeamerjmdeamer

1231212 bronze badges

answered Mar 26 at 19:55

jmdeamerjmdeamer

1231212 bronze badges

answered Mar 26 at 19:55

jmdeamerjmdeamer

1231212 bronze badges