How to design an efficient Custom field form data table?

Ladies and gentlemen: the younger brother has such a demand. This is a custom form module, which has several common fixed fields (Optional). You can also add custom fields as needed. When the front-end page is displayed, these fields can be listed for users. I have implemented one before...

Daniel:
The younger brother has such a demand.

This is a custom form module, which has several common fixed fields (Optional). You can also add custom fields as needed.
When the front-end page is displayed, these fields can be listed for users.

Previously, I implemented a similar function to store all fields in an array, convert the array to a serialized string for storage, and traverse the field information at the front end to form a list.
The information entered by the front-end user matches the index and field and is saved to the database.
In this way, functions can be implemented, but there is a drawback: It is difficult to filter out suitable data by field when we prepare data statistics tools for operations in the future, such as mobile phones, I don't even know which users have filled in their mobile phones and which have not been filled in.

So I hope you can give me some advice. Design a more efficient form data table.

Reply content:

Daniel:
The younger brother has such a demand.

This is a custom form module, which has several common fixed fields (Optional). You can also add custom fields as needed.
When the front-end page is displayed, these fields can be listed for users.

Previously, I implemented a similar function to store all fields in an array, convert the array to a serialized string for storage, and traverse the field information at the front end to form a list.
The information entered by the front-end user matches the index and field and is saved to the database.
In this way, functions can be implemented, but there is a drawback: It is difficult to filter out suitable data by field when we prepare data statistics tools for operations in the future, such as mobile phones, I don't even know which users have filled in their mobile phones and which have not been filled in.

So I hope you can give me some advice. Design a more efficient form data table.