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

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 🙂
December 16, 2021
Absolutely a 5 star plugin. Now why did I say "Excellent Start"? Because it does not support the Repeater field, which is almost a necessity for almost any serious ACF (Pro) project. Any project that uses the Repeater field won't be able to easily export all the Custom Field values, it will only see faster query executions. I hope this will be added in the future... but I do understand the difficulties in coding to support such functinality. Update: I just checked the official Documentation page, it it says it does support the Repeater field, which is not listed in the Description of this site... so I need to test it to find out which one is true... there are 2 conflicting statements here... Latest Update (after initial review): After further testing, Repeater fields are NOT supported, unless I'm doing something wrong, the documentation is definitely wrong ! Conclusions: Out of the box, extremely easy to setup, works like a charm by testing only few of the supported fields, and there are plenty of them. That said, I also wonder if there is a way to make it support 3rd party ACF fields, as the ACF eco. is quite large and there are a number of 3rd party custom made ACF fields that some of us use. The Read Only feature is an interesting one too, only Admins can edit that. I'm involved in another plugin that can make a field a Read Only, and in that case it is really a Read Only, nobody can edit it, so this take is way better ! Another interesting note: I think the Custom Fields by default also get stored in the Post Meta table as well the custom Table be create for them. Thankfully there is a filter to stop this behavior for those who want it. Obviously I need more time to read all the Doc pages and do more thorough testing in a few days... I absolutely love what I have experienced so far, Soon, I will come back here and give a verdict on the Repeater field, and clear things up ! Thanks a million, Nick.
Read all 2 reviews

Contributors & Developers

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

Contributors

Changelog

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