Using html field/shortcode value in calculation

Hello @peti73 !

Hope you’re having a good week!

Glad to hear you’re finding Forminator useful!

As this is not possible out of the box, I’ve asked our Second Line Support team to check if this can be achieved using a code snippet to place the value in the form for further use. We’ll update you here as soon as we hear back from them.

Kind regards,
Pawel

Hi @peti73

I hope you are doing well.

Our developers created small code to help you:

<?php

add_filter( 'forminator_field_calculation_markup', 'wpmudev_render_calc_value', 10, 4 );
function wpmudev_render_calc_value( $html, $id, $required, $value ){
	if( $id == 'calculation-1-field' ){
		if( strpos( $html, 'data-formula=""') !== false ){
			$html = str_replace('data-formula=""', 'data-formula="15*1"', $html);
		}
	}
	return $html;
}

add_filter( 'forminator_field_calculation_calculable_value', 'wpmudev_render_calc_value_db', 10, 3 );
function wpmudev_render_calc_value_db( $formula, $prepared_data, $field_settings ){
	if( $prepared_data['form_id'] != 361 ){
		return $formula;
	}
	
	if( $field_settings['element_id'] == 'calculation-1' ){
		$formula = '15*1';
	}

	return $formula;
}

You can add the code as mu-plugin following this guide https://wpmudev.com/docs/using-wordpress/installing-wordpress-plugins/#installing-mu-plugins

calculation-1-field , calculation-1 should be changed as per the field settings. Form ID should be changed from 361 to your form ID. The developer used this 15*1 which should be changed to the value that you get via a shortcode from an external API.

Best Regards
Patrick Freitas

Hello @peti73 !

Apologies for the confusion here!

To use the snippet, you will need to add an additional Calculations field (you can make it hidden) which will take the value from the shortcode and you will be able to use it for further calculations in the other field. The HTML field will only be used in this case to display the value to the visitor.

So calculation-1-field is the new Calculations hidden field you add for this purpose.

In the field you can add a formula such as 0 + 0 just so it has something there.

For the 15*1 please change:

$formula = '15*1';

To something like:

$formula = do_shortcode('[your_shortcode]') . '+ 0';

Best regards,
Pawel