ACF to Custom Database Tables

Description

An add-on plugin for Advanced Custom Fields that lets you save custom fields data in an organized, structured database table instead of WordPress’s post meta table.

Features

  • Create a database table from the ACF fields
  • ACF’s native method support
  • Custom wordpress filters to extend functionality.
  • Faster Searches & Easy Export
  • Detailed tables schema change log

Supported Fields

  • Text
  • Text Area
  • Number
  • Range
  • Email
  • Url
  • Password
  • Image
  • File
  • Wysiwyg Editor
  • oEmbed
  • Select
  • Checkbox
  • Radio Button
  • Button Group
  • True / False
  • Link
  • Post Object
  • Page Link
  • Relationship
  • Taxonomy
  • User
  • Google Map
  • Date Picker
  • Date Time Picker
  • Time Picker
  • Color Picker
  • Group
  • Gallery (Pro Version)
  • Repeater (Pro Version)
  • Flexible Content (Pro Version)

Links

Screenshots

  • Create a database table from the ACF fields

  • View SQL query and changes

Installation

Note: Advanced Custom Fields plugin free or paid version is required.

  1. Upload the plugin to your /wp-content/plugins/ directory.
  2. Activate the plugin in your WordPress admin.
  3. Go to the Custom Fields > Field Groups menu. Edit or create a field group and enable “Custom Table” option then enter custom table name inside “Custom Table Name” field.

Upgrade to Pro

Reviews

October 1, 2023 1 reply
Hi, does your plugin support saving data from the front ( using acf_form() )  (not from the admin area) ? Thanks for your help.
September 28, 2023 1 reply
You have to create the custom posts by hand, one by one, from the admin. If you import them bulk, the custom table will not be updated. I have a custom post already created that I want to transfer to custom table; if I go to a post and update it, nothing happens, the data is not saved in the custom table.
October 4, 2022
First of all I want to thanks the author of this amazing plugin… we have a meet call where he explained to me some really usefully tricks to import a large database in his custom table, saving hours of working. This plugin is a must for anyone who use ACF. Also it works perfect with the JSON method from ACF. Nothing if more fast than this combination…. Again thanks and thanks 😄
February 5, 2022
Working with a custom table is much more clear than working with the wp_postmeta table. I can edit the custom table now directly without problems. Many thanks to the developer 🙂
Read all 7 reviews

Contributors & Developers

“ACF to Custom Database Tables” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.0.7

28th July 2024
Extended support for acf_form
Fixed warnings

1.0.6

13th November 2023
Fixed Attachment page issue

1.0.5

9th August 2023
Fixed warnings
Fixed UI issues
Changed table create schema
Tested on WP 6.3

1.0.4

10th September 2022
Fixed ACF data display issue when Local JSON setting is not enabled

1.0.3

9th July 2022
Fixed undefined warning
Added readonly support for Select field
Tested on WP 6.0

1.0.2

Fixed get_field bug – 5th February 2022

1.0.1

UI enhancements – 19th December 2021

1.0.0

First Version – 15th December 2021