[Resolved] How to calculate two custom fields and output to another custom field?

[Author]

Posts

[StanleyT8485]

Tell us what you are trying to do?
I want to calculate the values of two custom fields (numeric) and output to another custom field.

[Minesh]

Hello. Thank you for contacting the Toolset support.

Can you please tell me where exactly you want to make this calculation.

On the admin site while editing post or using the Toolset form?

[StanleyT8485]

Hey Minesh,

On the admin. The custom fields are attached to a certain post type.

Stan

[Minesh]

So, why dont you use the standard WordPress hook save_post and grab the custom field values and make addition of that and store it to your third custom field.

More info - please check the following example and adjust your code accordingly.
=> https://toolset.com/documentation/customizing-sites-using-php/updating-types-fields-using-php/#an-example

[StanleyT8485]

Do I have to manually save the post to perform the calculation for the custom field?

There will be over hundreds of posts that require the calculation every 30 mins. Is there any way we can automate this?

Stan

[Minesh]

There is no such feature. As you know, that would obviously require custom code and for that you will require to write that on your own.

[StanleyT8485]

How about not putting the calculation into a custom field?

The main goal is to show the calculation in a View.

[Minesh]

Yes - but what field you want to display within the view?

Normally, whatever field you want to display within the view you will just require to add it within the view's Loop Editor section and it will be get displayed on frontend where you will add your view.

[StanleyT8485]

I want to show the calculation of two custom fields.

Can I perform calculations in the editor like [custom field 1] + [custom field 2]? If I can, that would be amazing!

[Minesh]

You will require to write the custom shortcode that do the calculation and return the results.

[StanleyT8485]

Thanks. Is there any documentation I can follow to implement this?

[Minesh]

Here is the related ticket with the solution you are looking for - can you please check if that helps?
=> https://toolset.com/forums/topic/calculating-types-custom-fields-and-display-in-html-container/#post-345125

[StanleyT8485]

Thank you! I got it with the code you provided in the link.

add_shortcode('wpv-calculate', 'calculate_shortcode');
function calculate_shortcode($atts,$content=null) {
$content = wpv_do_shortcode($content);
$content = eval("return $content;");
return $content;
}

Another question. This might be a bit more complicated.

One of the custom fields I want to calculate is from a Child post. However, Toolset doesn't allow me to show a custom field from a Child post in the current post. It needs a View to show this custom field.

Screenshot of the custom fields I want to calculate: hidden link

I tried putting the View in the [wpv-calculate] shortcode and it resulted in a syntax error.
[wpv-calculate][types field='ticker-price' output='raw'][/types]+[wpv-view name="test-price-to-book-fy20"][/wpv-calculate]

Is there a workaround this?

[Minesh]

I would like to review your view and where you added the calculation shortcode.

Can you please share problem URL and access details.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

I would like to know to what column you want to display the calculated amount? with "WALE" column or "Occupancy" column?