Hi Richard,
This might be some help:
updating-user-meta-on-save-post
You’ll be looking at creating a function that uses the WordPress save_post
hook, more info on that here.
Not a complete answer I know, but it’ll hopefully give you some direction.
Cheers, Dan