CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Time Stamp on Form Submission
Pages: [1]

Author Topic: Time Stamp on Form Submission  (Read 1608 times)

Shai

  • I post frequently
  • ***
  • Posts: 202
  • Karma: 8
    • Content2zero
  • CiviCRM version: 4.3.x, 4.4.x, 4.5.x
  • CMS version: Drupal 7
  • MySQL version: 5.5.x
  • PHP version: 5.3.x, 5.4.x
Time Stamp on Form Submission
December 09, 2009, 10:55:01 am
I have a profile I'm using for an intake form that users fill out and submit.

I'm using Drupal Views to present a list of people who have filled out the form. I'm filtering on a group, since the folks get added to a group as part of filling out the form.

I can't figure out how to get a timestamp on when the person filled out the form, and then be able to present that date/time in the View.

I'd be most appreciative if someone shared what is the best way to achieve that.

Thanks,

Shai
Don't miss out! Sign up now for free expert advice on CiviCRM's new StackExchange help site.

Shai

  • I post frequently
  • ***
  • Posts: 202
  • Karma: 8
    • Content2zero
  • CiviCRM version: 4.3.x, 4.4.x, 4.5.x
  • CMS version: Drupal 7
  • MySQL version: 5.5.x
  • PHP version: 5.3.x, 5.4.x
Re: Time Stamp on Form Submission
December 10, 2009, 08:16:39 am
Any ideas on this?

I'm having people fill out a form and I need the date/time they filled it out available to me in a View.

Any hints on this would be most appreciated.

Thanks,

Shai
Don't miss out! Sign up now for free expert advice on CiviCRM's new StackExchange help site.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Time Stamp on Form Submission
December 10, 2009, 10:38:07 am
I have had a similar need - though in our case I was looking at the possibility of using a field to add a Note as this would take care of the timestamping. Not sure if I have put that idea on the forum so keen to have any suggestions.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Time Stamp on Form Submission
December 10, 2009, 03:08:07 pm
Quote from: Shai on December 10, 2009, 08:16:39 am
I'm having people fill out a form and I need the date/time they filled it out available to me in a View.

Possible approach (some assembly required):
- Add a Date type custom field, check the "View Only" checkbox.
- Implement a postProcess hook on your profile which writes the current date / time to that field for the contact
Protect your investment in CiviCRM by  becoming a Member!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Time Stamp on Form Submission
December 10, 2009, 05:49:12 pm

you might want to check and see if mysql can default the date value to "now" (i kinda remember reading about this)

if no, you can create the custom field as dave recommends and then let mysql do the work :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Time Stamp on Form Submission

This forum was archived on 2017-11-26.