Home Courses Blog HTML Cheat Sheet Login

Automate Quick Base Tasks with the Click of a Button

Learn How to Unlock the Secrets of API Buttons today!

Save 75% through Nov 17th
Checkout with code: QBJ75

Enroll Now Course Details

Here are a few of the benefits you can realize with QuickBase API buttons!

  • Reduce effort by automating repetitive tasks with click of a button
  • Minimize the number of clicks necessary to accomplish a task
  • Enable action at the point of need
  • Reduce training needs, when fewer steps are required
  • Improve quality by eliminating failure points due to human error
  • Ensure standardization of processes
  • Facilitate proper navigation through a Quick Base app
  • Decrease the time users spend searching for next workflow step

Get access to the Secrets today!

Don't spend thousands of dollars outsourcing when you can invest in developing your own skills! In just a few days you'll learn what would normally take hundreds of hours to research and test.

What You'll Get With This Course

All of the following and more will be available to you when you enroll in the Secrets of APIs online course.


Step-by-Step Guidance

Everything you need to use the 5 most common QuickBase APIs in your applications

Instruction that breaks down 24 different URL formula components

An easy to remember 4 part structure that will help you create your formulas with ease

Detailed instruction on best practices


API Button Examples

Discover multiple use cases

End-to-end demonstrations covering the business scenario, application setup, formula writing, and implementation in Quick Base.

Examples include all of the QuickBase APIs, Actions, Parameters, Functions, and Navigational Handlers covered in the course.


PDF
Downloads

Access quick references that can be used after the course

Downloads include:
Swipe files of all the demonstrated formulas that you can copy & paste

Cheat sheets for all the formula components covered

A decoder for all the field format requirements when using APIs

A troubleshooting guide 


Bonus
Lessons

Nearly an hour of bonus lessons included!

Lesson topics:
Dealing with attachments

'Select Next' style buttons

Trigger a notification with a click

Bundle Option:
Add The Power of Rich Text Formulas for Custom Buttons to your order and save $97!

Enroll Now

But how do API Buttons deliver value?

Sample Scenarios & ROI

For some, the term API may sound like a cute way of referring to an application or slang for an appetizer.

The fact is, APIs are a powerful Quick Base feature that every builder should be familiar with.

They're like mini-programs that you can tap into to do your bidding!

Let me give you a scenario

Say you have a Quick Base app that your engineers (or other personnel) use to track time against specific projects. Your app has two related tables, Projects & Time.

Without APIs

Starting work the engineer opens the Project (parent)

Clicks a standard relationship button to add a new Time record (child)

With the new record open, the engineer:

  • Enters the start date
  • Enters the start time
  • Saves & closes the record

When the work stops, the engineer reopens the Project and:

  • Identifies and selects the incomplete Time record
  • Enters the stop date
  • Enters the stop time
  • Saves & closes the record

With APIs

Starting work, the engineer opens the Project (parent) and clicks one button that automatically:

  • Creates the new Time record
  • Enters the current date in the start date field
  • Enters the current time in the start time field
  • Saves & closes the record

Stopping work the engineer opens the Project (parent) and clicks one button that automatically:

  • Locates the incomplete Time record
  • Enters the current date in the stop date field
  • Enters the current time in the stop time field
  • Saves & closes the record

Comparison

  • Without APIs, the steps take 26 seconds
  • With APIs, the steps take 6 seconds

A 20 second difference may not seem like a very big deal, but let's do the math of how this adds up over the course of a day and year:

Savings

Let's assume the logging of time is repeated throughout the day for half a dozen projects, by a team of 12 engineers.

A 20 second (or .333 minute) difference x 6 projects x 2 times a day (start & stop) x 12 engineers = 48 minutes/day

Multiply that by 260 working days in a year = 208 hours

At a fully-loaded rate of $50/hr and you get $10,400 in gained productivity!

And that doesn't even include the benefit of removing errors that may arise from manually entering the date and time without the API solution.  

Estimating a 1% error rate, where errors take 5 minutes to resolve (possibly involving multiple departments and back and forth communications), we can add $1,560 to our total.

This brings us to $11,960… in one year for just a single use of an API button in a Quick Base. And there is often a half dozen or more API buttons a single company can benefit from.

Arguments

Now you may be thinking, but my team is smaller or is paid less. Well even when you cut both those numbers in half, the total productivity savings is still $2,990. For one year… with one application!

This is time that can be better spent on value-added activities and work that makes people satisfied with their job.

Solution

This time tracking example is just one of many examples I walk through, step-by-step, in the Secrets of API Buttons Premium Course. Teaching everything you need to know about creating API Buttons and providing ideas and inspiration for your apps.

Scenario

You are using Quick Base to solve two different issues.

  1. As a help desk ticket queue (serviced by email)
  2. As a self-help repository of frequently asked questions (FAQs) and answers

Without APIs

When an agent sees on a ticket that the question can be resolved with an FAQ they leave the ticket to:

  • Open the FAQ app
    • Identify the FAQ answer
    • Copy the answer
  • Open their email
    • Create an email (likely a template)
    • Paste the answer
    • Send the email
  • Return to the Ticket app
    • Note the date
    • Note the FAQ sent
    • Update the status
    • Save the ticket

With an API Button

When an agent sees that a question can be resolved with an FAQ they:

  • Select the FAQ from dropdown within the ticket
  • Click a single button that automatically
    • Populates & sends a Quick Base notification email with the answer
    • Updates the ticket (noting the status, date, and FAQ sent)
    • Saves the ticket

Comparison

  • Without APIs, the steps take 87 seconds
  • With APIs, the steps take 15 seconds

A difference of 72 seconds (or 1.2 minutes), per ticket.

Savings

If we have 10 agents who handle 5 of these types of questions per day, what can we expect?

10 Agents x 5 tickets x 260 working days in a year  x 1.2 minute savings = 260 hrs/yr

At a fully-loaded rate of $30, we get a $7,800 productivity savings...per year!

And that doesn't even include the benefit of removing errors that may arise from manually copying/pasting, composing, noting, etc.  

Estimating a 1% error rate, where errors take 5 minutes to resolve, we can add an additional $325 to our total.

This brings us to $8,125… in one year for just a single application of an API button in a Quick Base. And there is often a half dozen or more API buttons a single company can utilize.

If your teams are larger, even if the work is different, you can see the impact that adding API buttons has.

Arguments

However, if your team is smaller or paid less, you might be more skeptical.

Even when you cut both the team size and their rate in half, the total productivity savings is still $2,031.25. For one year… with one application!

This is time that can be better spent on value-added activities and work that makes people satisfied with their job.

Solution

This FAQ Emailing example is just one of many examples I walk through, step-by-step, in the Secrets of API Buttons Premium Course. Teaching everything you need to know about creating API buttons and providing ideas and inspiration for your apps.

 

I want to share one more API scenario. You can probably tell I really think API buttons can be a game changer when it comes to increasing productivity.

But, productivity isn't the only thing they can be useful for.

Gathering insights has been a vital part of my business and many of the roles I've previously held.

Insights assist with good decision making. When you have good insights you make better decisions, it's as simple as that.

Let me give you an example.

You have a Quick Base app that contains frequently asked questions (FAQs) and answers to those questions. This is great for your team because questions they used to have to spend time answering are now available self-serve through the Quick Base.

What you don't know is if the answers are helpful or could be improved.

How APIs can help

Using an API button, we can add voting directly on the records that contain the FAQs.

Clicking on the "helpful" button would add to an overall Helpful Score, as would a click on a "not helpful" button.

Also, it is possible to disable multiple votes by the same person and have an audit trail (anonymous or not) of all the votes.

Results

After a period of time having the voting buttons, you can see it will be much easier to target which FAQs need work and which are performing well.

By focusing efforts on those that need work, you save effort and also increase the overall number of people who will be able to self-serve. Win-win!

Implementation

This voting example is just one of many examples I walk through, step-by-step, in the Secrets of API Buttons Premium Course. Teaching everything you need to know about creating API Buttons and providing ideas and inspiration for your apps.

"Not long ago, I too was a Quick Base builder working to get ahead by solving big business problems.

But for years, I struggled with leveraging APIs in my Quick Base apps.

The documentation just didn't click for me, and I had no one else to learn from.

Finally, I decided I couldn't continue building apps without knowing how to use APIs.

It took a lot of hard work, piecing together different sources of information.

But, I was able to figure it out and completely up-level my Quick Base game!

Once I applied the secrets to building API buttons, work that once took minutes or hours to complete now only takes seconds. 

My only wish is that I would have learned them sooner.

Now I help others learn the same secrets in a fraction of the time!"

Sharon Faust
Expert Builder | Instructor | Founder
of Quick Base Junkie

Sample Videos

Below are several videos from the Secrets of API Buttons course.

 
 

Secrets of API Buttons - Course Outline

In this course, you'll master the Quick Base API Button and Increase Productivity!

Enroll Now
Enroll Now

"API buttons have opened up a whole new world for me in terms of efficiency with QB. Thanks!"

Melissa A. Freel
Director, Quality and Administration

"Sharon creates learning tools that are so valuable. She guides you through her instructional videos so well that it easy to grasp and apply what she teaches. Whether you are new to Quickbase or a builder with some experience under your belt, you will find Sharon's learning tools worth every penny."

Brian Cameron
Quick Base Developer - Certified Expert Builder

"Your website & instructional videos have been instrumental in my journey through Quick Base app development. The first video I watched was about customizing rich text fields, I think it's called something like "wow you can do that with a rich text field?". I was hooked after that. Quick Base Junkie is a lifesaver - Thank you so much for the work you do!"

Katherine

"I discovered your channel some months back. Wish a channel like yours existed when I started working with Quickbase last year lol ... A great resource for people just getting started with QB and even those who need a quick refresher. I'll be sure to recommend your channel to anyone I know that works with QB and is looking for well crafted tutorials :D"

Antonio

"I’ve been looking at your website and appreciate all the great content you have available there! I also just subscribed to your mailing list and look forward to getting your emails and learning new tricks."

Eduardo

"I love your website, it seems like a great reference for new and experienced users... I've bookmarked your site and I'm looking forward to using it as a reference regularly!"

Erik

Need help justifying the education investment?
Check out these sample scenarios.

Sample Scenarios

Frequently Asked Questions

Select a course to learn more:
 

For info on all courses, including those coming soon, visit: https://quickbasejunkie.com/courses

I know it's possible to learn all the information contained in this course in other ways. That's how I did it. But it's an understatement to say was hard and time-consuming.

What I've done with this course is take all that information, knowledge, and experience and package it up.

I've developed a method for breaking down the complex topic of API buttons into manageable pieces that build on each other as we go along.

In addition, this course is rich with features not offered anywhere else!

  • Videos
  • Downloads
  • Assessments
  • Quizzes & Games
  • Recommended Exercises
  • Save / Resume Progress
  • Search for key terms
  • Troubleshooting Guide
  • Answers to FAQs
  • Closed Captioning
  • Completion Certificate

These features seamlessly work together to enable you to learn API Buttons FAST!

This course is for:

  • Anyone who has the role "Administrator" in a Quick Base app.
  • Anyone who has the ability to build, create, or develop in their Quick Base apps.
  • Quick Base Account Admins.

Prerequisites:

  • General experience building apps (ie adding tables, fields, & relationships).
  • A basic understanding of writing formulas.

This course contains:

  • An overview of what APIs are and how they can be used with buttons
  • Everything you need to use the 5 most common APIs in your applications
  • Step-by-step instruction that breaks down 24 different URL formula components
  • An easy to remember 4 part structure that's used in every API formula
  • Detailed instruction on best practices like using variables and notes
  • An entire section focused on navigating to a record, report, or page
  • Numerous examples using the 24 components & 4 part structure to create game-changing workflows

These examples include demonstrations on:

  • How to trigger multiple APIs with a single button click
  • How to append new data to existing fields vs overwriting them
  • How to set up a button to do a different job depending on the state of the record
  • How to require a user sign in if using an API button in an email
  • How to dynamically set parameter values using multiple formulas and functions

Plus More:

  • Exercises, quizzes, and games to reinforce key concepts
  • An entire lesson focused exclusively on troubleshooting
  • Answers to frequently asked questions (FAQs) about API buttons
  • Downloadable reference documents, cheat sheets, and swipe files
  • Bonuses:
    • Dealing with Attachments
    • Using 'Select Next' buttons on Table, Calendar, and Kanban Reports
    • Sending an email notification with an API Button

This course will cover the following APIs (all other APIs are not included):

  • API_AddRecord
  • GenAddRecordForm
  • GenCopyRecord
  • API_EditRecord
  • API_DeleteRecord

This course will cover using the URL Formula field to construct the API buttons. The Power of Rich Text Formulas for Custom Buttons course covers using the Rich Text Formula field.

This course includes sections for Troubleshooting and answers to FAQs. I will do my best to answer questions you have about implementing the formulas taught in this course, however I will not be able to troubleshoot your formulas for you.

Once your purchase is complete you will be asked to set up a Quick Base Junkie account and will get immediate access to the course.

All courses are hosted online and are accessible by logging into your Quick Base Junkie account anytime. 

This course consists of:

  • Videos
  • Quizes & Assessments
  • Exercises

The total video time is 4.5 hrs.

With the additional time for quizzes, assessments, and exercises I suggest planning for 2 - 4 full days to complete the course and practice making API buttons.

Of course, you may choose to take longer if needed. All of your progress is automatically saved and can be accessed anytime.

Yes! I've added Closed Captioning to all of my videos.

Closed Captioning is great if you are hearing impaired or if English is not your native language.

And, it is also great if you are a visual learner.

PLUS: You can search the videos for key terms using the CC menu!

Yes! I offer discounts for teams and non-profits.

Please contact me with the number of people on your team and which courses you're interested in purchasing.

[email protected]

I know you won't be disappointed with this course.

If for some reason the videos, quizzes, bonuses and downloads are not what you expected, you can request a full refund within 30 days.

No, Quick Base Junkie and Quick Base have no formal connections.

I love their product and use my expertise to enable builders to get the most from the apps they create.

Still have questions?

Close

 

Sign-up for Premium Course Info

Be the first to get the latest information on the availability, content, and pricing of Quick Base Junkie Premium Courses.