https://legacy.forums.gravityhelp.com/topic/confirm-reservation-via-confirmation-link-in-email Gravity Support Forums Topic: Confirm reservation via confirmation link in email en-US Sat, 04 Apr 2026 16:20:54 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/confirm-reservation-via-confirmation-link-in-email#post-225816 Fri, 26 Apr 2013 16:22:58 +0000 e-rik 225816@https://legacy.forums.gravityhelp.com/ <p>Hi David,<br /> Thanks for pointing me to the right hook. I've got this working. Here's the code I put in functions.php:<br /> <pre><code>add_action(&quot;gform_pre_submission&quot;, &quot;random_value_in_hidden_field&quot;); function random_value_in_hidden_field($form){ $_POST[&quot;input_3&quot;] = md5(rand(0,time())); }</code></pre> <p>This I put in the notification email:<br /> <code>&lt;a href=&quot;http:/mydomain.com/confirmation-page?usercode={Usercode:3}&quot;&gt;Confirm your registration&lt;/a&gt;</code><br /> And this went in the confirmation page's php template:<br /> <pre><code>&lt;?php if (empty($_GET)){} else { if (empty($_GET[&quot;usercode&quot;])) {} else { $uc = $_GET[&quot;usercode&quot;]; $sql = &quot;SELECT * FROM &lt;code&gt;wp_rg_lead_detail&lt;/code&gt; WHERE &lt;code&gt;value&lt;/code&gt; = &#39;$uc&#39;&quot;; $myrows = $wpdb-&gt;get_row( $sql, ARRAY_A ); if (empty($myrows)) {} else { $lead_id = $myrows[&quot;lead_id&quot;]; $wpdb-&gt;update( &#39;wp_rg_lead_detail&#39;, array(&#39;value&#39; =&gt; 1) , array( &#39;lead_id&#39; =&gt; $lead_id, &#39;field_number&#39; =&gt; 4) ); } } } ?&gt;</code></pre> <p>Now a final cherry on the cake would be a second email to the client to confirm the confirmation of his registration was succesfully processed. Any chance there would be a way to do that with GF? Or should I just send an oldskool email from the same confirmation page by php? </p> https://legacy.forums.gravityhelp.com/topic/confirm-reservation-via-confirmation-link-in-email#post-225357 Fri, 26 Apr 2013 09:14:39 +0000 David Peralty 225357@https://legacy.forums.gravityhelp.com/ <p>You are totally on the right track, and outlining exactly what I was thinking when you asked the question. </p> <p>I would use gform_pre_submission as the hook to create the random key (maybe a md5 hash of two combined field values) and place it in the hidden field.</p> <p>For the second part, you can have a hidden field with a default value of 0. The user would click on the link and go to your specially created Verify page. It would just use a mysql command to search for the key, and if it found it, then update the entry to have a 1 instead of a 0. </p> https://legacy.forums.gravityhelp.com/topic/confirm-reservation-via-confirmation-link-in-email#post-225346 Fri, 26 Apr 2013 09:08:21 +0000 e-rik 225346@https://legacy.forums.gravityhelp.com/ <p>Thanks David. Could you point me in the right directions how to do that?<br /> Here is what I can think of:</p> <p>As for the url for approval: That would require a random and dynamically generated code that is stored in the entry, perhaps in a hidden field. Is there a way to let GF generate a random code? Perhaps by dynamically populating the hidden field via a hook that could be programmed to generate a random string? How and where would I place such a hook?</p> <p>As for updating the entry: I suppose I could add another hidden field 'confirmed' with a default value of 0 (false). How could I alter this field to 1 (true) programmatically from another page outside GF, using the unique string generated in the previous step to identify the right entry? Would this just be a matter of updating the database entry directly via a query or is there a hook for this?</p> <p>tia,<br /> Erik </p> https://legacy.forums.gravityhelp.com/topic/confirm-reservation-via-confirmation-link-in-email#post-225325 Fri, 26 Apr 2013 08:52:55 +0000 David Peralty 225325@https://legacy.forums.gravityhelp.com/ <p>It is possible, but not built-in. You would have to custom code the URL for approvals and the tool to update the entries when they arrive on the site. </p> https://legacy.forums.gravityhelp.com/topic/confirm-reservation-via-confirmation-link-in-email#post-225139 Fri, 26 Apr 2013 06:25:28 +0000 e-rik 225139@https://legacy.forums.gravityhelp.com/ <p>This is the scenario: A form to make reservations for an event. After submitting the form, the client receives an email with a confirmation link. This is to avoid somebody makes an unwanted reservation for somebody else. If the client clicks the confirmation link in his email he is routed to a page where his reservation is confirmed. The entry of this client in the entries table of the form is updated. So in the cms the administrator can see in the entries table which clients confirmed their reservation and which clients didn't.</p> <p>Is this possible with Gravity Forms? </p>