How to perform Gravity Forms time calculations in GravityView

Video Transcript:

We're going to be adding a duration field to Gravity Forms and then calculating averages and fastest and slowest times using GravityView and the Math by GravityView plugin to get started, I'm going to add a single line, text, field, click to expand it, check the input mask button.

And this is key for the Math by GravityView plugin: selecting the mask type to be either minutes or hours duration.

I'm going to select minutes for this example. I'm going to name the field duration. I'm going to save the form and then to display the form entries.

I'm going to create a View based on this, and I'll call it "Duration Times". I'm feeling creative today, apparently! Now, in order to display the field, I'm going to add it to the View and I'm going to select the field options and going to check the add field calculations to the table footer setting.

This is added by the Math by GravityView plugin. So when I check that, you'll see, I have the option to format the results in the way that I want.

And I'm going to leave this default value for now and we'll come back here. I'm going to publish the View and now all we need is some entries.

I'm going to click, to preview the form and let's add a few entries, 10 minutes. Let's add 15 minutes.

Let's add how about 30 seconds? So 10 minutes, 15 minutes, 30 seconds. And let's do 15 minutes and 30 seconds.

All right. Let's take a look again at the View. Okay. I'm going to uncheck approved entries only, so I don't need to improve the entries and let's take a look on the website.

Let's see what it looks like. So you can see the duration times here that we just entered. And the total of those times is here.

As we expected. Now, I'm going to change the field settings to not show the total, but let's instead show the average speed.

And instead of just showing the value, let's also say, let's set a label that's different than what the default is, which is just the value.

Let's set an, a label that says "Average speed: {result}". And instead of showing the numbers in English, let's show them as values, just pure numbers.

Let's see how that goes. I'm going to save the View, go back over, refresh the screen, and we can see "Average speed:".

That's the label that we set up? 10 minutes and 15 seconds.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.