WordPress DK Forum Topic: Entry data i drop down gravity forms

WordPress DK Forum Topic: Entry data i drop down gravity forms http://wp-danmark.dk/forum/topic/entry-data-i-drop-down-gravity-forms WordPress DK Forum Topic: Entry data i drop down gravity forms da-DK Fri, 17 Jul 2026 17:29:30 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Søg]]> q http://wp-danmark.dk/forum/search.php larslarsen om "Entry data i drop down gravity forms" http://wp-danmark.dk/forum/topic/entry-data-i-drop-down-gravity-forms#post-57673 fre, 30 maj 2014 14:42:30 +0000 larslarsen 57673@http://wp-danmark.dk/forum/ Hej Wp dk! Jeg er i gang med at lave en hjemmeside hvor jeg ønsker en form hvor jeg kan indtaste nogen navne. Derefter i anden form bestående af en dropdown skal disse data automatisk blive tilføjet til. Indtil videre har jeg lavet følgende kode som kan gøre dette. Jeg er dog kommet i det problem at jeg har kaldt den første entry i dropdown for "select a sport" og denne vil jeg ikke have at man skal kunne vælge. Hvis jeg ikke har forklaret mig tydligt nok så er <a href="http://biketrading.dk">her</a> et link til et eksempel. Her er koden: <code> // only run for form 2 add_filter( 'gform_pre_render_2', 'populate_sports_choices'); add_filter( 'gform_pre_submission_filter_2', 'populate_sports_choices'); add_filter( 'gform_admin_pre_render_2', 'populate_sports_choices'); function populate_sports_choices($form){ foreach ( $form['fields'] as &$field ){ // only populate the field if it is a select and has the designated css class name if ( $field['type'] != 'select' || strpos( $field['cssClass'], 'populate-sport' ) === false ) continue; // get form 1 field 4 entry values $sports = get_entry_field_values( 1, 1 ); // create the $choices array and set the placeholder choice $choices = array( array( 'text' => 'Select a Sport', 'value' => '' ) ); // loop through each of the sports and add them to the $choices array foreach ( $sports as $sport ) { $choices[] = array( 'text' => $sport['value'], 'value' => $sport['value'] ); } //replace the field choices with the contents of the $choices array $field['choices'] = $choices; } return $form; } /** * Allows you to retrieve an array of field values. * Requires either the $field object or a field ID and a form ID. * * Example: $values = get_entry_field_values( 5, 113 ); */ function get_entry_field_values( $field_id, $form_id ) { global $wpdb; if ( is_array( $field_id ) ) { $field_id = rgget( 'id', $field_id ); } $tablename = $wpdb->prefix . 'rg_lead_detail'; $sql = "SELECT value FROM $tablename WHERE form_id = %d AND CAST(field_number as unsigned) = %d"; return $wpdb->get_results( $wpdb->prepare( $sql, $form_id, $field_id ), ARRAY_A ); }</code> Jeg fik et forslag om at bruge denne kode: <code> add_filter( 'gform_pre_render', 'populate_sports_choices' ); add_filter( 'gform_pre_validation', 'populate_sports_choices' ); add_filter( 'gform_pre_submission_filter', 'populate_sports_choices' ); add_filter( 'gform_admin_pre_render', 'populate_sports_choices' ); function populate_sports_choices( $form ) { // only run for form 2 if( $form['id'] != 2 ) return $form; foreach ( $form['fields'] as &$field ) { function populate_sports_choices( $form ) { foreach ( $form['fields'] as &$field ) { // only populate the field if it is a select and has the designated css class name if ( $field['type'] != 'select' || strpos( $field['cssClass'], 'populate-sport' ) === false ) continue; // get form 1 field 4 entry values $sports = get_entry_field_values( 4, 1 ); // create the $choices array and set the placeholder choice $choices = array( array( 'text' => 'Select a Sport', 'value' => '' ) ); // loop through each of the sports and add them to the $choices array foreach ( $sports as $sport ) { $choices[] = array( 'text' => $sport['value'], 'value' => $sport['value'] ); } //replace the field choices with the contents of the $choices array $field['choices'] = $choices; } return $form; } /** * Allows you to retrieve an array of field values. * Requires either the $field object or a field ID and a form ID. * * Example: $values = get_entry_field_values( 5, 113 ); */ function get_entry_field_values( $field_id, $form_id ) { global $wpdb; if ( is_array( $field_id ) ) { $field_id = rgget( 'id', $field_id ); } $tablename = $wpdb->prefix . 'rg_lead_detail'; $sql = "SELECT value FROM $tablename WHERE form_id = %d AND CAST(field_number as unsigned) = %d"; return $wpdb->get_results( $wpdb->prepare( $sql, $form_id, $field_id ), ARRAY_A ); }</code> Men den viser desværre en fejl i min functions.php i den aller sidste linje. Håber nogen kan hjælpe mig, i og med jeg ikke er den skarpeste til det her php! Mvh Lars