I have 3 ACF fields set up on a custom post type:
Number Value A – automatically updated every minute
Number Value B – automatically updated every minute (at the same time as Value A)
Number Value C – a calculated ACF field, dividing Value A by Value B, x 100 to give a percentage
Number Value C only recalculates when I go into each individual custom post and click update.
I need a solution whereby Value C is recalculated/updated every minute automatically, then republished, based on the current values in A and B within the custom post, whether they have changed or not.
I presume the way to do this would be via a scheduled Cron Event?
Any help would be greatly appreciated!
Many thanks