Add Select Values from Other Custom Fields

This topic has 14 replies, 3 voices, and was last updated 1 year, 10 months ago by Codog.

Viewing 15 posts - 1 through 15 (of 15 total)

Author

Posts
December 6, 2018 at 8:33 AM #12512

Pete Wlodkowski
Participant

Hi, I have a few custom number fields, created in Advanced Custom Fields and assigned to my custom post type.

I want to populate a Meta Box select field on the same custom post type from these values.

So, I have the following number / text fields, each with a single value, ex: 40

field_1
field_2
field_3
field_4

I want to use these as the value options / select options for my meta box select field.

How might I achieve this?

Add New Note to this Reply

December 6, 2018 at 8:33 AM #12513

Pete Wlodkowski
Participant

By the way, I used the meta box builder to create the select field.

Add New Note to this Reply

December 6, 2018 at 9:43 AM #12514

Pete Wlodkowski
Participant

Here is the PHP to show my custom fields:

<?php the_field( 'w' ); ?>
<?php the_field( 'ru' ); ?>
<?php the_field( 't5s' ); ?>
<?php the_field( 't10q' ); ?>
<?php the_field( 't1516' ); ?>
<?php the_field( 't20' ); ?>
<?php the_field( 't3032' ); ?>
<?php the_field( 't40' ); ?>

This is what I want to populate my select options with.

Add New Note to this Reply

December 6, 2018 at 2:44 PM #12520
Anh Tran
Keymaster
Hi Pete,

The Meta Box Builder doesn't allow you to use dynamic values from other fields at the moment. You need to create the meta box and field by code.

Here is an example:
```
add_filter( 'rwmb_meta_boxes', function( $meta_boxes ) {
    $post_id = null;
    if ( isset( $_GET['post'] ) ) {
        $post_id = intval( $_GET['post'] );
    } elseif ( isset( $_POST['post_ID'] ) ) {
        $post_id = intval( $_POST['post_ID'] );
    }

    $options = array(
        'w' => get_post_meta( $post_id, 'w', true ),
        'ru' => get_post_meta( $post_id, 'ru', true ),
        // and so on.
    );

    $meta_boxes[] = [
        'title' => 'Your title',
        'fields' => [
            [
                'type' => 'select',
                'id' => 's',
                'name' => 'Select',
                'options' => $options,
            ],
        ],
    ];
} );
```
Add New Note to this Reply
December 7, 2018 at 5:51 AM #12538

Pete Wlodkowski
Participant

Thank you very much for getting back to me.

Okay, so I can't use the builder at all? Can I convert what I have built to code and modify that?

Add New Note to this Reply

December 7, 2018 at 6:00 AM #12539

Pete Wlodkowski
Participant

Oh, okay, I found the code tab. Thank you!

Add New Note to this Reply

December 7, 2018 at 6:21 AM #12540

Pete Wlodkowski
Participant

So, I'm assuming I can use the builder, copy the code, edit it, paste the code into functions, and deactivate the builder? Is that a correct flow?

Add New Note to this Reply

December 7, 2018 at 10:50 AM #12543

Anh Tran
Keymaster

Yes, that's the correct flow. It's useful whenever you want to do advanced things with code.

Add New Note to this Reply

December 14, 2018 at 12:57 AM #12659
Pete Wlodkowski
Participant
Okay, great, so I have this set up - I rebuild the fields I want to use for my dropdown options in Meta Box instead of ACF.

So, the fields I want to use for the Points dropdown are:

W
RU
T5
T10
T15
T20
T30
T40

My code is below:

https://ghostbin.com/paste/9gg73

Is it still basically the same to populate the points dropdown options...

I tried to modify the snippet you sent to this:
```
$options = array(
        'w' => get_r_points_table( $post_id, 'points_w', true ),
        'ru' => get_r_points_table( $post_id, 'points_ru', true ),
        // and so on.
    );

                    array (
                        'id' => 'ppoints',
                        'name' => 'Points',
                        'type' => 'select',
                        'placeholder' => 'Select an Item',
                        'options' => $options,
                        'columns' => 1,
                    ),
```
But it came up empty...

Thank you for your assistance!

This plugin is so great. I realize the limits to what I can build in WordPress are much broader now.

Thank you.

Add New Note to this Reply
December 14, 2018 at 3:08 AM #12661

Pete Wlodkowski
Participant

TO show you the back-end, post edit screen.... I'm trying to get the tournament points to populate the points select dropdown:

Add New Note to this Reply

December 14, 2018 at 10:48 AM #12666

Anh Tran
Keymaster

Oh, you use group! So the code to get the point should be different a little bit. I've fixed your code to: https://ghostbin.com/paste/9p34h. Please take a look.

Add New Note to this Reply

December 15, 2018 at 2:08 AM #12689

Pete Wlodkowski
Participant

Anh Tran, you are awesome my friend. I send a lot of gratitude and karma your way! You deserve it. Thank you for helping me on this. Happy Holiday.

Add New Note to this Reply

December 18, 2018 at 1:54 AM #12711

Pete Wlodkowski
Participant

Hi Anh,

Quick question. I've set up individual groups for multiple years (2006 - 2019), but it is very slow:

Here is my working code for the multi years, wondering if there is a better way to write it so it is quicker. Like I said, this is slow. It's taking forever to load the edit Tournament (edit post).

https://ghostbin.com/paste/ejjhy

Thought maybe the multi year functions could be grouped... just wasn't sure. Thought I'd send you a message. Thank you!

Add New Note to this Reply

December 19, 2018 at 4:43 PM #12737

Anh Tran
Keymaster

I have optimized your code to make it much shorter here: https://ghostbin.com/paste/uk3zq. As all the year has a same meta box, it can be wrapped in a function.

However, the speed is slow maybe because of the post field. Each post field make a query to the database to get all posts. As you have 14 post fields for 14 years, there are 14 queries. That might be the cause.

Update: I have updated the plugin on Github https://github.com/wpmetabox/meta-box/ that has an improvement for the post field. Now it runs only 1 query instead of 14. Please download from Github and try it.

Add New Note to this Reply

January 25, 2023 at 10:18 PM #40306

Codog
Participant

Hi Anh Tran,
I am trying to solve a very similar problem (as above) using Metabox Group fields to populate select options. I noticed you had a code example for this in reply #12666 that links to https://ghostbin.com/paste/9p34h. Unfortunately, this example is no longer available there - do you have it somewhere else? Think it will help my problem.

Cheers 🙂

Add New Note to this Reply
Author

Posts

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic.