Case Study: Building a film location database for the Nevada State Film Office

An interview with WayLay Design, a web design company based in Las Vegas, Nevada.

Nevada Filming Location Database

Case Study: Building a film location database for the Nevada State Film Office

WayLay Design - Team

We talked with Wayne and Selina at WayLay Design, a Las Vegas-based graphic and web design business about how they are using GravityView.

For their most recent project, they used Gravity Forms and GravityView to build a database of film locations for the State of Nevada’s Film Office. The application allows business and property owners to submit and manage film-friendly locations in Nevada and then lets location scouts, location managers, production companies, and other filmmakers to easily browse through the submitted listings. It’s really slick 🔥💯🔥

Check out the Nevada Film Office GravityView application Continue reading

Creating a student database

Creating a student database with GravityView

On our blog, we recently featured a case study of one of our users, Adam Cavotta, who is a Senior University Training Specialist at New Mexico State University. NMSU uses GravityView in nearly 10 different ways. In this ongoing blog series, we’ll teach you how to create similar applications for yourself.

Want to read more about using GravityView at universities, schools, and other educational institutions? Check out our guide.


In this post, we’ll walk through creating a student database. Here’s what our final product will look like (using the default Twenty Seventeen theme):

Student Database

Here’s what it will be able to do:

  • View all student profiles at once
  • Search and filter through student profiles
  • View a specific student’s profile
  • Automatically filter through students
  • Allow administrators to modify student information directly on the front end of the website

Let’s get started!

Step 1: Create a Submission Form

First, we’ll need to create a form in Gravity Forms for adding new students. To do this, go to Forms > New Form on your WordPress Sidebar.

New Form

Tip: Already have a directory file of students? Not to worry. Importing it into Gravity Forms and GravityView is super simple with our Import Entries plugin. You can import CSV files in seconds.

Give your form a title – let’s call it Add a New Student to the Database.

Title for Form

Now we need to add the relevant fields. These will depend on the nature of your school (university vs. elementary school, etc.) Some common options include:

  • First and Last Name
  • ID Number
  • Email
  • Photo
  • Date of Birth
  • Year of Graduation
  • Locker Number
  • Department
  • Enrolled Courses

…and so on.

Let’s add all of the listed items above to our form. To add a field to your form, simply drag it to the left. You can also just click the field to add it.

Tip: Want to make sure that all of the fields are filled out? Be sure to enable “Required” at the bottom of each field.

Required option

For First and Last Name, add the Name field, which is under Advanced Fields.

Field - Name

For ID Number, we can add a Number Field, which is under Standard Fields. If your ID number includes letters or other non-numeral symbols, you’ll need to use a Single Line Text field.

ID Number field

Once you add a Number field, click on it to edit its options. Rename it to “ID Number.”

For Email we’ll use the Advanced Field, Email.

Email field

For Photo, we’ll use a File Upload field, which is under Advanced Fields. Once you add it, click on it to change a few options:

  • Rename it “Student Photo”
  • Type “png, jpg, jpeg, gif” into the Allowed file extensions option. This will only allow users to upload image files (and not other types of files.)
  • Type a number into Maximum File Size option. Typically, an image should not be more than 10-15 MB.

Student Photo

For Date of Birth, we’ll add a Date field, which is under Advanced Fields. Rename the field to “Date of Birth.” We’ll change the date format to be yyyy/mm/dd. You can also add a calendar icon, if you wish.

Date of Birth

For Graduation Year, we’ll add a Radio Buttons field, which is under Standard Fields. Rename it and add an option for every graduation year. To be safe, add at least 10-15 years into the future. Alternatively, we could use another Date field. This will future-proof your field at the cost of being more cumbersome to use.

Date of Graduation

For Locker Number, we’ll add a Number field and rename it.

Locker-Number

For Department / School, we’ll use a Checkbox field. This will allow students to belong to multiple departments or schools. For example, a university student may be a double major in Biology and Philosophy, and thus would belong to the “School of Sciences” and the “School of Humanities.” Be sure to add all of your school/university’s departments.

School

For Major, we’ll add another Checkbox field. Just like the Department field above, this will allow a student to have more than one major.

Major

Finally, for Enrolled Courses, we’ll use a Checkbox field. This will allow an administrator to add a student to multiple courses.

Enrolled Courses

Conditional Logic

Want to only display a particular field if a certain option is selected? For example, you may want to create a specific Enrolled Courses field for each major, rather than have all the courses for all majors listed in one field. That way, only the relevant course options will be displayed.

To do this, you’ll need to use Conditional Logic. First, go to the field that you want to be “activated” only under certain conditions. For example, this may be the Major: Medicine – Enrolled Courses field. Under the Advanced tab, check the box next to Enable Conditional Logic.

Conditional Logic

You can now choose when this field will be displayed (or hidden). For our example, choose Major + is + Medicine. Now, this field will be hidden until the Medicine choice is selected for the Major field.

Conditional Logic

You can create complex logic trees using this functionality.

Press update to finalize and save our form. As a final step, you’ll want to add this form to a page. To do this, create a WordPress page and click Add Form.

Add Form

Now that we’ve created the form, let’s see what it looks like!

Form

Looks good! If you test it out, you’ll see that the Enrolled Courses: Medicine field is using the conditional logic we set up.

Tip: You will want to change the confirmation message. You can do this on the Settings page of your form.

Part 2: Creating a View

Note: For this part, we’ll assume that you have already added a number of students to your database.

Now that we have a form, let’s create a View. A View will allow us to display and modify the entries from the front end of our website, without having to log into the back end.

To start, go to Views – New View on your WordPress sidebar.

New View

Let’s call our View “Student Database.” Under Data Source, select the form we previously created – Add a New Student to the Database.

Data Source

Then, we need to choose a View Type. For our purposes, we want either a Table layout or a Listing layout. The table layout will display all of our entries (students) on one page, in a table, while the Listing layout will display each student individually in a listing. Unless you have very few students, you’ll probably want to use the Table layout.

Now we’re on the View Configuration page. Here’s what we want to create:

  • A Multiple Entries page, where we can view, search, and filter through student profiles
  • A Single Entry page for each student, where we can see all the details (fields) of a particular entry (student)
  • The Edit Entry page, where we can modify the details of a particular entry (student)

Let’s start with the Multiple Entries Context. At the top, under Above Entries Widgets, we want to add some widgets. Click Add Widget and then click on each item to add it to the View. Note that you can also add widgets below the Entries (in the Below Entries Widgets section).

You can customize how it looks by adding it to the Top, Left or Right area.

Show Pagination Info

This will show us how many student entries are currently visible. For example, 20 of 1,000

Page Links

This will add navigation links to multiple pages

Search Bar

This will let us search through the database for a particular stduent

A-Z Entry Filter

This will let us filter students by their first or last name

Widgets

Once we add the widget to the View, you can customize its options by clicking on the blue gear icon. Depending on what functionality you need, there are many possibilities:

  • Edit the Page Links widget to enable show each page number, rather than a summary (e.g. 1 2 3 … 8)
  • Edit the Search Bar widget to customize what is searched through. By default, it will search through all fields. However, you may want to specify it to only search through a particular field, like Name. You probably also want to change “Search Entries” to “Search Students”
  • Edit the A-Z Entry Filter widget to choose which field will be used for alphabetization. You will likely want to select Last, the field for Last Names

Once you’re done adding widgets, scroll down to Entries Fields. This is the main part of our student database. Since the Multiple Entries context is only a broad overview of the students, we’ll only want to add a few specific fields. (We’ll add all of the detailed fields to the Single Entry Context.)

For this example, we’ll add the following three fields:

  • Name
  • ID Number
  • Department / School

Fields in Multiple Entries Context

Then, click on the blue gear icon next to the Name field. Enable Link to single entry at the bottom. This will allow us to click on the student’s name and see their details.

Link to Single Entry option enabled

Our Multiple Entries context should now be good to go!

Settings

Finally, let’s scroll down to the View Settings at the bottom of the View. There are a lot of options here for customizing your View. For our purposes, there are a handful of settings we should be aware of:

  • Under View Settings, you should enable Prevent Direct Access. If you enable this setting, the View will only be accessible on pages where you specifically embed it via a shortcode. This is very important if you want to keep your View private or restricted to particular users.
  • Under Filter and Sort, we can customize our filtering options. This is useful if you want to sort students by a particular field by default (like Last Name). You can also enable sorting by column, which will let you sort students by a field displayed in the View by clicking an arrow. In our example, you can sort the students by Name, ID Number, or Department / School.

Now, let’s take a look at our View! Press Publish and then View on website after the page reloads.

Final product - our student database.

As you can see, our students are now listed in the database.

  • We can click on a letter to filter them by name
  • We can search through the students
  • And we can click on different page numbers.

If you click on a student’s name, you’ll be taken to the Single Entry page. Since we haven’t set this up yet, we’ll do it now! Click Add fields to Single Entry.

Single Entry View of student

On the Single Entry Context, we want to add all the details of a specific student:

Add Fields in settings

Once you’ve added the fields, click Update and then View on website. Now click on the name field for an entry. As you can see, our Single Entry Context now displays all of the information about our student.

Single Entry of student

Note: If you used conditional logic to create specific fields earlier, be sure to add all of these fields to the Single Entry View. By default, empty fields will be hidden. This means that the field will only be displayed if it has content.

Edit Entry

Finally, the Edit Entry page lets administrators change the content of an entry’s fields. An “Edit” link is at the bottom of the Single Entry page by default.


That about covers our guide! If you enjoyed this walkthrough, check out some of the other posts in our blog.

  • Will renew yearly until cancelled.

  • Will renew yearly until cancelled.

  • Will renew yearly until cancelled.

Creating an academic advisor directory

How to make an Academic Advisor directory with Gravity Forms and GravityView

On our blog, we recently featured a case study of one of our users, Adam Cavotta, who is a Senior University Training Specialist at New Mexico State University. NMSU uses GravityView in nearly 10 different ways. In this ongoing blog series, we’ll teach you how to create similar applications for yourself.

Want to read more about using GravityView at universities, schools, and other educational institutions? Check out our guide.


If you’re a university, or other educational institution, you no doubt have a team of academic advisors. Why not make a directory for them like New Mexico State University’s, featured above? In this guide, we’ll walk you through making a directory for yourself.

Here is what our final application will look like:

Academic Advisors

Let’s get started!

Step 1: Create the form

First, we need to make a form for submitting a new academic advisor. To do this, go to Forms > New Form on your WordPress sidebar.

New Form

Then, title your form “Submit a New Academic Advisor.”

Form Name

Now we need to add fields to our form. We need the following information about our advisors:

  • Name
  • Job Title
  • Email
  • Phone Number
  • Photo
  • Office Address
  • About / Biography

Let’s add a field to our form for each of these items.

For Name, we can use the Name field, which is under Advanced Fields.

Name

For Job Title, let’s use a Single Line Text field, which you can find under Standard Fields.

Job Title

Click on the field to rename it.

Tip: Want to make sure that all of the fields are filled out? Be sure to enable “Required” at the bottom of each field.

Student Database 04

For Email, let’s use the Email field, found under Advanced Fields.

Email

For Phone Number, we’ll use the Phone field, also under Advanced Fields.

Phone

For Photo, we’ll need to use a File Upload field and customize it.

  • Rename the field to “Photo”
  • Type jpg, gif, png, pdf into the Allowed File Extensions setting. This will restrict uploads to only these file types.
  • Type a number into the Maximum File Size setting. Typically, an image should not be more than 5-10MB.

For Office Address, we can use the Address, under Advanced Fields.

Address

Once you add the field, you can customize how specific you want the address to be. For example, if your directory is for a single college campus, you can probably restrict the input to only Street Address. Alternatively, if you have multiple offices scattered around many cities or countries, you can include the City and Country options.

Address Options

Finally, for About / Biography, we want to use a Paragraph Text field. You can customize the size of the text input area under the Appearance tab.

About

All that’s left to do is add our form to a page. But first, save your form by clicking Update! Create a new WordPress page and give it a title. Add your form by clicking the Add Form button.

Add Form

Now save and preview your page.

Form

Our form looks good! Now we need to build the view.

Step 2: The View

Note: For this part, we’ll assume that you have already submitted a number of entries via your form.

The view is the main part of our application. It will allow us to “view” the academic advisor directory on the front end of our website, without requiring the user to log in.

To create a view, first go to Views > New View on your WordPress sidebar.

New View

Title your view “Academic Advisor Directory” and choose the form we created (Submit a New Academic Advisor) as your Data Source.

Data Source

Now choose a layout. Let’s use a List layout, as we want to display more information about each advisor.

If the physical location of your academic advisors is important, you can also use the Map view. This will display your entries on a map according to their Address field.

List View

Now we’re on the View Configuration page. Let’s start by customizing the Multiple Entries page.

At the top, let’s add a Search Bar widget.

Search Bar

We want to rename it, as “Search Entries” sounds a little impersonal. To do this, click on the blue gear icon next to the field. Then, rename it “Search Advisors”.

Search Options

At the bottom, under Below Entries Widgets, let’s add Show Pagination Info to the left and Page Links to the right. These will show how many entries are displayed on this page and links to other pages, respectively.

Below Entries Widgets

Now scroll back up to the Entries Fields section. To add a field, click +Add Field next to the specific section.

  • For Listing Title, select the Name field
  • For Subheading, select the Job Title field
  • For Image, select the Photo field
  • Under Other Fields, add About / Biography
  • Under Footer Left, add Office Address
  • And Under Footer Right, add Email and Phone

Entries Fields

We want to remove the labels for each of these fields. Why? Because the field content is already obvious – we don’t need to label someone’s name or their photo.

To remove a label, click on the blue gear icon next to a field. Then, uncheck Show Label. Repeat this process for all of our fields.

Show Label

By default, the Address field will have a Map It link beneath the field content. This link opens the address in Google Maps. To remove it, uncheck Show Map Link in the settings.

Show Map Link

Let’s finally take a look at our view to see how it looks.

Final View

Pretty snappy!

The Single Entry View

What if we want to add more information about an advisor on their own, individual page? Or what if an advisor’s “About Me” is too long to easily fit in the Multiple Entries page? Then we need to use the Single Entry view.

Start by clicking on the blue gear icon next to the Photo field. At the bottom, enable Link to single entry. Do the same thing for the Name field.

Link to single entry

Now both the advisor’s photo and name will link to their single entry page. When a user clicks on their photo or name, they will be taken to a more detailed page – the Single Entry page.

You may also want to limit the number of words shown in the About/Biography field on the Multiple Entries page. For example, their biography may be thousands of words long. To do this, edit the field and type in a number.

Maximum words

Now let’s edit the Single Entry view context itself. Click on the Single Entry tab. The layout is essentially the same. We simply have more space.

  • For Listing Title, select the Name field
  • For Subheading, select the Job Title field
  • For Image, select the Photo field
  • Under Other Fields, add About / Biography
  • Under Footer Left, add Office Address
  • And Under Footer Right, add Email and Phone

Remember to uncheck the Show Label option for all of the fields. If we had more fields, we could add them here too.

Save and preview your view. Click on an advisor’s photo or name and you’ll see their single entry page.

Single Entry View

Everything looks as it should! At the bottom of the entry, you’ll also see an Edit Entry button. If you click on it, you’ll be taken to the Edit Entry page, where you can edit the fields of the entry.

View Settings

Finally, let’s briefly talk about the View Settings panel at the bottom of the View Configuration screen. There are many settings here, but only a few are directly relevant to our current project.

Number of Entries Per Page

Under View Settings, you can choose how many entries will be displayed per page.

Number of Entries

Under Filter and Sort, you can choose how the entries will be displayed. By default, they will be displayed in order of their date created (newest to oldest). Let’s change them to be ordered by last name. To do this, select Last under Sort by field.

Sort by Field


That just about covers our guide to building an Academic Advisor directory! Have you built a similar application with GravityView? Let us know!

Creating a database of actors and actresses

Creating a database of actors and actresses

On our blog, we recently featured a case study of one of our users, Adam Cavotta, who is a Senior University Training Specialist at New Mexico State University. NMSU uses GravityView in nearly 10 different ways. In this ongoing blog series, we’ll teach you how to create similar applications for yourself.

Want to read more about using GravityView at universities, schools, and other educational institutions? Check out our guide.


In this post, we’re going to create a database of actors and actresses. Whether you’re a university, local community board, or just a small media company, you’ll find this guide useful!

Here’s what our application will look like:

Final Product - Actor Databa

…and here’s what it will do:

  • Allow actors and actresses to submit their information to a database + edit / revise it later
  • Allow filmmakers to search the database by personal characteristics, like skills, education, eye color, hair color, acting experience, and more

Tip: Already have a directory file of actors/actresses? Not to worry. Importing it into Gravity Forms and GravityView is super simple with our Import Entries plugin. You can import CSV or TSV files in ten seconds, flat.

Step 1: Create the Form

First, we’ll need to create a submission form. To do this, go to Forms > New Form on your WordPress sidebar.

New Form

Title your form Actor / Actress Submission Form. Note that actors and actresses will submit their information directly through this form.

Form Title

Now we need to add fields to our form. Depending on the specific nature of your database, you will want to add different fields. Some typical choices might be:

  • Name
  • Email
  • Phone
  • Online reel of previous acting work
  • Photograph
  • Representation
  • Physical description, including height, weight, hair color, eye color, etc.
  • Acting experience
  • Education and training
  • Other skills, like surfing, rock climbing, ice skating, etc.

Tip: Want to make sure that all of the fields are filled out? Be sure to enable “Required” at the bottom of each field.

Required Option

Let’s add all of these fields to our form, one by one. To add a field to the form, simply click on it or drag it into the form.

For Name, we can use the Name field, which is under Advanced Fields.

Name

For Email, we can use the Email field, which is also under Advanced Fields.

Email

For Phone, let’s use the Phone field, also under Advanced Fields.

Phone field

For Online Reel, we want to use the Website field, which is under Advanced Fields. You can rename it and add a description, if you like.

Online Acting Reel field

For Photo, we’ll want to use the File Upload field, which is under Advanced Fields. Once you add the field to your form, click on it to edit its settings. Rename it “Photo” and add a description (if you like). Then, type jpg, gif, png, pdf into the Allowed file extensions setting. This will restrict the file types allowed to image files. If you want to allow actors/actresses to upload more than one photo, enable Multi-File Upload. Finally, type in a maximum file size – typically an image shouldn’t be more than 5-10MB.

Photo field

Tip: You can divide your form into separate sections by using the “Section” field.

For Representation, we’ll add a Radio Buttons field, which is under Standard Fields. Edit the field and rename it “Are you represented by an agency or firm?” Make the choices “Yes” and “No”.

Agency field

What if the actor/actress is represented by an agency? Naturally, we’d want to know which one. To do this, we want to use some Conditional Logic.

Start by adding a Single Line Text field. Rename it “Name of Agency / Firm”.

Name of Agency field

Then, click on the Advanced tab. At the bottom, check the box next to Enable Conditional Logic. You’ll see a few settings appear.

We want this field to only appear if the Are you represented by an agency or firm? question is answered with a yes. So, customize the settings to Show this field if All of the following match: “Are you represented by an agency or firm?” is Yes.

Conditional Logic options

Now this field will only appear if the question is answered with a Yes.

For the next field, Union Representation, we want the same basic functionality. Rather than create a form entirely from scratch, let’s just duplicate the two previous fields.

To duplicate a field, press the document button in the top right corner of the field. Duplicate both the Are you represented by an agency or firm? field and the Name of Agency / Firm field and then drag them below. Then, rename them to “Are you a member of a union?” and “Name of Union”. Make sure to change the conditional logic field to Are you a member of a union?

Union field

Now we want to add fields for physical description: height, weight, eye color, and so on. To do this, we’ll add a series of Single Line Text fields.

Single line text field

Radio buttons also make sense here, if you’d rather have users select between ranges or options, rather than a specific number (eye colors, for example).

Eye color field

Tip: To let users write in their own choice, check the Enable “other” choice option.

Enable other choice

Now we want to add a field for Acting Experience. There are a few ways to do this, but probably the easiest is with the Paragraph Text field. This will allow the user to simply write about their work experience. You can also use the List Advanced Field, but it is more complicated to use. (We’ll use it in the next step.)

Acting Experience

Be sure to rename the field and add a description. If you want the description to be above the field, you can change its location on the Appearance tab.

Placement

For the Education and Training field, we have the same dilemma. For this guide, we’ll keep it simple and use another Paragraph Text field.

Education and Training

Finally, under Skills we want to use the List field, which we mentioned previously. Read more about the List field here. This will let actors/actresses add specific skills they may possess.

Drag it from the Advanced Fields panel. Rename it and add a description. Then, click Enable multiple columns and type in “Skill” and “Proficiency.”

Skills

That should just about cover all of the fields we want! Click Update in the bottom right corner to save your form.

Now, we need to add the form to a WordPress page. To do this, create a new page and click on the Add Form button.

Add Form

Publish your page and then view it.

Form

Everything looks good! Now let’s move on to the next step: Creating a View.

Step 2: Creating the View

Note: For this part, we’ll assume that you already have a number of submissions to your actor / actress database.

Now that we have a form for submitting new actors and actresses to our database, let’s create a View for it. This will allow us to view, search, edit, and filter through all of our submissions.

To create a new View, go to Views > New View on your WordPress sidebar.

New View

Name your View “Actor / Actress Database.” Then select the form Actor / Actress Submission Form as our Data Source.

Data Source

You’ll now need to choose a View type. There are two basic View types – Table layout, which displays the entries in a text table, and List layout, which displays them in a series listings. For our purposes, we’ll use the List layout.

Now we’re on the View Configuration page. Here, we can customize how the View will look. Let’s start by adding some widgets to the top. For our actor/actress database, we definitely want to add a Search Bar.

If we want, we can add pagination information (Show Pagination Info) and page links (Page Links.) We can also add some custom content, like a description of this database’s purpose. For now, let’s just add a Search Bar.

Widgets

To edit a widget, click on the blue gear icon next to it. You can customize the various options of each widget. For example, the Search widget lets you create separate search bars for each field, if you so desire.

Now, let’s configure the entries themselves. Since we are using the Listing layout, we have a number of field locations. To add a field, simply click + Add Field.

  • For Listing Title, choose the Name field. After you’ve added the field, click on the blue gear icon and click Link to single entry. This will add a link to the name field that links to the detailed (single entry) page of the actor/actress

Link to Single Entry

  • We’ll leave the Subheading field blank
  • For Image choose the Photo field
  • For Other Fields, add a few of the most important fields. We’ll add Acting Experience, Education and Training, and Skills
  • In the footer, we’ll add Email, Phone, and Online Acting Real

Multiple Entries

Tip: hiding the label (“Photo”, “Name”, etc.) often makes the View look better. To hide a label, click the blue gear icon to edit the field’s settings and uncheck Show Label.

Note that you can customize the CSS of all fields. Read this guide for more about using CSS in GravityView. For example, to make all the field labels bold, add this CSS code to your theme’s style.css file:

.gv-field-label {font-weight: bold;}

Now let’s see how it looks!

Final Product

Looking good! If you scroll down, you will see more of your entries. Now, let’s customize the Single Entry layout. To do this, click on the Single Entry tab.

Single Entry View

This page will display all of the information about our actor/actress. Let’s add all of our fields.

By default, empty fields will be hidden. Ergo, if an actor/actress didn’t answer yes to Are you a member of a union?, the “Union Name” field will not be displayed at all.

Here’s what our final product looks like:

Single Entry

Pretty spiffy!

View Settings

Finally, let’s talk about the View Settings panel at the bottom of the page. There are a few specific settings that are relevant for our actor/actress database.

Settings

  • Under View Settings, we can customize the number of entries per page.
  • If you want actors/actresses to be able to modify or delete their own data, enable “Allow User Edit” and “Allow User Delete”
  • Want to hide all actors/actresses until a search is made? Enable Hide View data until a search is performed.

…and that about covers it! You actor/actress database is now ready to rock and roll.


Ready to sign up?

  • Will renew yearly until cancelled.

  • Will renew yearly until cancelled.

  • Will renew yearly until cancelled.

Purchase