When post is Published, insert into custom table a number – custom post type

Take a look at WordPress’ Post Status Transitions hooks: https://codex.wordpress.org/Post_Status_Transitions

If you’ve added proper debugging (so that you die at the top of your hooked function) it sounds like you’re not hooking into the right action.

Since you’re adding some meta and checking for it to see if you should run again, you could hook into publish_custom-post-type. Also, the status may be confusing. I see you’re trying draft, but that does not include new or auto-draft. Make sure you are confident about the previous status and the new status as well as the post_type.

Related Posts:

  1. Set posts of a custom post type to be private by default?
  2. How can I add dropdown widget/box to admin post page?
  3. Limit Authors to their Own Posts on front-end excluding admins
  4. Multiple Content Block
  5. Notice: Undefined index: suppress_filters
  6. Shortcode not working with post counter
  7. Changing default ‘posts’ parameters with register_post_type_args
  8. Homepage’s content is dependent on the custom field values (set automatically), how do I get homepage to update without manually updating page?
  9. Allow users to create posts without logging in?
  10. How to assign classes to all elements?
  11. Showing custom post type categories in the menu
  12. WordPress notification if new post published
  13. Get post format
  14. Template code to split a post and print a custom field?
  15. Send post changes to set email addresses (not users or subscribers)
  16. Display author box on just certain category posts?
  17. redirect after submiting post for review
  18. What is the best way to set the post category (Custom Post Type) automatically based on the one of the tags assigned to the post?
  19. subtracting the current post form then whole loop, which is generating all CPT titles
  20. Post that populates itself (almost) automatically using data from imported excel file
  21. How to mark posts as visited
  22. Work and Display a Custom Post Type as a normal Post
  23. Featured image in custom post is being disabled
  24. How to make a non-public post on wordpress approval?
  25. Restrict custom post type to only site administrator role
  26. How to force one column layout on custom post type edit page?
  27. WordPress REST Create Post of Custom Type
  28. Limit the post for differents custom post type in the same wp_query
  29. How do I add a custom post type to the Featured Content in twenty fourteen theme?
  30. Assigning a role to a specific custom post type (and ignoring other post types)
  31. Custom post type loops with different page templates
  32. Display posts in random post types
  33. Display Custom Post Type in Recent Posts
  34. Allow Users Access to Custom Post Type Only
  35. Slug for standard post post_type
  36. How to get Custom Post ID by adding filter to child theme’s function
  37. How do I create an archive page for standard posts?
  38. Remove parent from custom post type
  39. When ‘is_post_type_archive()’ return true?
  40. How to add the post ID (or any other post data) to a Contact Form 7 mail?
  41. How To Enable Block Editor (Gutenberg) for Existing Post Type via functions.php
  42. Create a post in custom post type using field in registration form after users submit form
  43. right_now_content_table_end function not working?
  44. How to add post_type=value when editing that post type in the WordPress admin?
  45. Open Custom Post Type as PDF
  46. Update Post Meta for a logged in user
  47. ACF field key/value to show on taxonomy list
  48. Re-registering a custom post type not working (not showing up)
  49. Get the category from custom post type
  50. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  51. Prioritize posts in query by meta keys?
  52. Load Next Posts With AJAX not working with custom post type
  53. Configuring a meta query with multiple post types that have the same relationship on a single page
  54. Add term to custom post type on draft
  55. Template not working for the custom Post type
  56. Is it a good idea to add a column to the posts table?
  57. Loop increase number
  58. Change Slug of a Custom Post Type
  59. Creating separate feeds for custom post types
  60. wordpress lists similar type of posts in a custom post type
  61. Auto post creation
  62. Rewrite permalink for multiple post types (CPT) with taxonomy term
  63. Easy reading or transfer of data from posts?
  64. list posts of two post types in a single template
  65. The loop does not show users
  66. Front-end Image Upload to Custom Meta Box
  67. Conflict in function to allow single post template based on category
  68. Invalid content when I try to import custom post type from the old template wordpress
  69. Why is my custom post content only viewable when signed into WordPress?
  70. Add a form in every post and save data in post meta
  71. Pagination not working in custom post type. Help
  72. Right way to store a large set of similar information on website? [duplicate]
  73. Create a post automatically if search result has zero results
  74. Limiting the Number of User Posts to Their Own Posts
  75. Correct way adding External classes to Custom Post type and output their methods to template
  76. Problem with multi checkboxes value in metabox?
  77. Assign a Post to a User
  78. Cannot save pages after migration
  79. News post with multiple permalinks? When opened from different page
  80. Rest Api not working with Iframe in form data
  81. Send mail to author when custom post type is saved
  82. Recovering data about custom post and taxonomy types
  83. Display title of all custom posts from same taxonomy term on a custom post template
  84. wordpress does not see the correct custom taxonomy hierarchy
  85. Use WP pagination functions on a custom page template
  86. is using “require_once” in wordpress theme affect the speed ???
  87. Rewrite url post_tag for custom post type
  88. Only show current category post
  89. WordPress Contents Migration
  90. Problem to get the link of the default ‘post’ post type like the orther custom types
  91. How to set class to “current-page” on the currently viewed single post within a CPT
  92. Getting wrong ID
  93. call_user_func_array() error after moving to another server
  94. How to make post page unique and show it on home page?
  95. Query Posts From Multiple Post Types
  96. WP Build-In Post selector for CPT
  97. How to hide home title on pages and posts?
  98. How do I hide single category post on my post page
  99. Can WordPress show posts based on a button that the user clicked 2 pages back?
  100. Sort ACF by custom taxonomy