Gravity Forms create Unique ID

1 Views

on my wordpress site I installed Gravity Forms. To have the form create an ID I placed this code in the child theme: 

add_filter("gform_field_value_uuid", "get_unique");

function get_unique(){

$prefix = "VFI"; // update the prefix here

do {
    $unique = mt_rand();
    $unique = substr($unique, 0, 8);
    $unique = $prefix . $unique;
} while (!check_unique($unique));

return $unique;
}

function check_unique($unique) {
global $wpdb;

$table = $wpdb->prefix . 'rg_lead_detail';
$form_id = 1; // update to the form ID your unique id field belongs to
$field_id = 93; // update to the field ID your unique id is being prepopulated in
$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;
}

This code is working and it’s not giving me much trouble. Since I pass all the info from gravity forms to mailchimp, I noticed on my Mailchiimp list that some of the Unique ID (eg: VFI819231) are replcated.

Read More

Before questioning its functionality, is there anything on this code that can cause this? Cause I’m doing some test, so creating an user then deleting it, then adding it again so I wonder if it’s because this.

Thanks for helping!

Post Views: 1

Related posts

2 comments

  1. This code should work. GP Unique ID, a Gravity Forms plugin I wrote to handle generating unique IDs of all kinds, handles this in a similar way. The one thing to look out for is deleting entries. Since the check_unique() function is pinging the entries database to make sure the generated id is unique, deleting entries would allow for duplicate IDs to be generated.

    1. Add this code to your functions.php file.

    2. Create your form and add a hidden field and allow it to be populated dynamically (advanced tab).

    3. Type “uuid” in the parameter name text field.

      add_filter("gform_field_value_uuid", "uuid");      
function uuid($prefix = '') {
    $chars = md5(uniqid(mt_rand(), true));
    $uuid  = substr($chars,0,8) . '-';
    $uuid .= substr($chars,8,4) . '-';
    $uuid .= substr($chars,12,4) . '-';
    $uuid .= substr($chars,16,4) . '-';
    $uuid .= substr($chars,20,12);
    return $prefix . $uuid;
}

Comments are closed.