This lesson uses Google Sheets as a source for recording responses from a form submission.\
\
If you'd like to follow along with the specific steps in the lesson, you'll need a Google account and access to Google Sheets.\
\
If you don't have access to Google Sheets, there are other integrations you can use that are suitable for this section, including Notion and Airtable.

Name the spreadsheet '**no code resources**' (top left of the page).\
\
Add the column headers: No Code Book, No Code Podcast, No Code Tool, No Code Blog, Other Resources and Email address.

Navigate to [Questmate.](https://www.questmate.com?utm_campaign=100daysofnocode)\
\
Click "**Try for free**"

Enter your email address and click "**Continue**"

Questmate will ask you to verify your email with a code.\
\
Open your email client, copy your code and head back to Questmate to verify the code.

Once you've verified your code, click "**Continue**".

Enter your display name and click "**Submit**".

You'll be taken to your Questmate dashboard.\
\
Click "**Create Quest**".

Give your Quest a name.\
\
You can create any Quest you want for this lesson, but if you'd like to follow along with this specific example, you'll create a public form that'll allow people to submit their favourite no-code resources.\
\
Add the Quest name "**No Code Resources**" and click "**Create Quest**".

Click the menu button next to "**Manual**".

Select the option "**Public Link**". \
\
This is because this lesson is going to be publicly shared for anyone that wants to submit their resources.

Share a link or QR code for anyone to fill out your Quest.

Click the "**Welcome Text**" field and enter the welcome text that users will see when they open your Quest (in this case, a form).

I want your no-code resource recommendations 📚 

You're now going to add the first item to your form. Click "**Add Item**".

Click inside the "**Short Answer**" field and replace the text with your item request. In this example, you'll start by asking for book recommendations.

1. Start Settings
Start things manually, on a schedule, via a public link or by another app.

Public Link


Enable Public Link

https://app.questmate.com/p/5ce574d4-a6b0-4554-b3d3-f5b355dde68c
Copy Public Link
Show QR Code
Run once now
2. Quest Items
Add tasks, form fields, remote-data dropdowns and smart-device controls that you want to provide as part of your Quest.
Short Answer

Required



Answer will be written here.


Add Item






3. “On Completion” Actions
Send a Slack Message, add a row to Google Sheet, attach Rewards  or grant WiFi Access.

Add Completion Action





Toggle the "**Required**" field to off.\
\
You'll do this for all items in this form, as the goal is just to collect as many resources as possible, which means making the form submission as easy as possible too.

This time, add some text that requests people to submit their favourite no-code podcasts.

1. Start Settings
Start things manually, on a schedule, via a public link or by another app.

Public Link


Enable Public Link

https://app.questmate.com/p/5ce574d4-a6b0-4554-b3d3-f5b355dde68c
Copy Public Link
Show QR Code
Run once now
2. Quest Items
Add tasks, form fields, remote-data dropdowns and smart-device controls that you want to provide as part of your Quest.
Short Answer

Required



Answer will be written here.

Short Answer

Required



Answer will be written here.


Add Item






3. “On Completion” Actions
Send a Slack Message, add a row to Google Sheet, attach Rewards  or grant WiFi Access.

Add Completion Action





Add some text that requests users to submit their favourite no-code tool.

1. Start Settings
Start things manually, on a schedule, via a public link or by another app.

Public Link


Enable Public Link

https://app.questmate.com/p/5ce574d4-a6b0-4554-b3d3-f5b355dde68c
Copy Public Link
Show QR Code
Run once now
2. Quest Items
Add tasks, form fields, remote-data dropdowns and smart-device controls that you want to provide as part of your Quest.
Short Answer

Required



Answer will be written here.

Short Answer

Required



Answer will be written here.

Short Answer

Required



Answer will be written here.


Add Item






3. “On Completion” Actions
Send a Slack Message, add a row to Google Sheet, attach Rewards  or grant WiFi Access.

Add Completion Action





Add some text that requests users to submit their favourite no-code blog.

1. Start Settings
Start things manually, on a schedule, via a public link or by another app.

Public Link


Enable Public Link

https://app.questmate.com/p/5ce574d4-a6b0-4554-b3d3-f5b355dde68c
Copy Public Link
Show QR Code
Run once now
2. Quest Items
Add tasks, form fields, remote-data dropdowns and smart-device controls that you want to provide as part of your Quest.
Short Answer

Required



Answer will be written here.

Short Answer

Required



Answer will be written here.

Short Answer

Required



Answer will be written here.

Short Answer

Required



Answer will be written here.


Add Item






3. “On Completion” Actions
Send a Slack Message, add a row to Google Sheet, attach Rewards  or grant WiFi Access.

Add Completion Action





Add some text that requests users to submit any other no-code resources they'd like to recommend.

Do you have any other no-code resources you'd like to recommend?Long Answer

Enter some text that requests users to sign up for your mailing list.

Click in the "**Type here to add a note**" field and add some text to explain why users might want to leave their email address.

1. Start Settings
Start things manually, on a schedule, via a public link or by another app.

Public Link


Enable Public Link

https://app.questmate.com/p/5ce574d4-a6b0-4554-b3d3-f5b355dde68c
Copy Public Link
Show QR Code
Run once now
2. Quest Items
Add tasks, form fields, remote-data dropdowns and smart-device controls that you want to provide as part of your Quest.
Short Answer

Required



Answer will be written here.

Short Answer

Required



Answer will be written here.

Short Answer

Required



Answer will be written here.

Short Answer

Required



Answer will be written here.

Long Answer

Required



Answer will be written here.

Email

Required



Email address will be written here.





Add Item






3. “On Completion” Actions
Send a Slack Message, add a row to Google Sheet, attach Rewards  or grant WiFi Access.

Add Completion Action





Enter the text you'd like users to see after they've completed the Quest.

Thank you so much for contributing. Look out for my upcoming newsletter which will feature highly-recommended resources from this survey.

You're now going to map user responses to the Google Sheet you created at the beginning of the lesson.\
\
Click "**Add Completion Action**".

Select "**Google Sheets: Add row**".\
\
Note: If you don't use Google Sheets it's here that you can select an alternate place to automatically record your responses.

Select your Google account for authorisation.

Search for and select your "**no code resources**" Google Sheet.

Search for and select "**Sheet1**" of your "**no code resources**" sheet.

You'll see the items from your form, which you'll now need to map to the corresponding columns in your Google sheet. \
\
Click the "**Select quest data**" field for the "**No Code Book**" column of your Google sheet.

Select the options that corresponds with the no-code book item from your form.

Now you'll repeat this process for the rest of the items in your form.

Map the podcast recommendation section to the associated column in your sheet.

Map the tool recommendation section to the associated column in your sheet.

Map the blog recommendation section to the associated column in your sheet.

Map the additional resources section to the associated column in your sheet.

Do you have any other no-code resources you'd like to recommend?

Map the email address section to the associated column in your sheet.

Would you like to subscribe to my mailing list?

You're now going to test that everything works as expected.\
\
Click this button (highlighed below).

You'll be taken to a screen where you're able to submit a test form.\
\
Respond to all of the items in your form.

When you're finished, click '**Submit**'.

You'll be shown the 'Reveal text' that's shown to users that complete your Quest.

Thank 
you 
so 
much 
for 
contributing. 
Look 
out 
for 
my 
upcoming 
newsletter 
which 
will 
feature 
highly-recommended 
resources 
from 
these 
submissions. 

Now head back over to your Google Sheet and you should see the information you just submitted in your test run has automatically been populated in the sheet!

Head back to Quest, copy the public link to your form and share with the community using #100DaysofNoCode.\
\
Awesome job.\
\
Today you've not only built a no-code form, you've built an entire quest that captures responses and automatically updates them in a Google Sheet!

Questmate

Google Account

Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.