PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Date and Time Stamp

  1. 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 11 years ago on Tuesday January 11, 2011 | Permalink
  2. 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 11 years ago on Tuesday January 11, 2011 | Permalink
  3. 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 11 years ago on Tuesday January 11, 2011 | Permalink
  4. 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 11 years ago on Tuesday January 11, 2011 | Permalink
  5. 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 11 years ago on Wednesday January 12, 2011 | Permalink
  6. 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 11 years ago on Wednesday January 12, 2011 | Permalink
  7. 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 11 years ago on Sunday February 6, 2011 | Permalink
  8. 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 11 years ago on Tuesday May 31, 2011 | Permalink
  9. 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 11 years ago on Tuesday May 31, 2011 | Permalink
  10. 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 10 years ago on Wednesday November 30, 2011 | Permalink
  11. 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 10 years ago on Wednesday November 30, 2011 | Permalink
  12. 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 10 years ago on Wednesday November 30, 2011 | Permalink
  13. 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 10 years ago on Tuesday February 7, 2012 | Permalink
  14. @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 10 years ago on Wednesday February 8, 2012 | Permalink

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