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 CiviReport (Moderator: Dave Greenberg) »
  • Report for the last users entered in Civi (contact created field)
Pages: [1]

Author Topic: Report for the last users entered in Civi (contact created field)  (Read 376 times)

FW

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.73
  • PHP version: 5.3.3
Report for the last users entered in Civi (contact created field)
April 03, 2014, 01:17:04 am
Hi, I can't find a solution to this. Can someone get me on the right track?

The plan is to have a report, that we can show on the civi dashboard, which displays the most recent users who have signed up for our newsletter (these get automatically entered into the system with Webform CiviCRM Integration via Drupal). For this we would need a "contact created" field, but I can't find one as an option. Is there such a field, or how do others display contacts that have just recently been added to civi?

The ideas is, once we have this report on the dashboard our admin has a quick access to new contacts and can filter out potential spam right there.

The other plan is to have a report with all other contacts (minus newsletter) that have recently been added to Civi. For us that are mainly manually entered contacts by staff. For this we also would need a "contact created" field, I assume.

Thanks for any advice and maybe tips on how you have accomplished this.

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: Report for the last users entered in Civi (contact created field)
April 03, 2014, 09:28:40 am

There is a created_date field in the civicrm_contact table

You can use that field to create your report. If you do so, please share it as an extension so others can use it also

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

FW

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.73
  • PHP version: 5.3.3
Re: Report for the last users entered in Civi (contact created field)
April 04, 2014, 09:38:38 am
Thanks Lobo. Will do.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Report for the last users entered in Civi (contact created field)

This forum was archived on 2017-11-26.