Support › Meta Box Builder › Custom fields 'Save data in a custom table' featureResolved
- This topic has 3 replies, 2 voices, and was last updated 3 years ago by
Long Nguyen.
-
AuthorPosts
-
April 6, 2021 at 4:53 PM #26994
Henri
ParticipantHi 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 #27002Long Nguyen
ModeratorHi 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 #27009ParticipantHi 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 #27015ModeratorHi,
Data type
TEXTis 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 -
AuthorPosts
- You must be logged in to reply to this topic.