Sign up for updates

Get a weekly update every Sunday with our announcements, company updates and a behind-the-scenes of what our community are building.
Over 11,000 people get our updates, join us!
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.
β­  all tutorials

Build a writing habit with Glide

This tutorial is available for pro members only

Request access

In this tutorial we'll show you how to track your daily writing habit with Glide.

What you'll need

  • Glide
  • Google Sheets
  • Google Drive

Estimated time to complete

  • 30 minutes

The full tutorial is available for pro members only

Request access

Create a Google Sheet and add the following columns:

  • Date (Insert a date and drag down to populate this column)
  • Title
  • Daily Writing
  • Progress - make this a formula column that references the Daily Writing column. In this tutorial, the formula is =IF(C2=" ", 0, COUNTA(SPLIT(C2," ")))
  • 0 words
  • 100 words
  • 250 words
  • 500 words
  • 750 words

Create a folder in your Google Drive and upload images that will represent 0, 100, 250, 500, and 750 words. Once you have uploaded these, right click on each image, click 'Share' β†’ 'Get Shareable Link' β†’ 'Copy Link' and paste this into your Google Sheet.

Create a new tab in your Google Sheet and name it 'Writing Prompts'. Create a header for a column called 'Writing Prompts' and paste in writing prompts (this tutorial used https://psychcentral.com/blog/30-journaling-prompts-for-self-reflection-and-self-discovery/).

‍

Sign into Glide and select '+New App' and choose the Google Sheet you created in Step 1. Select 'Tabs' and create three tabs: Daily Journal, Progress, and Prompts. Make sure the Source for Daily Journal and Progress is the first tab of your Google Sheet. The Prompts tab should be linked to the second tab of your Google Sheet.

Click on 'Data' and create a new column called 'Habit Tracker' and make it a If β†’ Then β†’ Else column. Set up the parameters for your milestones.

Click on 'Layout' and select the Daily Journal tab. Set Title to Date, Details to Title, and Image to Habit Tracker. Click into one of the list items and add a Title, Progress Bar, Text Entry, and Notes component.

Select the Progress tab and make this a Tiles property. For Data, leave everything blank except Image and link it to the Habit Tracker column. Tile Shape should be 4:3, select 4 tiles per role, select Tight padding and Square corners.

Select the Prompts tab and link Title to Writing Prompts. Uncheck 'Show title when image in unavailable.' Click into a list item, add an Inline List component and link it to sheet 1 of your Google Sheet. Hop into the 'Features' tab and add a filter that says 'Date is within Today.'

I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @amiedelisa or @makerpad.

For access to this full tutorial please head over to https://www.makerpad.co

‍

In this tutorial we'll show you how to track your daily writing habit with Glide.

What you'll need

  • Glide
  • Google Sheets
  • Google Drive

Estimated time to complete

  • 30 minutes

Create a Google Sheet and add the following columns:

  • Date (Insert a date and drag down to populate this column)
  • Title
  • Daily Writing
  • Progress - make this a formula column that references the Daily Writing column. In this tutorial, the formula is =IF(C2=" ", 0, COUNTA(SPLIT(C2," ")))
  • 0 words
  • 100 words
  • 250 words
  • 500 words
  • 750 words

Create a folder in your Google Drive and upload images that will represent 0, 100, 250, 500, and 750 words. Once you have uploaded these, right click on each image, click 'Share' β†’ 'Get Shareable Link' β†’ 'Copy Link' and paste this into your Google Sheet.

Create a new tab in your Google Sheet and name it 'Writing Prompts'. Create a header for a column called 'Writing Prompts' and paste in writing prompts (this tutorial used https://psychcentral.com/blog/30-journaling-prompts-for-self-reflection-and-self-discovery/).

‍

Sign into Glide and select '+New App' and choose the Google Sheet you created in Step 1. Select 'Tabs' and create three tabs: Daily Journal, Progress, and Prompts. Make sure the Source for Daily Journal and Progress is the first tab of your Google Sheet. The Prompts tab should be linked to the second tab of your Google Sheet.

Click on 'Data' and create a new column called 'Habit Tracker' and make it a If β†’ Then β†’ Else column. Set up the parameters for your milestones.

Click on 'Layout' and select the Daily Journal tab. Set Title to Date, Details to Title, and Image to Habit Tracker. Click into one of the list items and add a Title, Progress Bar, Text Entry, and Notes component.

Select the Progress tab and make this a Tiles property. For Data, leave everything blank except Image and link it to the Habit Tracker column. Tile Shape should be 4:3, select 4 tiles per role, select Tight padding and Square corners.

Select the Prompts tab and link Title to Writing Prompts. Uncheck 'Show title when image in unavailable.' Click into a list item, add an Inline List component and link it to sheet 1 of your Google Sheet. Hop into the 'Features' tab and add a filter that says 'Date is within Today.'

I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @amiedelisa or @makerpad.

For access to this full tutorial please head over to https://www.makerpad.co

‍

Added to your list!
Oops! Something went wrong while submitting the form.
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as completeSave to watch later
Take the quiz
Lesson details

In this tutorial we'll show you how to track your daily writing habit with Glide.

What you'll need

  • Glide
  • Google Sheets
  • Google Drive

Estimated time to complete

  • 30 minutes

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

Create a Google Sheet and add the following columns:

  • Date (Insert a date and drag down to populate this column)
  • Title
  • Daily Writing
  • Progress - make this a formula column that references the Daily Writing column. In this tutorial, the formula is =IF(C2=" ", 0, COUNTA(SPLIT(C2," ")))
  • 0 words
  • 100 words
  • 250 words
  • 500 words
  • 750 words

Create a folder in your Google Drive and upload images that will represent 0, 100, 250, 500, and 750 words. Once you have uploaded these, right click on each image, click 'Share' β†’ 'Get Shareable Link' β†’ 'Copy Link' and paste this into your Google Sheet.

Create a new tab in your Google Sheet and name it 'Writing Prompts'. Create a header for a column called 'Writing Prompts' and paste in writing prompts (this tutorial used https://psychcentral.com/blog/30-journaling-prompts-for-self-reflection-and-self-discovery/).

‍

Sign into Glide and select '+New App' and choose the Google Sheet you created in Step 1. Select 'Tabs' and create three tabs: Daily Journal, Progress, and Prompts. Make sure the Source for Daily Journal and Progress is the first tab of your Google Sheet. The Prompts tab should be linked to the second tab of your Google Sheet.

Click on 'Data' and create a new column called 'Habit Tracker' and make it a If β†’ Then β†’ Else column. Set up the parameters for your milestones.

Click on 'Layout' and select the Daily Journal tab. Set Title to Date, Details to Title, and Image to Habit Tracker. Click into one of the list items and add a Title, Progress Bar, Text Entry, and Notes component.

Select the Progress tab and make this a Tiles property. For Data, leave everything blank except Image and link it to the Habit Tracker column. Tile Shape should be 4:3, select 4 tiles per role, select Tight padding and Square corners.

Select the Prompts tab and link Title to Writing Prompts. Uncheck 'Show title when image in unavailable.' Click into a list item, add an Inline List component and link it to sheet 1 of your Google Sheet. Hop into the 'Features' tab and add a filter that says 'Date is within Today.'

I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @amiedelisa or @makerpad.

For access to this full tutorial please head over to https://www.makerpad.co

‍

Previous submissions
No items found.
Supporting details

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

Create a Google Sheet and add the following columns:

  • Date (Insert a date and drag down to populate this column)
  • Title
  • Daily Writing
  • Progress - make this a formula column that references the Daily Writing column. In this tutorial, the formula is =IF(C2=" ", 0, COUNTA(SPLIT(C2," ")))
  • 0 words
  • 100 words
  • 250 words
  • 500 words
  • 750 words

Create a folder in your Google Drive and upload images that will represent 0, 100, 250, 500, and 750 words. Once you have uploaded these, right click on each image, click 'Share' β†’ 'Get Shareable Link' β†’ 'Copy Link' and paste this into your Google Sheet.

Create a new tab in your Google Sheet and name it 'Writing Prompts'. Create a header for a column called 'Writing Prompts' and paste in writing prompts (this tutorial used https://psychcentral.com/blog/30-journaling-prompts-for-self-reflection-and-self-discovery/).

‍

Sign into Glide and select '+New App' and choose the Google Sheet you created in Step 1. Select 'Tabs' and create three tabs: Daily Journal, Progress, and Prompts. Make sure the Source for Daily Journal and Progress is the first tab of your Google Sheet. The Prompts tab should be linked to the second tab of your Google Sheet.

Click on 'Data' and create a new column called 'Habit Tracker' and make it a If β†’ Then β†’ Else column. Set up the parameters for your milestones.

Click on 'Layout' and select the Daily Journal tab. Set Title to Date, Details to Title, and Image to Habit Tracker. Click into one of the list items and add a Title, Progress Bar, Text Entry, and Notes component.

Select the Progress tab and make this a Tiles property. For Data, leave everything blank except Image and link it to the Habit Tracker column. Tile Shape should be 4:3, select 4 tiles per role, select Tight padding and Square corners.

Select the Prompts tab and link Title to Writing Prompts. Uncheck 'Show title when image in unavailable.' Click into a list item, add an Inline List component and link it to sheet 1 of your Google Sheet. Hop into the 'Features' tab and add a filter that says 'Date is within Today.'

I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @amiedelisa or @makerpad.

For access to this full tutorial please head over to https://www.makerpad.co

‍

More lessons
How Cal Newport manages his inbox with Trello and Zapier
Create a Welcome Bot in Slack
Build a Birthday Bot for Slack
Integrate third-party integrations with Universe
Introduction and overview of Universe
Extract data from PDF: How to convert PDF files into structured data
Convert PDF bank and credit card statements to Excel
How to batch convert PDF to Excel
Convert pdf to Excel spreadsheet or Google Docs sheet
Custom Slack + Airtable Task Management Application
Create Images Automatically with Bannerbear & Zapier
πŸŽ‚ Send Automated Birthday Messages to a Channel in Slack
Zapier - the basics
Approval Workflow in Coda
Send a personalized download link with YAMM
Build an Event Attendance App with Glide
An Employee Directory with Glide
Build a Reading Tracker in Glide
Build an Airtable powered mobile app with Adalo
Job application tracker with Airtable
Document automation and workflows with Documate
Make your own Instagram with Glide
Build a conference app with Glide
Automated task management in Trello
Dynamically generate Google Docs
Build an employee directory with Glide
Save Gmail attachments to Google Drive + Airtable
Cameo clone in Glide - book video shoutouts from celebrities
Daily stand-ups or check-in bot in Slack and FlowXO
A conference mobile app with Glide
Simple eCommerce mobile app with Glide
Send an app download link via SMS to signups with Twilio
Mental wellness mobile app with Glide
🧾 Reimbursement and expense tracking app
Simple multiple-step form with Boundless
Live sports scoring app with Glide
5 minute journal for everyday using Notion
To-Do template for everyday using Notion
Instagram clone using Glide and a Google Sheet
Build a Slack / Airtable / Stripe CRM
Group Scheduling App
Creating a podcast app
Creating an event check-in app
Fundraising CRM - Startups seeking to raise funding
πŸ‘¨β€πŸ‘©β€πŸ‘§β€πŸ‘¦Personal CRM - keep track of people in your life
Scheduled summary of Stripe charges in Slack
Automated digest of Pocket activity
Automated weekly/hourly email digest
Automated transcription from a Dropbox file

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.

Ready to get started?

Join the community and start turning your ideas into solutions