Use Formit Submissions in a live graph

[halftrainedharry]

FormItSaveForm (database table modx_formit_forms) is not ideal to query the data, as all the form data is saved as JSON in the column values.

You probably have to loop through all the rows of the correct form (column form), decode the JSON and tally up the submissions.

Here is a link to some similar code, that you could adapt to your needs.

Json to placeholders

Here is some code to loop the forms: <?php //load FormIt package $base_path = $modx->getOption('core_path') . 'components/formit/'; $modx->addPackage('formit', $base_path . 'model/'); //create a query and restrict the rows by the 'form' column $q = $modx->newQuery('FormItForm'); $q->where(array( 'form' => 'test retriever' )); $output = ''; $saved_forms = $modx->getCollection('FormItForm', $q); foreach($saved_forms as $saved_form){ $values_json = $saved_form->get('values'); //read valu…