https://legacy.forums.gravityhelp.com/topic/update-a-hidden-field-from-post_submission-hook Gravity Support Forums Topic: Update A Hidden Field From Post_Submission Hook en-US Sun, 19 Apr 2026 12:06:30 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/update-a-hidden-field-from-post_submission-hook#post-3140 Thu, 04 Feb 2010 11:33:08 +0000 Alex Cancado 3140@https://legacy.forums.gravityhelp.com/ <p>Given your scenario, I am not sure there is any other way to do this. You will have to update the tables directly. There is a little error on your sql statement, try the following and it should work:</p> <p><code>$wpdb-&gt;query(&quot;UPDATE wp_rg_lead_detail SET value = &#39;New Value&#39; WHERE lead_id = 30 AND field_number = 81&quot;);</code></p> <p>As for the credit card number, I wouldn't even store it at your side at all. I would truncate them to the last for on the post_submission_hook instead of doing it after you receive the confirmation from paypal. </p> <p>Good Luck!<br /> Alex. </p> https://legacy.forums.gravityhelp.com/topic/update-a-hidden-field-from-post_submission-hook#post-3138 Thu, 04 Feb 2010 09:23:20 +0000 AtlantaWebDesignGA 3138@https://legacy.forums.gravityhelp.com/ <p>Good question. I'm using the form to collect customer info including credit card billing that is sent to Authorize.net for payment processing. When the processing transaction result is returned by them via XML message, they send back the customer's ID they generated. I'm writing the new customer ID back into the Gravity Forms database. I also need to write the payment status (OK, declined) back into GF plus I want to overwrite the customer's credit card # in the GF form database so only the last 4 digits remain. (I'll let Authorize store that risky info so I don't have to implement lots of security on my end.) </p> <p>Given that workflow what do you recommend? </p> https://legacy.forums.gravityhelp.com/topic/update-a-hidden-field-from-post_submission-hook#post-3135 Wed, 03 Feb 2010 22:00:08 +0000 Carl Hancock 3135@https://legacy.forums.gravityhelp.com/ <p>Out of curiosity and before we can come up with a good solution for this, is there any reason why you are generating the ID *afteR* the post is submitted rather than during the submission process itself? </p> https://legacy.forums.gravityhelp.com/topic/update-a-hidden-field-from-post_submission-hook#post-3129 Wed, 03 Feb 2010 18:29:40 +0000 AtlantaWebDesignGA 3129@https://legacy.forums.gravityhelp.com/ <p>Need to update a hidden field in a form with an ID number after the form has just been submitted. The ID is calculated by PHP running in a gform_post_submission hook within the theme's functions.php file.</p> <p>I thought about writing directly into the GF database like this:</p> <p>$wpdb-&gt;query("UPDATE $wpdb-&gt;wp_rg_lead_detail SET value = 'New Value' WHERE lead_id = 30 AND field_number = 81");</p> <p>However, that doesn't seem to update. No error given, just no update happens.</p> <p>Is there a smarter way to do this by calling a function already in the Gravity Forms library? </p>