Creating a Custom WordPress Dashboard to Display Gravity Form Results

Displaying key metrics directly on the WordPress admin dashboard is an excellent way to provide users with valuable insights. This article walks you through creating a custom dashboard widget that shows the number of entries in a Gravity Form based on specific criteria, using a practical and dynamic approach.

Objective

We aim to create a WordPress dashboard widget that:

• Displays the number of entries in a Gravity Form.
• Shows the date of the most recent entry.
• Provides a button to download the form results.

Advantages of This Approach

• Dynamic Insights: The widget provides real-time metrics for administrators
• Streamlined Workflow: The download button offers a quick way to access detailed form results
• Scalable Design: You can easily adapt the widget for other forms or criteria by changing the variables

How to Set It Up

Copy and paste the following code into your mu-plugin or function file:

<?php
/*
*	Add Custom Dashboard to count GF entries
*	We use GravityExport Lite to generate export link 
*/

$form_id = 1;
$field_id = 6;
$field_value = 'yes';
$link = '[your_gravityexport_link]';

if (!defined('ABSPATH')) {
	exit; // Exit if accessed directly
}

add_action('wp_dashboard_setup', function() use ($form_id, $field_id, $field_value, $link) {
	wp_add_dashboard_widget(
		'dashboard_reservations_widget',
		'Réservations Longue Durée',
		function() use ($form_id, $field_id, $field_value, $link) {
				render_dashboard_reservations_widget($form_id, $field_id, $field_value, $link);
		}
	);
});

function render_dashboard_reservations_widget($form_id, $field_id, $field_value, $link) {
  global $wpdb;
	$entries = $wpdb->get_results($wpdb->prepare(
		"SELECT e.id, e.date_created 
		 FROM {$wpdb->prefix}gf_entry AS e
		 INNER JOIN {$wpdb->prefix}gf_entry_meta AS em
		 ON e.id = em.entry_id
		 WHERE e.form_id = %d 
		 AND em.meta_key = %s 
		 AND em.meta_value = %s
		 AND e.status = 'active'
		 ORDER BY e.date_created DESC",
		$form_id,
		$field_id,
		$field_value
	));
	$count = count($entries);
	$last_entry_date = $count > 0 ? date('d.m.Y', strtotime($entries[0]->date_created)) : 'Aucune entrée';
	
	echo '<div style="padding: 0 10px;">
	<p><strong>Nombre de réservations :</strong> ' . esc_html($count) . '</p>
	<p><strong>Dernière entrée :</strong> ' . esc_html($last_entry_date) . '</p>
	<a href="'.$link.'" class="button button-primary">Télécharger</a>
	</div>';
}

add_action('admin_head', 'custom_dashboard_widget_style');
function custom_dashboard_widget_style() {
	echo '<style>
	#dashboard_reservations_widget .button-primary {
		background: #007cba;
		color: #fff;
		border-color: #006ba1;
		box-shadow: 0 1px 0 #006ba1;
		text-shadow: none;
	}
	#dashboard_reservations_widget .button-primary:hover {
		background: #006ba1;
		border-color: #005b8c;
	}
	</style>';
}
?>

Conclusion

By following these steps, you can create a fully functional and stylish WordPress dashboard widget tailored to display Gravity Form results. This feature improves the usability and efficiency of the admin dashboard, empowering users with valuable insights at a glance. Try implementing this in your next project and see the difference it makes!