Date and Time Stamp « Gravity Support Forums

Gravity Support Forums » General » Pre-Purchase Questions

eteague
Member

Does GF include a date and time stamp of the submitted form to Excel so we would not have to put those fields in the form?

Thanks!

Posted 13 years ago on Tuesday January 11, 2011 | Permalink
Carl Hancock
Administrator

Yes, Gravity Forms includes the timestamp for when the form was submitted. It is an available form field when exporting entries, etc. It is called Entry Date.

Posted 13 years ago on Tuesday January 11, 2011 | Permalink
eteague
Member

Thanks!

I meant to also ask how do we retrieve the Excel file with the form data once its been submitted? Can it be emailed each time a user submits the form?

Posted 13 years ago on Tuesday January 11, 2011 | Permalink
Carl Hancock
Administrator

Gravity Forms doesn't output an Excel file. It outputs a CSV file which Excel can import. The CSV file can only be generated by using the Export Entries tool under Import/Export.

Posted 13 years ago on Tuesday January 11, 2011 | Permalink
eteague
Member

Thanks for your answers Carl. So the CSV cannot be automatically emailed to a particular person as they have to go in an export it right?

Is there some kind of notification event so the domain owner would be alerted that someone submitted form data? Or do they have to keep checking the site to see if a form has been submitted?

Sorry about all the questions but I created a site for the FSU Business School (www.fsusalesinstitute.com) and they want to create some forms with the data being able to display in Excel. Looks like Gravity Forms is the answer but I want to be sure it will meet what they are looking for.

Thanks again!

Posted 13 years ago on Wednesday January 12, 2011 | Permalink
David Smith
Member

So the CSV cannot be automatically emailed to a particular person as they have to go in an export it right?

That is correct.

Is there some kind of notification event so the domain owner would be alerted that someone submitted form data?

Yep, there is full featured notification settings page for your forms. :)

Posted 13 years ago on Wednesday January 12, 2011 | Permalink
katyfb13
Member

It appears as though the entry submitted on time is not accurate. Is it based on UTC by default? Can we adjust it somewhere?

Thanks.

Katy

Posted 13 years ago on Sunday February 6, 2011 | Permalink
mattswan
Member

Was there any update with this?

We're finding the default time stamp for entires to be quite misleading as well. If our Wordpress install knows what time is locally, why doesn't GravityForms?

Posted 12 years ago on Tuesday May 31, 2011 | Permalink
David Smith
Member

Hi Mattswan,

The entry timestamp should be timezone aware. I was unable to recreate your issue on my local install. Would you mind sharing a login to your WP admin so I can take a look?

Posted 12 years ago on Tuesday May 31, 2011 | Permalink
katherholt
Member

I've created a report page for entries using the Directory Add-On for this form:
http://johnscreekcvb.com/home/founders-day-entry-form.html
Note the 'Entry Date & Time' are incorrect based on the settings for Wordpress.
So it looks like the gravity form 'Entry Date' is not showing Local time.

Report Page:
http://johnscreekcvb.com/home/entries-jc-founders-day.html?sort=date_created&dir=DESC&page=1
The 'Entry Date & Time' is 5 hours off.
The 'Entry Date' is only showing a link for 'id' and not the expected date and time.

UTC time is 2011-11-30 21:38:21 Local time is 2011-11-30 16:38:21 (wordpress settings)

Posted 12 years ago on Wednesday November 30, 2011 | Permalink
Carl Hancock
Administrator

How are you populating the entry date and time in the Entry Date & Time field on this form:

http://johnscreekcvb.com/home/founders-day-entry-form.html

I ask because that field has a date that looks like this:

Wed, 30 Nov 11 23:08:55 +0000

I'm not aware of any built in Gravity Forms feature to dynamically populate the field with a date value that looks like that.

I also notice you have a different field on the form, which is the one you are referring to on the directory list page here:

http://johnscreekcvb.com/home/entries-jc-founders-day.html?sort=date_created&dir=DESC&page=1

I am assuming that Entry Date field is a hidden field. How are you populating the value of that field? Or is it not a field and the Directory Add-On is letting you select the built in entry date?

Can you elaborate on the above? I'm not familiar enough with the Directory Add-On to be able to see right away what is going on and how you have things setup.

Posted 12 years ago on Wednesday November 30, 2011 | Permalink
katherholt
Member

I added this filter to the functions.php file for my theme:
======================================
add_filter("gform_field_value_start", "populate_start_time");
function populate_start_time($value){
return date(DATE_RFC822);
}
=====================================
Then added a single line text field. Set the field to be populated dynamically with a parameter name of 'start'.

However, both fields are still using UTC and not Local Time.

Posted 12 years ago on Wednesday November 30, 2011 | Permalink
swimtime
Member

hi. i'm trying to figure out how to include the date and time on submission, as a post field.

i've tried the code above and used the 'start' parameter, but this looks like its the date/time that the user initially comes to the page.

can someone guide me (i'm a little code-phobic) a bit more with how to capture the date/time the form was submitted?

ive been able to include this field on the Entries list page, but why cant i get it to print in the actual entry itself?

thanks a bunch,
miriam

Posted 12 years ago on Tuesday February 7, 2012 | Permalink
Chris Hajer
Key Master

@miriam If you've already purchased Gravity Forms, please start a new topic in the support forums and we'll be happy to help you there.

Posted 12 years ago on Wednesday February 8, 2012 | Permalink

This topic has been resolved and has been closed to new replies.