I have a repeatable group (Species Calendar) containing a Checkboxes field (24 checkboxes), inside another repeatable group (Fish Species). I'm trying to count the total number if checkboxes that are checked (there will be 24 x the number of Fish Species). I can't find any documentation on this or ideas in the forum. Can you help?
I hope this helps and for more personalized assistance around custom code, you can also consider hiring a professional from our list of recommended contractors: https://toolset.com/contractors/
Thanks for this. I need to use the results of the function in a conditional statement to hide or show certain elements. After registered the customshortcode in Toolset -> Settings -> Front-end Content, I tried:
The format for the conditional shortcode looks correct.
You can add an attribute debug="true" to the wpv-conditional shortcode and it will show what is comparing (the left and right sides of the comparison) to help identify any problems.
Instead of putting the shortcode inside a conditional shortcode, I would first simply output it to the screen to see if the results are what you expect.
I've read over the ticket and I suspect there is a problem relating to your nested field groups.
The top-level group is Species Calendar.
This contains nested groups, Fish species, which contains the checkboxes field.
It looks to me like the code Waqar has provided is intended to count the number of checked checkboxes within one Fish species group.
But your intention is to count the total number of checked checkboxes across all the Fish species groups within a single Species Calendar group, is that correct?
If that is the case, the code will need re-thinking, if you could please clarify your intentions first.
I added the debug parameter and used the shortcode to display the value from the function, and indeed the function is always evaluating as zero, so you're correct in thinking that the function that Waqar provided is not working correctly.
I can confirm my intention is to count the total number of checked checkboxes across all the Fish species groups within a single Species Calendar group.
Note that the expected context is that you insert the shortcode when displaying the outer RFG (presumably using a View), and it will then display the count of all of the checked checkboxes in the nested RFGs.
The shortcode takes no arguments and can be used as [checked-count]
You will need to edit/verify the slugs of the nested RFG and of the checkboxes field:
add_shortcode('checked-count', function () {
global $post;
// slug of nested RFG
$nested = 'fishspecies';
// slug of checkboxes field
$field = 'species-availability';
$field = 'wpcf-'.$field;
// Get the nested RFG posts
$nested_posts = toolset_get_related_posts( $post->ID, $nested, array(
'query_by_role' => 'parent',
'role_to_return' => 'child',
'limit' => 999,
) );
$checked = 0;
foreach ($nested_posts as $key => $nested_post) {
$checkboxes = get_post_meta( $nested_post, $field, true );
$checkboxes_array = maybe_unserialize( $checkboxes );
$checked += count( $checkboxes_array );
}
return $checked;
});
And I inserted the shortcode [count-species-availability] in the View that loops the outer RFG (view="fish-species-calendar"). I tested it with the post "Alaska Trophy Adventures Lodge". The count should be 56 for that post. The url of the post is hidden link.
The parent RFG is species-calendar and the nested RFG is fish-species, is that not right?
You changed the line where the slug of the nested RFG is defined to 'species-calendar', but unless I've misunderstood your set-up it should be fish-species (or whatever the actual slug of the nested RFG is).
I checked this code on my own site before sharing where it worked, so I expect it should work on your site when using the correct slugs, etc.
Hi Nigel...no you have it backwards..."fish-species" is the parent and "species-calendar" is the nested child. See attached image. I can also give you access to the admin if that helps.
Ah, okay, I see, in which case I'm not sure why it isn't working.
Yes, can I get access to your site, then, and I will try to debug it.
I will mark your next reply as private so that I can get log-in credentials from you—you may want to create a temporary admin user for me to use that you can later delete. And be sure to have a current backup of your site.
The problem arises because you insert the shortcode outside of the loop in the View of the outer RFG (fish-species), so the context for counting up the checkboxes inside the nested species-calendar RFGs isn't the current fish-species (which it needs to be), and is instead the post where the View is inserted (e.g. the lodge alaska-trophy-adventures-lodge).
You have the shortcode inside the wpv-items-found section, but not inside the wpv-loop tags, and so the required context is lost.
If you want the sum of all the checked checkboxes in nested species-calendar RFGs summed across all fish-species RFGs rather than for each fish-species group then that's a different task than we've been dealing with so far.
Thanks for writing back and since Nigel has an off day today, I'll be resuming on this ticket.
I apologize for the confusion earlier, as the shortcode that I shared with you in my first reply was designed to work from the loop of "Species Availability" posts when the ID was provided through the "id" attribute.
The custom shortcode that you and Nigel have been working with would work, if you'll use it inside the loop of nested "Species Calendar" posts.
However, looking at the call of this shortcode in the "Fish Species Calendar" view, I understand, that you'd like to get that count outside the loops for "Species Availability" or "Species Calendar" posts when the scope of the current post is the "Lodges" type post.
For this purpose, you'll need a custom shortcode, that first cycles two nested levels down, and then get the count of the checked field items.
add_shortcode('count-species-availability', function () {
global $post;
// slug of level one nested RFG
$level_one = 'fish-species';
// slug of level two nested RFG
$level_two = 'species-calendar';
$field = 'wpcf-species-availability';
// Get the nested RFG level one posts
$nested_level_one_posts = toolset_get_related_posts( $post->ID, $level_one, array(
'query_by_role' => 'parent',
'role_to_return' => 'child',
'limit' => 999,
) );
$checked = 0;
// loop through nested RFG level one posts
foreach ($nested_level_one_posts as $key => $nested_level_one_post) {
// Get the nested RFG level two posts
$nested_level_two_posts = toolset_get_related_posts( $nested_level_one_post, $level_two, array(
'query_by_role' => 'parent',
'role_to_return' => 'child',
'limit' => 999,
) );
// loop through nested RFG level two posts
foreach ($nested_level_two_posts as $key => $nested_level_two_post) {
$checkboxes = get_post_meta( $nested_level_two_post, $field, true );
$checkboxes_array = maybe_unserialize( $checkboxes );
$checked += count( $checkboxes_array );
}
}
return $checked;
Thanks for this. When I insert the shortcode in my view to just display the result, it works fine--YAY! However, I need to use the results in a conditional statement to hide or show certain elements. After registering the custom shortcode in Toolset -> Settings -> Front-end Content, I tried:
However, even when the shortcode evaluates to a result of zero, the conditional statement is never true. If I add debug="true", the debug information ids also not shown.
I've checked your post "Glacier Bear Lodge" ( hidden link ) and the shortcode does seem to be working in the conditional statement too.
( note: the count of checked items is 0 for this post )
Screenshot: hidden link
The custom CSS code to hide the section is being included in the markup, but it is not applying because other styles which are more specific are overriding it.
You can either make this custom CSS code more specific ( ref: hidden link ) or introduce "!important":
