Hello, please find my feedback below.
1. Can a custom field be inherited by a child and such that values of the child change if the value of the parent is changed. ( I have existing data)
2. Alternatively if I could make Event type a Taxonomy can it be inherited and is there any specific documentation i could follow?
Unfortunately inheritance isn't automatic or built-in to Toolset relationships like this, but you could use custom code and the Toolset APIs to achieve either of these options. You could copy the value of custom field from a parent post into all child posts, or you could copy the taxonomy terms associated with a parent post and apply those same terms to all child posts.
To copy the values of a custom field or the terms of a taxonomy, you need to understand at least the following WordPress hooks and Toolset APIs:
save_post
https://developer.wordpress.org/reference/hooks/save_post/
This hook allows you to trigger any PHP code when a post is saved or updated.
toolset_get_related_posts
https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_posts
This API allows you to fetch the child posts of a known parent post.
toolset_association_created
https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_association_created
This API allows you to trigger any PHP code when two posts are connected using a post relationship. For example, when a new child post is connected to an existing parent post, you can trigger code to copy the parent post's custom field into the child post's custom field.
toolset_before_association_delete
https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_before_association_delete
This API allows you to trigger any code just before two posts are disconnected from one another in a post relationship. You may or may not need to use this API, depending on how you want to handle child field value updates during the disconnection process.
get_post_meta (specifically for copying custom field values)
https://developer.wordpress.org/reference/functions/get_post_meta/
This API allows you to get existing custom field values. These are raw field values from the database with no formatting applied automatically.
update_post_meta (specifically for copying custom field values)
https://developer.wordpress.org/reference/functions/update_post_meta/
This API allows you to update custom field values.
wp_get_object_terms (specifically for copying taxonomy terms)
https://developer.wordpress.org/reference/functions/wp_get_object_terms/
This API allows you to fetch the taxonomy terms associated with a given post.
wp_set_object_terms (specifically for copying taxonomy terms)
https://developer.wordpress.org/reference/functions/wp_set_object_terms/
This API allows you to set the taxonomy terms associated with a given post.
3. How Can i create a table for the Gold Silver and Bronze and display the count there? Do i need to run a specific view for each of the medals and use [wpv-items-count] and get_view_query_results
You can use one View with a custom field Query Filter that accepts a shortcode attribute. This will allow you to pass the medal type into the Query Filter something like this:
[wpv-view name="Your View Name" medal="Gold"]
[wpv-view name="Your View Name" medal="Silver"]
[wpv-view name="Your View Name" medal="Bronze"]
This technique for passing arguments into Views is described in more detail here:
https://toolset.com/documentation/user-guides/views/passing-arguments-to-views/
If you want to use the Views shortcode approach, you could output wpv-found-count in the View to display the number of medals of each type. Place the wpv-found-count shortcode in the View's Loop Output editor inside the wpv-items-found shortcode but outside the wpv-loop tags, otherwise it will be displayed over and over in the results - once per result found.
If you want to use PHP APIs exclusively, you can create your own custom shortcode that displays the number of results of this View using get_view_query_results:
https://toolset.com/documentation/programmer-reference/views-api/#get_view_query_results
Example using the arguments array to pass a shortcode attribute like medal="Gold":
https://toolset.com/forums/topic/views-using-php-function-get_view_query_results-ignoring-attributes-passed/
Example creating a custom shortcode and implementing get_view_query_results:
https://toolset.com/forums/topic/get-no-of-results-returned-by-view-in-template-after-all-filters-have-applied/
Please note that this example uses a deprecated post relationship syntax for querying related posts, but should be useful as an example anyway. Let me know if you have questions about these concepts and I can offer more advice.
