words ~ min read

How users perfect their workflows using Jotform Tables

We released Jotform Tables in late 2020, the middle of the pandemic.

No problem, right?

The circumstances of the time (a hard right into remote work amid a growing need for collaborative software and flexible data management) made it even more important for users — who were quickly becoming more dependent on online forms — to manage the information they were gathering in a complementary way.

You see, many Jotform customers were sending their collected data to third-party software tools that they could use to analyze, visualize, and share the information.

It just so happened that we were already two years into product development when a (hopefully) once in a lifetime pandemic created an urgent need for features that could not only solve these gaps in service within Jotform but also round out the new product into something that was “more than just a spreadsheet.”

As a result, Jotform Tables was born. A workspace automatically populated with your form submissions, Tables allowed you to

  • Analyze your form data and any other data you wanted to add or import
  • Share your workspace with anyone, controlling their access and activity permissions
  • View recent changes and restore previous versions of submissions
How users perfect their workflows using Jotform Tables

Top use cases for Jotform Tables

In the years since Jotform Tables launched, we’ve continued to identify new uses and user scenarios based on your feedback. It’s an ongoing product improvement effort to meet you where (and how) you like to work best.

We’ve also added new capabilities and made important updates to Jotform Tables that complement its core uses nicely.

So with that said, let’s explore some of the main uses of Jotform Tables and the ways users get more done with it.

Lead management

The industries above are a good cross-section of Jotform Tables users, but just about every industry or organization needs to manage new business of some sort.

The search and filter capability makes it easy to identify leads in your table based on the characteristics your customers specify in their forms. Such characteristics can include geographic location, company size, business need, and more.

A key feature used in lead management is exporting lead submissions to Excel. Also, when you need to take action on a lead, it’s handy to share your table and assign leads to chosen stakeholders directly.

Lead management

Pro Tip:

You can easily convert an existing CSV or Excel file to a table by selecting the Import Data option when creating a new Jotform table.

Finally, users leverage the Send Data to Other Apps Action Button to sync their table data with their cloud storage app, CRM, project workspace, email provider, or support desk (options include Google Drive, Salesforce, Mailchimp, Zendesk, Asana, Slack, and more).

Employee or volunteer recruitment

Our users lean on Jotform Tables when they need to organize and manage the recruiting process. They can implement one-click Send PDF or Send (follow-up) Form Action Buttons that come in handy for automating what’s typically a back-and-forth administrative email chain.

Or they may use the handy Cards or Uploads view to evaluate a candidate’s credentials (such as resumes, curriculum vitae, and photos) in a more intuitive and helpful way.

Employee or volunteer recruitment

Users who are involved with recruitment know that the first application form is only the beginning. There will be successive forms and more information to gather. So having the ability to connect multiple tables (representing your separate candidate-related forms) means the candidate details you need to rely on are organized and at the ready.

Activity registration & fundraising, plus event management

When users need a workspace to manage all their activity and event-related work processes, they find helpful “one-stop shop” solutions within Jotform Tables.

For example, the Knoxville Football Club in Tennessee has used Jotform Tables to monitor and track incoming information from tournament registration and waiver forms submitted by coaches and players.

When collaborating on a table, sometimes changes are made and you’re not sure why. In times like those, our activity and event managers use one of the cooler features of Jotform Tables: revision history. Unlike a spreadsheet, this functionality lets you view recent changes, access deleted entries, and restore previous versions of your project workspace.

Finally, when they need a presentable report of their activity registration or fundraising effort, these savvy users employ the Reports view within their table.

Reports view

With just a couple of clicks, their table entries are converted into visual reports containing the kind of graphs and charts they need to analyze their data holistically. It’s a snap, and sharing the reports (with a link or download) is just as easy.

Report convertion
Turn your form responses and table data into professional reports today

Customer satisfaction & appointment setting

Whether our users are responding to an important customer issue or setting appointments for their small business, the feature flexibility within Jotform Tables is a lifesaver. In both scenarios, users can assign entries to collaborators so that they can solve the issue or schedule an appointment.

Users also employ basic, numeric, array, and lookup function formulas by adding a new column within the table to calculate overall satisfaction scores and see appointment trends.

Customer satisfaction & appointment setting
Advanced formula

Customer satisfaction often involves back-and-forth feedback. Connecting multiple tables (for multiple forms) syncs data to create a holistic file associated with the customer and their issues (and/or appointment history).

When an issue has been addressed and administrators would like updated feedback from their customers, they use the Request Update Action Button to send their customers a link where they can update their form submissions.

Issue or inventory tracking

Issue and inventory tracking may not be exciting, but it’s super important if businesses want to improve. The issue and/or inventory process is usually initiated with a form, so being able to organize that effort in Jotform Tables is a big convenience for our users.

Issue or inventory tracking

Connectivity is an advantage in Jotform Tables when proprietary systems are part of our users’ workflows. They use the Send Data via Webhook Action Button to write rules that send their data from their tables to their internal servers, APIs, or SQL databases.

It’s also easy to use the Send Email Action Button within your table to keep your issue submitter up to date on their request.

Excel and Jotform Tables insight from Jotform Customer Support

A tabular workspace and a spreadsheet aren’t the same; however, they often work in a complementary fashion. Perhaps the most popular feature of Jotform Tables is the import/export Excel/CSV feature.

Recently, a Jotform user asked our Support team this question:

“Hi, is there any way I can connect my Jotform Tables submissions to create a table in Microsoft Excel (saved either in OneDrive or SharePoint)?”

The answer, of course, is yes!

To do this, use the Microsoft Power Automate integration to connect your Jotform Tables submissions to a table in Microsoft Excel.

Jotform Tables templates for every possible use

You may have noticed that “templates” consistently appear in the features and tools for all of the use cases above.

That’s because our users have benefitted from over 300 templates for more than 25 categories that cover almost any use case you can think of (pet training log anyone?).

Jotform Tables templates for every possible use

Our Jotform Tables templates have kick-started the post-collection data management workflow for the users above and many more.

We make it easy to search for the table template you’re looking for. You can also preview the template to see if it will work for your needs and see a demo to explore even further.

As a reminder, all of our templates are customizable, so if you’re 90 percent in love with one but need to change a thing or two, be our guest!

Here are a few templates you can choose from to get started:

Jotform Tables Banner

How Flint Hill School’s learning specialists use Jotform Tables to serve their students

Anyone in the education sector knows that maintaining comprehensive information about multiple students can be difficult. Jotform offers a variety of ways to automate this work, as exemplified by the learning specialists at Flint Hill School in Oakton, Virginia.

First founded in 1956, Flint Hill School now encompasses over 1,000 students spanning kindergarten through 12th grade. It also houses a Learning Center where students can meet one on one with in-house learning specialists for support.

Learning specialist Sonya Atkinson focuses on mentoring and coaching students in her sessions, during which she jots down notes. These notes are crucial to her understanding of each student, especially when she wants to refer to them during sessions. This is where Jotform comes in.

Flint Hill School Logo

Case study results at a glance

Recorded notes on over 3,000 sessions using one form

With Jotform, Sonya Atkinson created a workflow that replaced the age-old pen and paper. This helps her capture important information about her students in a snap.

Customized forms to meet specific needs

Because of Jotform’s 10,000+ form templates, widgets, and customization options, Flint Hill School can customize its forms to meet the needs of learning specialists.

Easily sort notes in Jotform Tables

Instead of looking through pages of notes, Atkinson can use the search and filter functions in Tables to quickly access the coaching notes she needs.

The Form Builder boasts a variety of useful tools and features

Before using Jotform, Atkinson would take notes by hand using pen and paper. She says she wasn’t able to capture much information and decided to search for an automated method.

She gave another form builder a shot, but describes the interface and spreadsheets as clunky and limited.

Atkinson found that Jotform’s intuitive drag-and-drop Form Builder could get the job done. Thanks to 10,000-plus templates, she has lots of inspiration for her own forms. These templates, she says, also teach her about some of our handy form widgets, like the Configurable List element.

Sonya Atkinson

“To me, [Jotform is] a more robust offer,” Atkinson says.

So far, Flint Hill School’s Learning Center has developed online forms for the coming school year. This includes a referral form for teachers and advisors, as well as a questionnaire for students.

For the questionnaire in particular, one standout feature is the Page Break element, which splits the form into pages. This prevents students from being immediately bombarded by a long, tedious-looking form.

Of course, student data is also particularly sensitive. That’s why Atkinson appreciates Jotform’s HIPAA features, which add another layer of protection to students’ submissions.

What Atkinson uses on a daily basis, though, is a coaching log she developed through Jotform. In this particular form, she has laid out sections for goals, reflections, an overview, and action items. Atkinson can seamlessly multitask as she chats with students by simultaneously filling out each respective section.

Then, when she needs to access everything she jotted down, she simply looks through her notes in Jotform Tables.

Jotform Tables saves valuable time

Jotform Tables further streamlines Atkinson’s work thanks to its sortability. Since she enters every student’s name and their session dates into her log, she can type a name into the Tables search function or use filters to quickly find the corresponding notes.

“What I like about Jotform is it separates everything out by student, by searchability,” Atkinson says.

This is useful when she’s already in a session with a student she’s talked to before. Instead of rummaging through papers, she can take a few seconds to pull up the last session’s notes. Once the submission information opens, Atkinson can immediately view her notes and refer to them.

Jotform Tables also comes with different views beyond Table view. If Atkinson wants to see her submissions more holistically, she can change to Cards view. Alternatively, Flint Hill School users can also turn to Calendar view to easily see their submissions by date or even Uploads view to instantly access files uploaded through the form.

An example of Cards view in Jotform Tables
An example of Cards view in Jotform Tables

If Atkinson needs to collaborate or share notes with a student, Jotform Tables allows for easy sharing. All she has to do is update her privacy settings and share the spreadsheet via email or a copied link.

Atkinson especially values the ability to edit submissions directly from Tables.

“Because I see my students back to back, I may need to hit submit to keep things moving. But the fact that I can go back to it and add in whatever else I needed to capture is a time-saver in and of itself,” Atkinson says.

In fact, Atkinson feels like Tables was “literally custom-built” for her, considering she previously provided feedback to our user research team. During that conversation, Atkinson mentioned she wanted to edit her submissions without backtracking to her form, something she couldn’t previously do in Jotform Tables. And of course, Jotform listened.

“I am very pleased with the improvements. I can’t tell you how many times I’ll go into ‘View [submission]’ and just quickly make edits to things before I start the new session with the next student,” Atkinson said. “It’s really helpful. I appreciate that feature quite a bit.”

Atkinson’s experience with Jotform shows how many possibilities open up once you start using our features, in part thanks to great feedback from her and many other users. We’re constantly looking for more ways to improve our platform and streamline your work. And we’re thrilled that we’ve done exactly that for Flint Hill School and its Learning Center.