Hi Mackenzie,
I haven't done this exact use case, but this is totally doable in a Google
apps script (which is written in basic JavaScript within the code editor on
your form), bit more on it here https://www.google.com/script/start/my
In the script you have easy access to anything submitted in
!
Mackenzie
Mackenzie Salisbury (she, her, hers)
Librarian, Digital Repository
Walden University Library
From: Code for Libraries on behalf of Gregory Pierce
Sent: Wednesday, March 25, 2020 10:26:18 PM
To: CODE4LIB@LISTS.CLIR.ORG
Subject: Re: [CODE4LIB] Google Forms
Could we see an example of the data you’d possibly be pulling?
> On Mar 25, 2020, at 10:51 PM, Mackenzie M. Salisbury
> wrote:
>
> EXTERNAL EMAIL
>
>
> Hi all!
> I am hoping someone out there has an excel formula or script that I can use
> to solve this problem:
>
> I have a google form