Turn Gravity Forms into a powerful database solution

Turn Gravity Forms Into a Powerful Database Solution

Written by Casey Burridge

Last updated:

Categories Gravity Forms, GravityView

Tags

Have you ever wanted to build your own Gravity Forms database system for collecting, storing and managing data?

Using GravityView you can do just that! 

GravityView gives you a way of storing, searching, and organizing your form data in a table layout so that it’s easily accessible from the front end.

In this post, we’ll show you how to use GravityView to turn Gravity Forms into a powerful database solution. We’ll also show you how to export database entries, edit entries from the front end and combine data from multiple forms into a single table. 

Sound interesting? Keep reading to find out more! 👇

Sneak Peek

Here’s an example of a database application built using Gravity Forms and GravityView:

A table containing data collected through Gravity Forms

What Is a Database?

A database is an organized collection of structured information (data) stored electronically on a computer system. The most typical database structure is a series of tables with rows and columns. This makes it easy to retrieve the required information from the database for managing, updating or deleting.

WordPress Database Application Builder for Gravity Forms

Are you wondering how to use WordPress to create a database application?

Database systems allow you to easily manage large amounts of information. Any functioning database should allow you to do the following:

  • Collect data
  • Retrieve data
  • Manage/organize data
  • Update entries

Using Gravity Forms and GravityView, you can build a custom database application!

📝 GravityView is an add-on for Gravity Forms that allows you to build powerful applications using your form data. GravityView table layouts make it the perfect Gravity Forms database plugin.

The rest of this tutorial will focus on building a front-end database system. Our database app will have the following components:

  • A form where users (or Admins) can enter information into the database
  • A Table layout displaying database entries on the front end
  • A search feature making it easy to find information in the database
  • An “Edit Entry” page where users can update entries from the front end

Let’s get started 🙌

Creating an Input Form

The first step is to create a form that allows you to add new entries to the database. You can also create multiple forms and then connect them to a single table (but more on this later).

💡 Pro tip: If you already have a form and entries, all you need to do is connect it to a View. We’ll cover this in the next step!

Your form will have different fields depending on the data you’re working with. For example, if you’re building a database of clients, you’ll probably want to include fields for the client name, email address, phone number, and the date they signed up for your services.

The Gravity Forms form editor

💡 Pro tip: If you want to transfer data from another website or application to Gravity Forms, you can use our Import Entries plugin

Customize Field Choices With Populate Anything

The Populate Anything perk by Gravity Wiz allows you to populate field choices and values with posts, users, taxonomies, or even data from Google Sheets.

This is really handy if you’re looking to build a dynamic system.

After you’ve installed Populate Anything, add a Drop Down field to your form, open the field settings and enable the option that says “Populate Choices dynamically”. You can now choose the type of information you want to populate the Drop Down with.

A checkbox that says 'Populate choices dynamically'

If you choose “User”, the Drop Down field will be populated dynamically with different WordPress users.

A Drop Down field showing different WordPress user names

When you’re done building the input form, don’t forget to embed it on a page or post!

Creating a View

The next step is to create a View for harnessing the data that users input via your form.

Using GravityView you can display Gravity Forms data in a Table layout. This allows you to read, search and edit the data added to your database. 

Create a new View by hovering over Views and clicking New View. Now select your input form as the data source and choose Table as your View Type. The Table layout allows you to display information in columns and rows.

📝 The two layout options best suited for a database application are the “Table” and “DataTables Table” layouts. We cover the DataTables layout below.

The GravityView View Types with the "Table" layout highlighted

Now you can start constructing your database application using the GravityView drag-and-drop editor. To add columns to your database, click on the ‘+ Add Table Column’ button and select the fields you want to add.

An arrow pointing to the 'Add Table Column' button

As you can see below, we’ve added four fields to our database – “Name”, “Email”, “Phone” and “Date”. 

💡 Pro tip: To change the field label text, modify the visibility settings and more, click on the gear icon to the left of the field name.

GravityView View editor

Here’s what our simple client database looks like on the front end:

A client database displaying client information in a table layout

So what if you need to update or delete entries from the database? That’s what we’re going to cover in the next section!

Making Your Database Editable From the Front End

GravityView gives users the ability to edit entries from the front end. To enable this functionality, all you need to do is enable the “User Edit” option and then configure the Edit Entry layout.

To enable User Edit, scroll down to the View Settings meta box, click on the Edit Entry tab and check the box to allow user edit. This will ensure that logged-in users can edit entries they create.

The 'Allow User Edit' checkbox in the Edit Entry settings

Now you need to add a link to the Edit Entry layout from the Multiple Entries page. To do this, click on the ‘+ Add Fields’ button and select the “Link to Edit Entry” field.

The GravityView 'Link to Edit Entry' field

Finally, click on the Edit Entry Layout tab at the top to configure the Edit Entry. The fields you add here will be editable front the front end.

An arrow pointing to the 'Edit Entry Layout' tab at the top of the View editor

That’s it! Users will now  be able to edit their own entries from the front end (Admins can edit all entries, as usual!).

Editing an entry from the front end

💡 Pro tip: Although not covered in this post, the Single Entry Layout allows you to display additional information about an entry. Check out our documentation to learn more about the Single Entry Layout.

Now let’s look at how you can search through database entries to quickly find the information you need.

Searching Through Database Entries

GravityView includes a handy Search Bar widget that allows you to add search fields to your View layout. This makes it easy to construct a searchable database from your Gravity Forms entries.

To add a search bar to your database, go to one of the widget areas, click on the ‘+ Add Widget’ button, and select Search Bar.

The GravityView Search Bar widget

To configure the search settings, click on the gear icon.

The gear icon next to the 'Search Bar' widget

Here you can add multiple search inputs, update the search mode and more. 

The search bar settings

Not only can you search for entries based on specific field values, you can also filter and sort entries.

Filtering and Sorting Database Entries

GravityView includes a range of built-in filtering and sorting options. To access these, scroll down to the Settings meta box and click on the Filter & Sort tab. 

The GravityView Filter and Sort settings

Here you’ll find a range of options for sorting and filtering the entries in your table. For example, by enabling “sorting by column”, you can sort entries by clicking on the column headers.

Sorting entries in a database by clicking on the column names

So far we’ve covered how to create a database, add a search bar and configure the sorting options. Now you’re probably wondering how to export that data for use in other applications.

Exporting Database Entries

GravityView includes a built-in export feature that allows you to export your database entries to either CSV or TSV.

To enable the export feature, head over to your View Settings, click on the Permissions tab and check the box that says “Allow Export”. If you want the export file to contain all the entries in the database, not just those displayed on the screen, ensure that you check the box that says “Show all in file”.

The GravityView Permissions settings

Users will now be able to export database entries by adding ‘/csv’ or ‘/tsv’ to the end of the View URL.

Now let’s take a closer look at the GravityView DataTables layout and why it’s the perfect layout options for building Gravity Forms database applications.

Displaying Entries Using the DataTables Layout

The GravityView DataTables layout includes advanced filtering and sorting options, making it easy to work with dense, numerical data. DataTables makes it easy to manage statistical, scientific or business data!

The GravityView DataTables Table layout

With DataTables, you also have the option to add a range of buttons to the top of your tables for exporting data to different file types and showing/hiding columns.

Sorting and filtering Gravity Forms data inside a GravityView DataTable

Now let’s see how we can combine data from multiple forms for displaying in a single table.

Combining Data From Multiple Forms in One Table

With the GravityView Multiple Forms add-on you can combine data from one or more Gravity Forms and display it in a single table.

Multiple Forms works in a similar way to an SQL “join” operation, allowing you to combine individual entries from multiple forms into one, longer entry.

Joining multiple Gravity Forms together using the Multiple Forms add-on

💡 Pro tip: Check out our documentation to learn more about our Multiple Forms add-on.

Start Building Your Gravity Forms Database Today

Gravity Forms is a powerful WordPress plugin for collecting all kinds of data. However, managing that data can be difficult. In this post, we showed you how to build a Gravity Forms database application using GravityView. 

GravityView allows you to display Gravity Forms data in a table layout using rows and columns. You can also export, filter, and sort the data you collect. To learn more about building database applications with GravityView, read Creating a Student Database With GravityView.

Join Our Newsletter!📧🙌

✅ Helpful Gravity Forms content straight to your inbox

✅ Be the first to hear about new updates and releases