Mapping JSON Field Content to Multiple Table Columns
-
Hi, I just want to say I love your plugin and it has helped me SO MUCH!
I am just a little bit stuck as a cross road.
Currently my submissions from CF7 comes out in one field and in JSON format.
Example:
{"username":"Brandon","the-field":"Welcome, ! It's great to see you here.","company-name":"test","company-address-line":"test","installer-name":"test","installer-phone":"","installer-email":"","installer-registration":"","coc-number":"brnadontest040720221","client-name":"Brnadon test","site-address-line":"","erf-number":"","plot-number":"","building-name":"","gps-coordinated":"","enegizer-type":"","serial-number":"","date-of-purchase":"","peak-voltage":"","voltage-under-500ohm-load":"","noise":"","joule-reading":"","date-recorded":"","meter-manufacturer":"","meter-model":"","meter-serial-number":"","open-circuit-test":["Yes"],"live-earth-short-test":["Yes"],"alarm-trigger":["Yes"],"alarm-trigger-2":["Yes"],"step2-long-label-1":["Yes"],"step2-long-label-2":["Yes"],"step2-long-label-3":["Yes"],"step2-long-label-4":["Yes"],"step2-long-label-5":["Yes"],"step2-long-label-6":["Yes"],"step2-long-label-7":["Yes"],"energizer-1":["Yes"],"energizer-2":["Yes"],"energizer-3":["Yes"],"energizer-earth-grid":["Yes"],"lightning-protection":["Yes"],"auxiliary-devices":["Yes"],"electric-fence-cable":["Yes"],"energizer-housing":["Yes"],"electric-fence-bracket-1":["Yes"],"electric-fence-bracket-2":["Yes"],"electric-fence-bracket-3":["Yes"],"fixing-for-brackets":["Yes"],"electric-fence-wire-1":["Yes"],"electric-fence-wire-2":["Yes"],"electric-fence-wire-3":["Yes"],"tension-point-1":["Yes"],"tension-point-2":["Yes"],"clamps-ferruls-1":["Yes"],"clamps-ferruls-2":["Yes"],"warning-signs":["Yes"],"conduit":["Yes"],"step4-long-label-1":["Yes"],"step4-long-label-2":["Yes"],"step4-long-label-3":["Yes"],"step4-long-label-4":["Yes"],"step4-long-label-5":["Yes"],"step4-long-label-6":["Yes"],"step4-long-label-7":["Yes"],"step4-long-label-8":["Yes"],"step4-long-label-9":["Yes"],"step4-long-label-10":["Yes"],"step4-long-label-11":["Yes"],"step4-long-label-12":["Yes"],"step4-long-label-13":["Yes"],"step4-long-label-14":["Yes"],"step4-long-label-15":["Yes"],"step4-long-label-16":["Yes"],"step4-long-label-17":["Yes"],"step4-long-label-18":["Yes"],"step4-long-label-19":["Yes"],"step4-long-label-20":["Yes"],"step4-long-label-21":["Yes"],"step4-long-label-22":["Yes"],"step4-long-label-23":["Yes"],"step4-long-label-24":["Yes"],"step4-long-label-25":["Yes"],"name-1":"","position-1":"","for-on-behalf-of-1":"","address-1":"","sign-1":"","date-1":"","name-2":"","position-2":"","for-on-behalf-of-2":"","address-2":"","sign-2":"","date-2":"","step-6-company-name":"","step-6-company-address-line":"","step-6-installer-name":"","step-6-installer-phone":"","step-6-installer-email":"","step-6-installer-registration":"","step-6-coc-number":"","step-6-client-name":"","step-6-site-address-line":"","step-6-erf-number":"","step-6-plot-number":"","step-6-building-name":"","step-6-gps-coordinated":"","is-the-electric-fence-complaint":["Yes"],"cf7mls_step-1":"","comments-on-electric-fence":"","comments-on-parts-of-electric-fence-not-covered-in-coc":"","cf7mls_step-2":"","cf7mls_step-3":"","cf7mls_step-4":"","upload-site-layout":"","upload-site-wiring-diagram":"","upload-photo-1":"","upload-photo-2":"","upload-photo-3":"","upload-photo-4":"","upload-photo-5":"","save-to-coc-cloud":"","save-to-device":"","send-coc-to-client":"","send-coc-full-document-to-client":"","send-sla-document-to-client":"","cf7mls_step-5":"","item-1":"","item-2":"","item-3":"","item-4":"","item-5":"","item-6":"","item-7":"","item-8":"","item-9":"","item-10":"","item-11":"","item-12":"","item-13":"","item-14":"","item-15":"","upload-photo-6":"","upload-photo-7":"","upload-photo-8":"","cf7mls_step-6":"","cf7mls_step-7":""}
Is there a way for me to map these into a new Table with each data having their own column?
Kind regards
Brandon
- The topic ‘Mapping JSON Field Content to Multiple Table Columns’ is closed to new replies.