• Resolved fredol

    (@fredol)


    Hello,
    I made a form with ninjaform with a field with 7 listcheckbox (SEM, TEM, Microscopte Optique, Synchrotron, DRX, AFM and Tomograph).
    The value of my form is:
    – MEB: 1
    – MET: 0
    – Microscopte Optique: 1
    – synchrotron: 0
    – DRX: 0
    – AFM: 1
    – Tomograph: 0

    I think this entry from my form is stored in the wp_nf3_field_meta data table.
    I can find the label of the 7 listcheckbox but I don’t know how to find the value (0 or 1). Does anyone know how the value is stored in the database?
    I thank you in advance.

    I copy the table entry:
    a:7:{i:0;a:8:{s:6:"errors";a:0:{}s:11:"max_options";i:0;s:5:"label";s:3:"MEB";s:5:"value";s:3:"meb";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:0;s:12:"settingModel";a:10:{s:8:"settings";b:0;s:15:"hide_merge_tags";b:0;s:5:"error";b:0;s:4:"name";s:7:"options";s:4:"type";s:15:"option-repeater";s:5:"label";s:161:"Options Ajouter Importer";s:5:"width";s:4:"full";s:5:"group";s:0:"";s:5:"value";a:3:{i:0;a:5:{s:5:"label";s:2:"Un";s:5:"value";s:2:"un";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:0;}i:1;a:5:{s:5:"label";s:4:"Deux";s:5:"value";s:4:"deux";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:1;}i:2;a:5:{s:5:"label";s:5:"Trois";s:5:"value";s:5:"trois";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:2;}}s:7:"columns";a:4:{s:5:"label";a:2:{s:6:"header";s:8:"Libellé";s:7:"default";s:0:"";}s:5:"value";a:2:{s:6:"header";s:6:"Valeur";s:7:"default";s:0:"";}s:4:"calc";a:2:{s:6:"header";s:16:"Valeur de calcul";s:7:"default";s:0:"";}s:8:"selected";a:2:{s:6:"header";s:45:"";s:7:"default";i:0;}}}}i:1;a:8:{s:6:"errors";a:0:{}s:11:"max_options";i:0;s:5:"label";s:3:"MET";s:5:"value";s:3:"met";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:1;s:12:"settingModel";a:10:{s:8:"settings";b:0;s:15:"hide_merge_tags";b:0;s:5:"error";b:0;s:4:"name";s:7:"options";s:4:"type";s:15:"option-repeater";s:5:"label";s:161:"Options Ajouter Importer";s:5:"width";s:4:"full";s:5:"group";s:0:"";s:5:"value";a:3:{i:0;a:5:{s:5:"label";s:2:"Un";s:5:"value";s:2:"un";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:0;}i:1;a:5:{s:5:"label";s:4:"Deux";s:5:"value";s:4:"deux";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:1;}i:2;a:5:{s:5:"label";s:5:"Trois";s:5:"value";s:5:"trois";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:2;}}s:7:"columns";a:4:{s:5:"label";a:2:{s:6:"header";s:8:"Libellé";s:7:"default";s:0:"";}s:5:"value";a:2:{s:6:"header";s:6:"Valeur";s:7:"default";s:0:"";}s:4:"calc";a:2:{s:6:"header";s:16:"Valeur de calcul";s:7:"default";s:0:"";}s:8:"selected";a:2:{s:6:"header";s:45:"";s:7:"default";i:0;}}}}i:2;a:8:{s:6:"errors";a:0:{}s:11:"max_options";i:0;s:5:"label";s:18:"Microscope optique";s:5:"value";s:18:"microscope-optique";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:2;s:12:"settingModel";a:10:{s:8:"settings";b:0;s:15:"hide_merge_tags";b:0;s:5:"error";b:0;s:4:"name";s:7:"options";s:4:"type";s:15:"option-repeater";s:5:"label";s:161:"Options Ajouter Importer";s:5:"width";s:4:"full";s:5:"group";s:0:"";s:5:"value";a:3:{i:0;a:5:{s:5:"label";s:2:"Un";s:5:"value";s:2:"un";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:0;}i:1;a:5:{s:5:"label";s:4:"Deux";s:5:"value";s:4:"deux";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:1;}i:2;a:5:{s:5:"label";s:5:"Trois";s:5:"value";s:5:"trois";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:2;}}s:7:"columns";a:4:{s:5:"label";a:2:{s:6:"header";s:8:"Libellé";s:7:"default";s:0:"";}s:5:"value";a:2:{s:6:"header";s:6:"Valeur";s:7:"default";s:0:"";}s:4:"calc";a:2:{s:6:"header";s:16:"Valeur de calcul";s:7:"default";s:0:"";}s:8:"selected";a:2:{s:6:"header";s:45:"";s:7:"default";i:0;}}}}i:3;a:10:{s:6:"errors";a:0:{}s:11:"max_options";i:0;s:5:"order";i:3;s:3:"new";b:0;s:7:"options";a:0:{}s:5:"label";s:11:"Synchrotron";s:5:"value";s:11:"synchrotron";s:4:"calc";s:0:"";s:8:"selected";i:0;s:12:"settingModel";a:10:{s:8:"settings";b:0;s:15:"hide_merge_tags";b:0;s:5:"error";b:0;s:4:"name";s:7:"options";s:4:"type";s:15:"option-repeater";s:5:"label";s:161:"Options Ajouter Importer";s:5:"width";s:4:"full";s:5:"group";s:0:"";s:5:"value";a:3:{i:0;a:5:{s:5:"label";s:2:"Un";s:5:"value";s:2:"un";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:0;}i:1;a:5:{s:5:"label";s:4:"Deux";s:5:"value";s:4:"deux";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:1;}i:2;a:5:{s:5:"label";s:5:"Trois";s:5:"value";s:5:"trois";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:2;}}s:7:"columns";a:4:{s:5:"label";a:2:{s:6:"header";s:8:"Libellé";s:7:"default";s:0:"";}s:5:"value";a:2:{s:6:"header";s:6:"Valeur";s:7:"default";s:0:"";}s:4:"calc";a:2:{s:6:"header";s:16:"Valeur de calcul";s:7:"default";s:0:"";}s:8:"selected";a:2:{s:6:"header";s:45:"";s:7:"default";i:0;}}}}i:4;a:10:{s:6:"errors";a:0:{}s:11:"max_options";i:0;s:5:"order";i:4;s:3:"new";b:0;s:7:"options";a:0:{}s:5:"label";s:3:"DRX";s:5:"value";s:3:"drx";s:4:"calc";s:0:"";s:8:"selected";i:0;s:12:"settingModel";a:10:{s:8:"settings";b:0;s:15:"hide_merge_tags";b:0;s:5:"error";b:0;s:4:"name";s:7:"options";s:4:"type";s:15:"option-repeater";s:5:"label";s:161:"Options Ajouter Importer";s:5:"width";s:4:"full";s:5:"group";s:0:"";s:5:"value";a:3:{i:0;a:5:{s:5:"label";s:2:"Un";s:5:"value";s:2:"un";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:0;}i:1;a:5:{s:5:"label";s:4:"Deux";s:5:"value";s:4:"deux";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:1;}i:2;a:5:{s:5:"label";s:5:"Trois";s:5:"value";s:5:"trois";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:2;}}s:7:"columns";a:4:{s:5:"label";a:2:{s:6:"header";s:8:"Libellé";s:7:"default";s:0:"";}s:5:"value";a:2:{s:6:"header";s:6:"Valeur";s:7:"default";s:0:"";}s:4:"calc";a:2:{s:6:"header";s:16:"Valeur de calcul";s:7:"default";s:0:"";}s:8:"selected";a:2:{s:6:"header";s:45:"";s:7:"default";i:0;}}}}i:5;a:10:{s:6:"errors";a:0:{}s:11:"max_options";i:0;s:5:"order";i:5;s:3:"new";b:0;s:7:"options";a:0:{}s:5:"label";s:3:"AFM";s:5:"value";s:3:"afm";s:4:"calc";s:0:"";s:8:"selected";i:0;s:12:"settingModel";a:10:{s:8:"settings";b:0;s:15:"hide_merge_tags";b:0;s:5:"error";b:0;s:4:"name";s:7:"options";s:4:"type";s:15:"option-repeater";s:5:"label";s:161:"Options Ajouter Importer";s:5:"width";s:4:"full";s:5:"group";s:0:"";s:5:"value";a:3:{i:0;a:5:{s:5:"label";s:2:"Un";s:5:"value";s:2:"un";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:0;}i:1;a:5:{s:5:"label";s:4:"Deux";s:5:"value";s:4:"deux";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:1;}i:2;a:5:{s:5:"label";s:5:"Trois";s:5:"value";s:5:"trois";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:2;}}s:7:"columns";a:4:{s:5:"label";a:2:{s:6:"header";s:8:"Libellé";s:7:"default";s:0:"";}s:5:"value";a:2:{s:6:"header";s:6:"Valeur";s:7:"default";s:0:"";}s:4:"calc";a:2:{s:6:"header";s:16:"Valeur de calcul";s:7:"default";s:0:"";}s:8:"selected";a:2:{s:6:"header";s:45:"";s:7:"default";i:0;}}}}i:6;a:10:{s:6:"errors";a:0:{}s:11:"max_options";i:0;s:5:"order";i:6;s:3:"new";b:0;s:7:"options";a:0:{}s:5:"label";s:10:"Tomographe";s:5:"value";s:10:"tomographe";s:4:"calc";s:0:"";s:8:"selected";i:0;s:12:"settingModel";a:10:{s:8:"settings";b:0;s:15:"hide_merge_tags";b:0;s:5:"error";b:0;s:4:"name";s:7:"options";s:4:"type";s:15:"option-repeater";s:5:"label";s:161:"Options Ajouter Importer";s:5:"width";s:4:"full";s:5:"group";s:0:"";s:5:"value";a:3:{i:0;a:5:{s:5:"label";s:2:"Un";s:5:"value";s:2:"un";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:0;}i:1;a:5:{s:5:"label";s:4:"Deux";s:5:"value";s:4:"deux";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:1;}i:2;a:5:{s:5:"label";s:5:"Trois";s:5:"value";s:5:"trois";s:4:"calc";s:0:"";s:8:"selected";i:0;s:5:"order";i:2;}}s:7:"columns";a:4:{s:5:"label";a:2:{s:6:"header";s:8:"Libellé";s:7:"default";s:0:"";}s:5:"value";a:2:{s:6:"header";s:6:"Valeur";s:7:"default";s:0:"";}s:4:"calc";a:2:{s:6:"header";s:16:"Valeur de calcul";s:7:"default";s:0:"";}s:8:"selected";a:2:{s:6:"header";s:45:"";s:7:"default";i:0;}}}}}

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hello @fredol, thank you for reaching out about your issue with Ninja Forms. The submissions are stored in the wp_posts and wp_postmeta tables. You will need to know two things: 1) how to write SQL code to search what you want to find in the database and 2) the form ID.

    Shaylee

    (@shayleehansen30)

    Thanks for pitching in, @respectyoda!

    Please feel free to contact our Customer Success team for more help. They’re helpful and eager to dig into this with you. Plus, reporting these issues to us helps us keep track and work on fixes that benefit not only you but everyone else who might run into the same snag. So, don’t hesitate to give them a holler!

    Thread Starter fredol

    (@fredol)

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘listcheckbox and SQL base’ is closed to new replies.