https://legacy.forums.gravityhelp.com/topic/creating-an-admin-form-for-sending-a-message-from-an-entry Gravity Support Forums Topic: Creating an admin form for sending a message from an entry en-US Thu, 23 Apr 2026 13:03:47 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/creating-an-admin-form-for-sending-a-message-from-an-entry#post-48480 Mon, 06 Feb 2012 16:12:34 +0000 amydpnw 48480@https://legacy.forums.gravityhelp.com/ <p>Dana - That helps a lot!! Thank you!!</p> <p>I'll post an update after I get this implemented.</p> <p>- Amy </p> https://legacy.forums.gravityhelp.com/topic/creating-an-admin-form-for-sending-a-message-from-an-entry#post-48479 Mon, 06 Feb 2012 16:09:26 +0000 Dana Cobb 48479@https://legacy.forums.gravityhelp.com/ <p>Hi, amydpnw,</p> <p>Yes, this is possible. You could use the gform_field_value_$parameter_name" hook (<a href="http://www.gravityhelp.com/documentation/page/Gform_field_value_$parameter_name)" rel="nofollow">http://www.gravityhelp.com/documentation/page/Gform_field_value_$parameter_name)</a>. In that hook you can query the database to get the entry ids (lead_ids) for the records which match the time range you specify and populate a drop down with the data. The query would be something similar to:</p> <pre><code>select lead1.lead_id from wp_rg_lead_detail lead1 join wp_rg_lead_detail lead2 on lead1.lead_id = lead2.lead_id and lead1.form_id=lead2.form_id where lead1.form_id=43 and lead1.field_number = 1 and lead1.value &gt;= &#39;2011-01-30&#39; and lead2.field_number=2 and lead2.value &lt;= &#39;2012-02-09&#39;</code></pre> <p>Once you have the matching lead_ids, you can then query the data to get the first name/last name of the users belonging to those entries (lead_ids). You can use something like this:</p> <pre><code>select lead1.lead_id, lead1.value as first_name, lead2.value as last_name from wp_rg_lead_detail lead1 join wp_rg_lead_detail lead2 on lead1.lead_id = lead2.lead_id where lead1.lead_id in (324,325) and (cast(lead1.field_number as decimal) = cast(3.3 as decimal) and cast(lead2.field_number as decimal) = cast(3.6 as decimal))</code></pre> <p>You then use that data to populate the drop down.</p> <p>I hope this points you in the right direction. </p> https://legacy.forums.gravityhelp.com/topic/creating-an-admin-form-for-sending-a-message-from-an-entry#post-47168 Mon, 23 Jan 2012 19:37:32 +0000 amydpnw 47168@https://legacy.forums.gravityhelp.com/ <p>I have a registration form that is allows for a multi day reservation (start to end date) and I would like to create an admin form that will scan the entries for anyone that is registered for the dates and the names from the entries will populate a drop down.</p> <p>First question is, is this even possible with GF (assuming I custom coded it) and of so, any ideas on how others would implement this?</p> <p>The reason I'm looking to GF is that the data is already there so if I can utilize it again, would love it. </p>