Wordpress JetEngine & JetFormBuilder extract Repeater's serialized data to separate columns in database table

Job ID: 35027636

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
Related categories: PHP WordPress MySQL JSON WordPress Plugin