Gravity Support Forums User Favorites: kadamwhite

Gravity Support Forums User Favorites: kadamwhite kadamwhite Gravity Support Forums User Favorites: kadamwhite en-US Mon, 20 Apr 2026 06:33:16 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php Gil Namur on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-152375 Fri, 22 Feb 2013 12:09:22 +0000 Gil Namur 152375@https://legacy.forums.gravityhelp.com/ Hi drawonline. This works perfectly! Thank YOU!!!!! Gil Gil Namur on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-151741 Thu, 21 Feb 2013 15:26:06 +0000 Gil Namur 151741@https://legacy.forums.gravityhelp.com/ Hi drawonline :-) THANKS! I will try this today. Just to be clear on the cases. If I only have 2 cases, do I need the print_r('aaa'); statement before the last break? Like this below. case 1: //form ID $uuid['field_id'] = 8; //field ID on the form break; case 2: //form ID $uuid['field_id'] = 8; //field ID on the form print_r('aaa'); break; Thanks and cheers, Gil drawonline on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-151432 Thu, 21 Feb 2013 07:15:22 +0000 drawonline 151432@https://legacy.forums.gravityhelp.com/ 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 <pre><code>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; }</code></pre> Gil Namur on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-150328 Tue, 19 Feb 2013 14:10:19 +0000 Gil Namur 150328@https://legacy.forums.gravityhelp.com/ Hi Chris, I DID try that code. Exactly as you have it there. ( I referred to it as the last bit of code). It returns a prefix, but no number. I just tried it again. Same result. I am assuming that all I need to enter in the hidden field for Parameter Name is uuid - correct? Cheers, Gil Chris Hajer on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-150305 Tue, 19 Feb 2013 13:30:34 +0000 Chris Hajer 150305@https://legacy.forums.gravityhelp.com/ Gil, I revised the code a little bit later in that topic: <a href="http://www.gravityhelp.com/forums/topic/send-confirmation-number#post-145509" rel="nofollow">http://www.gravityhelp.com/forums/topic/send-confirmation-number#post-145509</a> The $prefix was not working correctly, so I hard coded it. Please try this code. Gil Namur on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-150267 Tue, 19 Feb 2013 12:59:53 +0000 Gil Namur 150267@https://legacy.forums.gravityhelp.com/ Hi Chris, Further to my note yesterday - using the code you have at - <a href="http://www.gravityhelp.com/forums/topic/send-confirmation-number#post-145386" rel="nofollow">http://www.gravityhelp.com/forums/topic/send-confirmation-number#post-145386</a> If I use your fist example, it faithfully returns a number, but no prefix. If I use the last bit of code in that thread, it returns the prefix, but no number. Just doing this on one form, using your exact code. Cheers, Gil Gil Namur on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-149415 Mon, 18 Feb 2013 14:05:56 +0000 Gil Namur 149415@https://legacy.forums.gravityhelp.com/ 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 - <a href="http://www.gravityhelp.com/forums/topic/send-confirmation-number#post-145386" rel="nofollow">http://www.gravityhelp.com/forums/topic/send-confirmation-number#post-145386</a> - and used uuid as the parameter for form 1 and uuid2 as the parameter for form 2 that would get me there? Cheers, Gil Chris Hajer on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-149385 Mon, 18 Feb 2013 13:26:25 +0000 Chris Hajer 149385@https://legacy.forums.gravityhelp.com/ That approach would populate a different parameter in the same form, the parameter names uuid2. Is that what you want, or do you want a one prefix tied to one form, and each prefix will be different (one prefix for each form)? Gil Namur on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-149370 Mon, 18 Feb 2013 12:49:47 +0000 Gil Namur 149370@https://legacy.forums.gravityhelp.com/ 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 Chris Hajer on "Unique reference number for submissions" https://legacy.forums.gravityhelp.com/topic/unique-reference-number-for-submissions#post-148206 Sun, 17 Feb 2013 01:58:17 +0000 Chris Hajer 148206@https://legacy.forums.gravityhelp.com/ Did you make any more progress with this Gil?