Unique reference number for submissions

We want unique id numbers to be generated upon form submission. These need to be 10 digit including 3 digit prefix. I found http://www.gravityhelp.com/forums/topic/guid-entry-id and http://pastie.org/1398955 which works perfect apart from generating random numbers. We want numbers to be generated in incremental order rather than random numbers. I am not familiar with php, so can you please help.

I am probably overlooking something obvious, but I've been forum-diving for an hour now and haven't found what I'm looking for... Carl, you reference (here and elsewhere) that we should "query the existing entry data to get the last value that is present and then increment it." I understand what we're trying to do, but I can't for the life of me figure out how to execute that query. How would I query for the most recent entry for a given form, in order to e.g. have the above GUIDs be incremented within different ranges for a specific form?

i would love to self-code this. anyone could point us somewhere?

i made an updated code for generating Incremental ID generation

[php]
<?php
add_filter("gform_pre_render", "process_unique");
function process_unique($form) {
global $uuid;
$uuid['form_id'] = $form['id'];

switch($form['id']) {
case 6: //form ID
$uuid['field_id'] = 60; //field ID on the form
break;
case 14: //form ID
$uuid['field_id'] = 158; //field ID on the form
break;
case 12: //form ID
$uuid['field_id'] = 158; //field ID on the form
break;
case 11: //form ID
$uuid['field_id'] = 34; //field ID on the form
break;

}

add_filter("gform_field_value_uuid", "get_unique");
return $form;
}

function get_unique(){
global $uuid;
$form_id = $uuid['form_id'];
$field_id = $uuid['field_id'];

switch($form['id']) {
case 6:
$prefix = "FOHSRF # - "; //prefix for different forms
break;
case 14:
$prefix = "VSRF # - "; //prefix for different forms
break;
case 12:
$prefix = "VSRF # - "; //prefix for different forms
break;
case 11:
$prefix = "VSDEIF # - "; //prefix for different forms
break;
}

do {
$formid = $form_id; //get ID of the form
$form_count = RGFormsModel::get_form_counts($formid);
$unique = $form_count['total'] + 1; // count of the lead form entries incremented by one
$unique = str_pad($unique, 3, '0', STR_PAD_LEFT); // padding for number format 001,002...015 so 3 digit number format
$unique = $prefix . $unique; // prefix and the unique number
} while (!check_unique($unique, $form_id, $field_id));

return $unique;
}

function check_unique($unique, $form_id, $field_id) {
global $wpdb;

$table = $wpdb->prefix . 'rg_lead_detail';
$result = $wpdb->get_var("SELECT value FROM $table WHERE form_id = '$form_id' AND field_number = '$field_id' AND value = '$unique'");

if(empty($result))
return true;

return false;
}
?>

Hi!
I am testing this code and have it ALMOST working.
It's not generating the prefix.
I am using the exact code (other than changing form and field ID's) for 2 forms.
I am using uuid as the Parameter Name.
What am I missing?
Thanks and cheers,
Gil

Hi Chris,
Thanks :-)
I did look at it and that would work great for a single form but I have to do 3 different ones with different prefixes which is why I thought the code above looked promising.
He never mentioned if he only used uuid for the parameter or added something to that for the prefix.
Sooooooooo close LOL
Cheers,
Gil

Hi Chris,

Nope. I'm stuck. Mind you, I have had a plethora of other things to do as well.
Will leave you a question at the post you pointed me to. Oh wait! I cant ... it's closed.
Question is - as you know I need multiple prefixes.
If i added a second filter - same code but changed the value to uuid2 and then changed the prefix, would that work? (gform_field_value_uuid2)
THANKS and cheers,
Gil

Hi Chris,
Indeed ... one prefix (which becomes part of a unique PO#) for each form.
Order Form 1 - PayPal sales) prefix PP-#####
Order From 2 - COD sales) prefix COD-#####
etc
I thought that if I used the code you show here - http://www.gravityhelp.com/forums/topic/send-confirmation-number#post-145386 - and used uuid as the parameter for form 1 and uuid2 as the parameter for form 2 that would get me there?
Cheers,
Gil

Hi Gil,

Sorry took long to respond

here is the full code i had and its working.

the problem is need to do the switch code inside the do while loop

add_filter("gform_pre_render", "process_unique");
function process_unique($form) {
    global $uuid;
    $uuid['form_id'] = $form['id'];

	switch($form['id']) {
	case 6:							//form ID
        $uuid['field_id'] = 60;		//field ID on the form
        break;
	case 14:						//form ID
        $uuid['field_id'] = 158;	//field ID on the form
        break;
	case 12:						//form ID
        $uuid['field_id'] = 158;	//field ID on the form
        break;
    case 11:						//form ID
        $uuid['field_id'] = 34;		//field ID on the form
        break;

    case 13:						//form ID
        $uuid['field_id'] = 28;		//field ID on the form
        break;

	case 16:						//form ID
        $uuid['field_id'] = 2;		//field ID on the form
        break;

    case 10:						//form ID
        $uuid['field_id'] = 49;		//field ID on the form
        break;
    case 4:						//form ID
        $uuid['field_id'] = 30;		//field ID on the form
        break;

    case 1:						//form ID
        $uuid['field_id'] = 34;		//field ID on the form
        break;
	case 5:						//form ID
        $uuid['field_id'] = 49;		//field ID on the form
        break;
	case 7:						//form ID
        $uuid['field_id'] = 60;		//field ID on the form
        break;
	case 8:						//form ID
        $uuid['field_id'] = 33;		//field ID on the form
        break;
	case 3:						//form ID
        $uuid['field_id'] = 29;		//field ID on the form
        break;
	case 2:						//form ID
        $uuid['field_id'] = 5;		//field ID on the form
		print_r('aaa');
        break;

    }

    add_filter("gform_field_value_uuid", "get_unique");
    return $form;
}

function get_unique(){
    global $uuid;

	$form_id = $uuid['form_id'];
    $field_id = $uuid['field_id'];

	global $wpdb;

    do {
		$formid = $form_id; //get ID of the form

		    switch($form_id) {

			case 6:
				$prefixs = "FOHSRF # - ";	//prefixs for different forms
				break;
			case 14:
				$prefixs = "VSRF # - ";		//prefixs for different forms
				break;
			case 12:
				$prefixs = "VSRF # - ";		//prefixs for different forms
				break;
			case 11:
				$prefixs = "VSDEIF # - ";	//prefixs for different forms
				//print_r($prefixs);
				break;
			case 13:
				$prefixs = "FOHSRLR # - ";	//prefixs for different forms
				break;
			case 10:
				$prefixs = "SMRF # - ";	//prefixs for different forms
				break;
			case 4:
				$prefixs = "VTTCF # - ";	//prefixs for different forms
				break;
			case 1:
				$prefixs = "EHF # - ";	//prefixs for different forms
				break;
			case 5:
				$prefixs = "ELA # - ";	//prefixs for different forms
				break;
			case 7:
				$prefixs = "IRF # - ";	//prefixs for different forms
				break;
			case 8:
				$prefixs = "SIF # - ";	//prefixs for different forms
				break;
			case 3:
				$prefixs = "RIF # - ";	//prefixs for different forms
				break;

			case 16:
				$prefixs = "GHIRA # - ";	//prefixs for different forms

				break;
			case 2:
				$prefixs = "CSF wewwe# - ";	//prefix for different forms
				break;

			}
		$tables = $wpdb->prefix . 'rg_lead';
		$form_count = $wpdb->get_var("SELECT COUNT(*) FROM $tables WHERE form_id = '$formid'");
		//$date = date("d/m/Y");
		//$form_count = RGFormsModel::get_form_counts($formid);

        $unique = $form_count + 1; // count of the lead form entries incremented by one
		$unique = str_pad($unique, 3, '0', STR_PAD_LEFT); // padding for number format 001,002...015 so 3 digit number format
		$date = date('m-d-Y');

		//print_r($date);
        $unique = $prefixs . $unique . ' - ' . $date; // prefixs and the unique number	//	

    } while (!check_unique($unique, $form_id, $field_id));
	//print_r($unique);
    return $unique;
}

function check_unique($unique, $form_id, $field_id) {
    global $wpdb;

    $table = $wpdb->prefix . 'rg_lead_detail';
    $result = $wpdb->get_var("SELECT value FROM $table WHERE form_id = '$form_id' AND field_number = '$field_id' AND value = '$unique'");

    if(empty($result))
        return true;

    return false;
}

Hi drawonline.

This works perfectly!
Thank YOU!!!!!

Gil