https://legacy.forums.gravityhelp.com/topic/rg_lead_detail-table-uniques Gravity Support Forums Topic: RG_LEAD_DETAIL table uniques en-US Sun, 19 Apr 2026 18:38:23 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/rg_lead_detail-table-uniques#post-149455 Mon, 18 Feb 2013 14:52:42 +0000 octoberblue 149455@https://legacy.forums.gravityhelp.com/ <p>Yup, thanks. </p> https://legacy.forums.gravityhelp.com/topic/rg_lead_detail-table-uniques#post-149448 Mon, 18 Feb 2013 14:38:38 +0000 Chris Hajer 149448@https://legacy.forums.gravityhelp.com/ <p>Just to be sure I follow along, with this question:</p> <blockquote><p> Perhaps you have an idea, or perhaps you could show me where the code exists to update the exisiting form from the admin area. </p></blockquote> <p>Do you mean the code to update an existing <em>entry</em> in the admin? If so, you can look at forms_model.php around line 798 for the function save_lead:</p> <pre><code>[php] public static function save_lead($form, &amp;$lead){</code></pre> <p>That might give you some clues. </p> https://legacy.forums.gravityhelp.com/topic/rg_lead_detail-table-uniques#post-149437 Mon, 18 Feb 2013 14:29:09 +0000 octoberblue 149437@https://legacy.forums.gravityhelp.com/ <p>I've created an form that updates enteries of another form. I hook into the submission, and custom process it, updating the database with a query like such: <a href="http://pastebin.com/cnp8P5HA" rel="nofollow">http://pastebin.com/cnp8P5HA</a></p> <p>The problem is, with this query, if the original form did not create a new row (for instance if the field was empty), then this data is not updated (because it doesn't exisit to be update.)</p> <p>So I'm trying to come up with an elegant solution. I was thinking ON DUPLICATE KEY UPDATE might work, but the current database structure doesn't seem (in my limited sql experience) to jive with it as I need knowledge of the primary_key.</p> <p>Perhaps you have an idea, or perhaps you could show me where the code exists to update the exisiting form from the admin area. </p> https://legacy.forums.gravityhelp.com/topic/rg_lead_detail-table-uniques#post-149426 Mon, 18 Feb 2013 14:15:41 +0000 Chris Hajer 149426@https://legacy.forums.gravityhelp.com/ <p>There is no API really. The best documentation for the plugin is the plugin files themselves. If you can explain your use case, maybe we can come up with more ideas for you. </p> https://legacy.forums.gravityhelp.com/topic/rg_lead_detail-table-uniques#post-149421 Mon, 18 Feb 2013 14:08:49 +0000 octoberblue 149421@https://legacy.forums.gravityhelp.com/ <p>Perfect. By the way, does gravity forms provide an API to update a set of these rows? (I'm trying to figure out how to update a set of these values and if it doesn't exist, create a new row.)</p> <p>...happy to just have you answer, "we don't support that." Thanks for the help regarding my orginal question! </p> https://legacy.forums.gravityhelp.com/topic/rg_lead_detail-table-uniques#post-149417 Mon, 18 Feb 2013 14:06:17 +0000 Chris Hajer 149417@https://legacy.forums.gravityhelp.com/ <p>Yes, combined, those three fields can form a unique key. For one form and one lead, there can only be one value stored for a field_number. </p> https://legacy.forums.gravityhelp.com/topic/rg_lead_detail-table-uniques#post-149310 Mon, 18 Feb 2013 11:17:06 +0000 octoberblue 149310@https://legacy.forums.gravityhelp.com/ <p>In the wp_rg_lead_detail table, taken together are the three columns "lead_id", "form_id", and "field_number" always unique? </p>