Wordpress JetEngine & JetFormBuilder extract Repeater's serialized data to separate columns in database table
Budget: €30 – €250 EUR
Hi,
I use Wordpress with JetEngine Custom Content Type (CCT, not CPT) and JetFormBuilder.
Some of my forms contain a repeater field with a group of fields.
After submission, I want to save the form values to the CCT. Unfortunately, the values from the repeater are stored as a single JSON (or serialized?) to the database.
I'd need customization to store the values of each repeated field group as a separate value to columns in the database table.
The columns for the fields within the repeater already exist, but are empty.
When the repeater has 4 repetitions, the table should contain:
- 1 row with the original data
- 4 rows with the data extracted from the original one
It could also be some automation that reads the json and stores its values to a separate table by creating a new row for each repeated element, including the other values (which are not within the repeater) from the original form to the same table in their respective columns.
Can you do this?
Best R
I use Wordpress with JetEngine Custom Content Type (CCT, not CPT) and JetFormBuilder.
Some of my forms contain a repeater field with a group of fields.
After submission, I want to save the form values to the CCT. Unfortunately, the values from the repeater are stored as a single JSON (or serialized?) to the database.
I'd need customization to store the values of each repeated field group as a separate value to columns in the database table.
The columns for the fields within the repeater already exist, but are empty.
When the repeater has 4 repetitions, the table should contain:
- 1 row with the original data
- 4 rows with the data extracted from the original one
It could also be some automation that reads the json and stores its values to a separate table by creating a new row for each repeated element, including the other values (which are not within the repeater) from the original form to the same table in their respective columns.
Can you do this?
Best R