Meta Box

Custom fields 'Save data in a custom table' feature

Support › MB Builder › Custom fields 'Save data in a custom table' featureResolved

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • April 6, 2021 at 4:53 PM #26994
    HenriHenri
    Participant

    Hi Metabox,

    I'm setting up a custom post type and have created a few custom fields. Now I see that you can also use the feature 'Save data in a custom table'. Is there some information I can read how to use this feature? For example I have the following questions: Do I need the other Metabox plugin Custom tables? Does it help with choosing a table or do I exactly need to use the right name?

    Any pointers would be greatly appreciated.

    Kind regards, Henri

    April 6, 2021 at 9:19 PM #27002
    Long NguyenLong Nguyen
    Moderator

    Hi Henri,

    Thank you for getting in touch.

    Yes, you need to install/activate the plugin MB Custom Table or MB AIO to use this feature. After creating the custom table by coding, you can add the table name to the Builder to save the field value to the custom table.

    Get more details on this documentation https://docs.metabox.io/extensions/mb-custom-table/.

    April 6, 2021 at 9:48 PM #27009
    HenriHenri
    Participant

    Hi Long,

    I've just got the message on Facebook of a new tutorial on Youtube: https://metabox.io/move-custom-fields-data-to-custom-tables/#more-26926

    What a coincidence 🙂 Thanks for this nice tutorial.

    I've used the 'Save data in a custom table' and 'Create table automatically' features of the Builder to create the custom table. After created I changed the field types in the table via PHPmyAdmin, because all fields were Text type. Is that okay to do or might that cause problems if I change the field types this way in the database?

    Kind regards, Henri

    April 7, 2021 at 8:34 AM #27015
    Long NguyenLong Nguyen
    Moderator

    Hi,

    Data type TEXT is a good fit for most cases. But if you want to optimize the database or for specific cases (field value), you should use other data types and it can be done by using the code.
    https://docs.metabox.io/extensions/mb-custom-table/

    Get more information about data types here
    https://www.w3schools.com/sql/sql_datatypes.asp
    https://www.tutorialspoint.com/mysql/mysql-data-types.htm

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.