Support › Meta Box AIO › Linking Two Custom Post Types in select/dropdown field
- This topic has 8 replies, 3 voices, and was last updated 6 months, 2 weeks ago by
Peter.
-
AuthorPosts
-
May 26, 2023 at 2:25 PM #41942
[email protected]
ParticipantHello,
I'm new to Meta Box so forgive my naivity. I'm trying to create a page that allows the user to enter exam details, such as the start time, date, end time, date and exam name. I also want an exam location field to show in a dropdown or select box, that is populated by the contents of another custom post type called Exam locations, which has a custom field called Excam location.
How do I get the dropdown/select field to populate from the exam location custom field in another post type?
May 26, 2023 at 7:43 PM #41946Peter
ModeratorHello,
Meta Box supports a field
postthat helps you select posts from another post type to save as a post meta. Please read more in the documentation https://docs.metabox.io/fields/post/October 2, 2023 at 10:50 PM #43415leebazCDS
Participanthi, the 'post' field is great! Is it possible to then select a saved field from within the post type.
Example:
1st Custom post type: Companies, has Custom Fields for contacts Name, email, Phone of various company contacts.
Customer 1: Nike
Contacts: Bill, Susan, Jimmy, Jane
Customer 2: Adidas
Contacts: Adrian, Khaled2nd Custom post type: Orders, which has custom field dropdown for 'Customer' using from the 'post' select choosing from Customers, then which contact details for that Customer? I want to select A number of the contacts so that I can then display which contacts are relevant for that Order.
Hope that makes sense!
Thanks!October 3, 2023 at 6:44 PM #43419ModeratorHello Lee,
In the frontend, you can create custom code to show which Customer is associated with the contact and show which Order has that customer field value. There should be 2 nested loops in this case.
October 3, 2023 at 7:51 PM #43420ParticipantHi Peter,
Thanks! My query isn't regarding the front-end output, but rather when inputing data into the custom fields. I used Customer and Order as examples, but I'll refer to my exact use case so as to be more clear:
We install MET masts for weather monitoring. So I have a custom post type 'masts' and custom fields for the mast properties, such as location, height, data of installation etc.
We have various customers and each customer may have one or more contact for a particular mast. So I have a custom post type 'Customer' and custom fields for the customer including the various contacts.
When creating a mast I populate the 'Customer' field using the 'post' field type.
Then for the customer contacts, I want to make a selectable list of the contacts particular to the selected customer.
Is that possible within the field builder plug in, or would I need a custom function elsewhere?
October 4, 2023 at 9:33 PM #43422ModeratorHello,
It isn't possible with the builder. You can follow the documentation below to create a custom field type (select field) for the "selectable list of the contacts particular to the selected customer".
https://docs.metabox.io/creating-new-field-types/October 5, 2023 at 11:42 PM #43437ParticipantThanks! I'm trying to register my own field type class to see if I can get this to work.
I have a file called customer-field-type.php in my /inc/ folder.I have put the following into functions.php:
add_action( 'init', 'prefix_load_phone_type' ); function prefix_load_phone_type() { $meta_boxes_extend= get_template_directory() . '/inc/customer-field-type.php'; if ( is_readable( $meta_boxes_extend ) ) { require $meta_boxes_extend; } }In my customer-field-type.php file is the code taken from your example page:
class RWMB_Phone_Field extends RWMB_Field { public static function html( $meta, $field ) { return sprintf( '<input type="text" name="%s" id="%s" class="rwmb-phone" value="%s" pattern="\d{3}-\d{3}-\d{4}">', $field['field_name'], $field['id'], $meta ); } }however, when I go to make a new field in the builder I can't find this new field in the list.
What am I doing wrong?October 6, 2023 at 3:56 PM #43442ParticipantThis is my attempt to create a select field from custom post type, custom field, but it's not appearing in the builder yet...
Same file structure as my previous post:
<?php add_filter( 'rwmb_field_types', 'register_custom_field_type' ); function register_custom_field_type( $types ) { $types['select_from_sw_customers'] = 'SW_Customers_Select_Field'; return $types; } class SW_Customers_Select_Field extends RWMB_Field { public static function html( $meta, $field ) { // Args for the WP_Query $args = array( 'post_type' => 'sw_customers', 'posts_per_page' => -1, 'post_status' => 'publish' ); $query = new WP_Query( $args ); $options = ""; if ( $query->have_posts() ) { while ( $query->have_posts() ) { $query->the_post(); // Get the custom field value from sw_customers $groups = get_post_meta( get_the_ID(), 'contact_details', true ); foreach ( $groups as $group ) { $customer_name = $group[ 'name' ] ?? ''; } if ( ! empty( $customer_name ) ) { $selected = selected( $meta, get_the_ID(), false ); $options .= "<option value='" . esc_attr( get_the_ID() ) . "' {$selected}>" . esc_html( $customer_name ) . "</option>"; } } wp_reset_postdata(); } return sprintf( '<select name="%s" id="%s">%s</select>', $field['field_name'], $field['id'], $options ); } }October 7, 2023 at 3:33 PM #43450ModeratorHello,
If you want to create a custom field in the builder, please follow the documentation https://docs.metabox.io/extensions/meta-box-builder/#adding-your-own-field-types
Note: we do not support the custom code for your specific needs. We support a customization service with an extra fee. Please contact us here for more information https://metabox.io/contact/
-
AuthorPosts
- You must be logged in to reply to this topic.