Display a custom column on inbound messages table

Url can be saved because it is part of the form.

You should do something more complex and add the user agent to the fields that are saved in the custom meta of the wpcf7_contact_form custom post.

Hi @codekraft

I am trying to understand your reply and see how to make changes to my code but I am able to.

The required data is ALREADY being seen in the Meta section. See screenshot

Would you please guide further with specific changes to the code posted above?

Thanks

ciao @koolpal
when flamingo stores an email it creates a custom post type “flamingo_inbound” post. In that post there isn’t the user agent metadata, so you need to store also the UA when the action ‘wpcf7_after_flamingo’ was triggered.

add_action( 'wpcf7_after_flamingo', 'my_flamingo_add_ua' , 11, 1 );
function my_flamingo_add_ua( $result ) {
get the submission instance and the posted data. then store the UA into post meta 
}

@codekraft Thanks. I am not experienced with code.

Can you please help expand on
get the submission instance and the posted data. then store the UA into post meta
with actual code?

Thanks

(untested)

add_action( ‘wpcf7_after_flamingo’, ‘my_flamingo_add_ua’ , 11, 1 );
function my_flamingo_add_ua( $result ) {
$submission = WPCF7_Submission::get_instance();
$submission_UA = $submission->get_meta( ‘user_agent’ );
update_post_meta( $result[‘flamingo_inbound_id’], ‘_user_agent’, $submission_UA );
}

then you can show the user agent (with small edits) at the code you have posted before

@codekraft Brilliant! Thank you! This works on NEW form submissions!

Updated code (p.s. code snippets not in code format gets messed up)

add_action( 'wpcf7_after_flamingo', 'my_flamingo_add_ua' , 11, 1 );
function my_flamingo_add_ua( $result ) {
$submission = WPCF7_Submission::get_instance();
$submission_UA = $submission->get_meta( 'user_agent' );
update_post_meta( $result['flamingo_inbound_id'], '_user_agent', $submission_UA );
}
function flamingo_columns( $columns ) {
    $columns['UA']="User Agent";
    return $columns;
}
add_filter( 'manage_flamingo_inbound_posts_columns', 'flamingo_columns' );
add_action('manage_flamingo_inbound_posts_custom_column', 'show_flamingo_UA', 10, 2);
function show_flamingo_UA($column_name,$post_id) {
  if ($column_name=='UA') {
    echo get_post_meta( $post_id, '_user_agent', true );
  }
}

Is there any way to fetch and display EXISTING values for the PAST submissions?

Thanks a lot!

No, unless you invent the time machine! ??

?? Ha ha ha! Good one.

Is there no mechanism / code to fetch ONE TIME the values which can be seen when I view the message?

@codekraft Some other thought occurred to me.

When we open a CF7 submitted form in Flamingo, the Meta section below shows the fields (like serial_number, UA, url, etc) associated with this form submission.

Since the association/linkage is ALREADY made do we STILL need to update post meta to use and display in a column?

Can we not use the existing association/linkage and display any of the meta fields in the column(s)?

Do we need to duplicate the data by using update_post_meta?

Thanks

but you know you’re right? actually the user agent is already stored in the meta so you don’t need to save it.

to recap:

function flamingo_columns( $columns ) {
	$columns['UA']="User Agent";
	return $columns;
}
add_filter( 'manage_flamingo_inbound_posts_columns', 'flamingo_columns' );
add_action('manage_flamingo_inbound_posts_custom_column', 'show_flamingo_UA', 10, 2);
function show_flamingo_UA($column_name,$post_id) {
	if ($column_name=='UA') {
		$meta = get_post_meta( $post_id, '_meta', true );
		echo $meta['user_agent'];
	}
}

you can print the other data simply replacing “echo $meta[‘user_agent’];” with print_r($meta);

@codekraft Just brilliant! Awesome! fantastico ??

I did not understand how to use this but the above code is just superb!

you can print the other data simply replacing “echo $meta[‘user_agent’];” with print_r($meta);

Take care and stay safe, wherever you are!

FIY at the place of
echo $meta[‘user_agent’];

to get the list of the saved metadata (remote_ip, url for example) use “print_r($meta);”

??

?? Oh OK. Got it. But it shows everything in this single column which looks messy. Thanks for this though.

yes print_r it’s only for gather the stored information because can print arrays, so you can create another column (ie ip) because you know the name of the items arrays… in this way for example you can know the user ip is stored as “remote_ip” etc