crowwoods1

well, I did what you said. I re-installed the total-field-handler and it worked. Not instantly as soon as I press ‘Save’, but when I log back in again, it worked.

Then I changed ‘numeric_1’ to ‘energy_turn_lights_off’ and it didn’t work. Why? Because I have too many underscore in my field name? Too long? So I changed it back to numeric_1, and it no longer worked. Then I deleted the plugin and re-installed it. Still, it wouldn’t work. Now I see that when I reinstalled it, the folder name in my host was a super long string of characters. I’m able to pull it up in the plugin editor, but the function no longer works. Why went wrong? Should I be changing the long string of characters? What to do next?

Hi Roland,

I’m really stuck. Is there a way I can hire someone to help me get the Total Fields plugin working? Plus, I would really like to be able to total up team points across multiple records for participants who belong to the same team. Since you don’t have the time, can you recommend someone who can?

Thanks so much! Ivy

Yes, I followed your instructions. I deactivated the plugin to make changes, then reactivated it to test.

That sounds good, but it didn’t do anything. My modifications:

{
  // set this up to list the fields to sum
  // must be numeric!
  $fields_to_total = array('energy_turn_lights_off','energy_unplug_chargers','energy_unplug_small_appliances','energy_reduce_use_of_air_conditioning','energy_reduce_screen_time','energy_turn_off_at_the_power_strip','energy_wash_clothes_in_cold_water','energy_buy_carbon_offsets_for_deliveries','nature_explore_a_nature_walk','nature_play_a_game_outside','nature_hold_a_meeting_outside','nature_weed_without_pesticides','nature_pick_up_trash_in_parks_and_beaches','mobility_use_alternative_transportation','mobility_combine_car_trips','mobility_no_idling','mobility_buy_carbon_offsets','suscom_buy_products_made_locally','suscom_support_local_businesses','suscom_avoid_refined_sugar','suscom_eat_plant_based_diet','suscom_stop_smoking','waste_buy_from_environmentally_responsible_companies','waste_think_twice_before_buying_new_things','waste_avoid_wasting_food','waste_use_reusable_bags','waste_avoid_buying_plastic_or_items_in_plastic_containers','waste_reuse_things_other_than_bags_and_water_bottle','waste_compost_food_waste','waste_zero_waste_for_a_day','waste_no_littering','waste_use_mulch_setting_on_lawnmower','water_take_shorter_showers','water_turn_water_off_when_brushing_teeth','water_run_dishwasher_only_when_full');
  		  
  // name of the total field
  // should be numeric field
  $total_field = 'points_for_daily_actions';
  
  // calculate the total
  $total = 0;
  foreach ( $fields_to_total as $field ) {
    $total += $record[$field];
  }
  
  // place the total in the data array
  $record[$total_field] = $total*10;

Hi again,

I’m planning for next year’s Earth Day Challenge, and want to resolve my problem with not being to add up points for each participant, and also adding up team points automatically. I had used 3 different php forums to help me but none were able because they didn’t understand how Participant Database is set up. I’ve explored other plugins like Calculated Fields Form, wpDataTables. None is as simple as if you can provide a template for adding up points within a record, and across multiple records. Can you provide a template, or recommend how to get help from someone familiar with php and Participant Database?

Thanks, Ivy

I didn’t realize that the Calculated Fields Form doesn’t provide the data structure.

Last year, I used the plugin Participant Database to generate the Participant Record and the lists. Can I use the Calculated Fields Form in conjunction with the Participant Database just to do the points calculations automatically?

Thanks, Ivy

Hello, codepeople,

Each participant will indicate/update how many days they’ve done a number of activities for the duration of the Challenge to earn points. e.g. turn off lights when not in use – 5 days in the Days-Turn-off-lights field, use alternative transportation – 12 days in the Days-Alternative-Transportation field. It sounds like your form can add up all the number of days they’ve done all the activities and use a multiplier to calculate the points. So I would have a field ‘Total Points’ on each record.

Each participant also signs up for a team, and the team that earns the most points collectively wins a prize. The Team Name can be already there as a choice, or the participant can add a new Team Name. On each record is a field ‘Total Team Points’ so that on condition that the team name matches, the Total Points get added up.

So then I need two lists to show the participants. 1. each participant’s name and their team name and their Total Points, sorted by their Total Points; 2. each teams’s name and Total Team Points, sorted from the most to least Total Team Points.

It sounds I can easily do 1. with your form. But I am not sure I can also do 2. Does that make sense?
Ivy

It is now working fine with the LiteSpeed deactivated. If we reactivate it, how do we turn cache off just for the login page?

It sounds like we’re talking about a different cache. My partner working on the WP frontend said there is a little diamond-shaped thing at the top of the website (in admin mode) where she was able to purge the page and mark it as non cacheable. Now you’re talking about this plugin, LiteSpeed Cache? Deactivate that?

My partner said she just deleted the contents of the private cache and force cache fields on that page and now she can log in. Except right now, I can’t access the signup at all. The curser won’t go there. Even the login is not working. I can enter my email and password in the login but it doesn’t go anywhere and it doesn’t bring up my record. Another odd thing happening is the email and password I put in the login is now appearing in the signup, still not accessible though.

We are in the midst of people signing up right now! Help!
Now I wish I didn’t touch the cache.

The signup form appears again.

I’m working with someone who’s doing the frontend, so she marked the page as non-cacheable. Now I can’t even sign up on the page. I can’t fill in the fields to sign up. What to do?

Yes, the signup is successful, and they are added to the database. But they don’t know that because there is no thanks message. And yes, the Signup Thanks Message is in the Settings.

Could it be a problem because I have the login right underneath on the same page as the signup?

OK, I tried to follow your instructions and now have a custom record template to work with. I watched some YouTube tutorials. Here’s what I got. Am I close?

To add up points for checkboxes:
in the <td> section of the field loop after help text

<?php if($this->field-group=field-group-one_time_activities”. and.$this->field->value()=”Completed”) )
$points_for_one_time_challenges = $points_for_one_time_challenges + 25;
<?php endif ?>

<?php if($this->field_group=field-group-daily_activities”. and.$this->field->value()>0)
$points_for_daily_challenges = $points_for_daily_challenges + ($this->field->value() * 10);
<?php endif ?>

</td>

Print the total points after the group loop ends before submit buttons:

<tr>
<th><h3><?php $this->echo “Points for Challenges:” ?></h3></th>
<td>
<?php $this->print_points_for_one_time_challenges; ?>
<?php $this->print_points_for_daily_challenges; ?>
</td>
<tr>`

Thank you for your help! Sorry I’m kind of clueless. ??

Thank you so much! You save me a lot of unnecessary work.

Thank you, I’ll play with it. I’m trying to figure out where things occur.

Is it possible that under each participant’s profile:

1. I have them select the activities they’ve completed by scrolling down a list of 45 possible activities each day during the challenge? (instead of clicking on the 45 activities scattered over 6 pages)
2. I show 3 read only fields:
the total points for that participant,
the total number of logins (max once a day),
the total number of his/her posts on that site?

It seems like if everything is together, it’s easier to manage. It may be that I need to simplify the challenge a bit.