ACF unable to use user field

Question

I am totally new to wordpress and acf and I'm trying to use a user field in a post to show the author of the post. I tried to programatically add the post author id as a meta attribute in the wp_postmeta table like this:

update_field('video_author', get_current_user_id(), $post_id);

The post author, however, is not shown:

What am I doing wrong?

Also when I click the user field no users are listed. I presume acf looks for users in either "wp_users" or "users" table, both of which contain records. However, this is shown:

Thank you in advance.

Answer 1

If you are using ACF then you don't need to update field manually. Field will be updated when you update the post.

And To retrieve this field use :

get_field( 'video_author', $post_id );

For User field, make sure you have selected Field Type -> User in ACF.