[Resolved] get the sum of custom fields after submit a form using submit api

[Author]

Posts

[SteffenM1628]

Tell us what you are trying to do?

i wonder if thats possible with the submit api.
i have 4 fields and i want to calculate all fields together to get a sum and than save that sum in another custom field of this posttype.

field1+field2+field3+field4= save the total of all 4 fields in another custom field.

But i am no coder so it is very difficult for me to get this running.

Any ideas?

Thank you so much

[Nigel]

Here is an example using the cred_save_data hook (https://toolset.com/documentation/programmer-reference/cred-api/#cred_save_data).

You'll need to edit the slugs of the fields to sum, the slug of the field which will store the results, as well as the ID of the form.

Hopefully the code is clear enough to follow.

You can add it at Toolset > Settings > Custom Code.

/**
 * Custom form action to sum field values
 */
add_action( 'cred_save_data', 'tssupp_form_submit', 10, 3 );
function tssupp_form_submit( $post_id, $form_data ){

	if ( in_array( $form_data['id'], array( 123 ) ) ) { // Edit form ID

		$slugs = array( 'field1', 'field2', 'field3', 'field4' ); // Edit slugs of fields to SUM
		$result_slug = 'field5'; // Edit for slug of field to store result

		$values = [];

		foreach ($slugs as $key => $slug) {

			$values[$key] = get_post_meta( $post_id, 'wpcf-' . $slug, true );
		}

		$sum = array_sum( $values );

		add_post_meta( $post_id, 'wpcf-' . $result_slug, $sum );
	}
}

[SteffenM1628]

hey nigel,

some question are left over
please check the code

<?php
/**
 * New custom code snippet.
 */

toolset_snippet_security_check() or die( 'Direct access is not allowed' );

/**
 * Custom form action to sum field values
 */
add_action( 'cred_save_data', 'tssupp_form_submit', 10, 3 );
function tssupp_form_submit( $post_id, $form_data ){
 
    if ( in_array( $form_data['id'], array( 985 ) ) ) { // Edit form ID
 
        $slugs = array( 'wpcf-skala-job-schwerpunkt-1', 'wpcf-skala-job-schwerpunkt-2', 'wpcf-skala-job-schwerpunkt-3', 'wpcf-skala-job-schwerpunkt-4' ); // Edit slugs of fields to SUM
        $result_slug = 'wpcf-skillswert-speichern'; // Edit for slug of field to store result
 
        $values = [];
 
        foreach ($slugs as $key => $slug) {
 
            $values[$key] = get_post_meta( $post_id, 'wpcf-' . $slug, true ); // What shell i add here: wpcf-
        }
 
        $sum = array_sum( $values );
 
        add_post_meta( $post_id, 'wpcf-' . $result_slug, $sum ); // What shell i add here: wpcf-
    }
} 

Another question is where does the calculating is going on because the sum of all fields needs ((sum *100)/40) to get the percentage of the sum. but i can´t see math anywhere?

[Nigel]

You don't need the wpcf- prefixes for the fields because these get added where required in the code.

The maths happens with array_sum, which adds up the field values.

You can perform some further arithmetic to calculate $sum.

[SteffenM1628]

hey nigel,

thanks for your advice. but the code does not save any value in the new field. the code runs fine but nothing happens.

[SteffenM1628]

My issue is resolved now.
i have found the problem. As you said don´t need the prefix!
Thank you so much!