ExploreEducationHow do IΒ build?MembersToolsWorkshopsJobs

Join Makerpad today

Makerpad is home to over 10 thousand folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
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.
Get up to $200 by referring a friend

Bring no-code skills to your work

From learning new skills for your projects to automating and shipping faster in your team
For BusinessFor individuals

Share

Tutorials
/
πŸ“š Build a Reading Tracker in Glide
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

πŸ“š Build a Reading Tracker in Glide

Link to Demo

In this tutorial we'll show you how to create an app in Glide to track the books you are reading and have read.

What you'll need

  • Glide
  • Google Sheets
  • Simple Scraper

Estimated time to complete

  • 15 minutes

Open a new Google Sheet and create the following columns:

  • Book Picture
  • Book Title
  • Book Author
  • Category
  • Book Info
  • Completed
  • Review
  • Progress (formula: =IF(F:F="","",1) )
  • Progress Bar (formula: =sum(H:H))

‍

If you haven’t already, install the Simple Scraper Chrome Extension. Find a website that lists books (this tutorial used https://www.nytimes.com/interactive/2019/books/notable-books.html) and select the following properties:

  • Book picture
  • Book title
  • Book author
  • Category
  • Summary

Click 'View Results' and export the results on the next page to CSV. In your Google Sheet, click File β†’ Import, select the CSV, and select 'Append to current sheet'.

‍

Create a new app in Glide. Upload the Google Sheet. Create a Tab for Books and Profile. Click on 'Layout' and select the Books icon. Title should made to Book Title, Details to Book Author, and Image to Book Picture. Click into the list item and add the following components:

  • Image (Book Picture)
  • Basic Text (Book Title)
  • Basic Text (Book Author)
  • Basic Text (Book Info)
  • Basic Text (Category)
  • Checkbox (Completed)
  • Favorite
  • Set the Key to Book Title
  • Form Button
  • Link the Review Button to the Review column.

For the Profile tab, add a Progress Bar and Inline List component. Link Progress Bar to to the Progress Bar column.

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

‍

You must be a member to view the full lesson

Join Makerpad today

Makerpad is home to over 10 thousand folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
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.
Get up to $200 by referring a friend

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

Tools

Tutorials

Stories

Ready to get started?

Join the community and start turning your ideas into solutions