[Resolved] Calculate value of a custom field based on related custom fields values

[Author]

Posts

[susanD-2]

Tell us what you are trying to do?
I have a CPT Domain with a many-to-many relationship to the CPT Services.
CPT Services has a numerical field "monthly-cost".
One of the CPT Services entries is "Email" and has a "monthly-cost" of $2.00
One of the CPT Services entries is "Hosting" and has a "monthly-cost" of $2.00
CPT Domain has a numerical field "domain-monthly-cost".
One of the CPT Domain entries is "Test.com" and is related to the CPT Services "Email" and "Hosting".

I am trying to calculate "domain-monthly-cost" = "Email" "monthly-cost" + "Hosting" "monthly-cost"

Is there any documentation that you are following? https://toolset.com/forums/topic/calculate-value-of-a-custom-field-based-on-other-custom-fields-values/

What is the link to your site? hidden link

[Minesh]

Hello. Thank you for contacting the Toolset support.

I would like to know here that at what action you want to calculate the "domain-monthly-cost". When you submit the "Domain" post from the backend admin or at any other action?

[susanD-2]

Hi. I would like it to calculate when I submit from the backend and when I submit a form (which I haven't created yet but will allow me to enter Domain information).

[Minesh]

when you say in backend - do you mean when editing single post of post type "Domain"?

If yes - you will require to use the save_post action hook:
=> https://toolset.com/documentation/customizing-sites-using-php/updating-types-fields-using-php/

And to get the related-post information you will require to use the Toolset post-relationship API function:
=> https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_posts

Once you get this information, you should get the value of your desired field and make calculation and save the total value to your desired field.

If you will require further help, please let me know.