Per https://wordpress.org/plugins/wpdatatables-forminator/, I should be able to report the count of each distinct values counts of Yes and No in a Y/N field) in a field in a Forminator form, but while I followed the instructions religiously, I did NOT see any option to specify a Group Field. Can you point me to the right direction?
Now, support for Group fields is avalible with our integration as well.
Every Group field in form will be shown as separate column and all fields that are in group will be parsed as table layout (in each cell you will have separate table as is shown on Formiantor submissions).
Each field in group will be represent in the head of that table and entries from those fileds will be in the body of that table. If Repeater is enabled then those entries will be populated in table body as well.
Additionally, there is a hook available for filtering all the formatted entries (only for forms and quizzes) :
// Filter all the formatted entries
// $formattedEntry - Already formatted entry - string
// $field - Forminator_Form_Field_Model - object
// $entry - Forminator_Form_Entry_Model - object
function filter_formatted_entry($formattedEntry, $field, $entry){
// Example for form with id 1
if ($entry->form_id == 1){
// Example only for custom forms
if ($entry->entry_type == 'custom-forms'){
// Check is set meta data for current field
if (isset($entry->meta_data[$field->slug])) {
$entryValue = $entry->meta_data[$field->slug]['value'];
// Check is field type 'name' and that is not array
if ($field->raw['type']== 'name' && !is_array($entryValue)) {
// if $entryValue is John return null - it will not be shown in the table
if ($entryValue == 'John') $formattedEntry = null;
}
}
}
}
return $formattedEntry;
}
add_filter('wdt_forminator_filter_formatted_entry','filter_formatted_entry', 10, 3);
Please note that using hooks requires certain level of programming skills and included support refers only to advice.
-
Now, in regards to specifying a Group Field from our table that is pulling data from a Form,
the field should already be specified on its own.
For example, if i have this Form example, it is a Form for a person to input information about Guests they would bring to an Event;
we added a Group Field for a person to specify how many additional people they would bring in their Group,
and the user has to input some data for each member of the group, like name, Email , phone, etc;
This field we named "Your Guest's Information".
Then, if i add some Form submissions, with groups of people's data,
when i make a new Table, and choose this Form,
then select which Form Fields I am passing to the Table,
these Group Fields are already "marked as Group" in brackets, our plugin will recognise them :
As you see in the screenshot, any Fields that are set to be a "Group Field" from the Forminator Form,
our table will recognise them automatically as "Group" type, marked in brackets after the Field label.
And here is how this looks in my Example Table :
Let me know if that makes sense, and if you have any additional questions.
Per https://wordpress.org/plugins/wpdatatables-forminator/, I should be able to report the count of each distinct values counts of Yes and No in a Y/N field) in a field in a Forminator form, but while I followed the instructions religiously, I did NOT see any option to specify a Group Field. Can you point me to the right direction?
Hi, Eric.
Sorry for the delay.
Yes, in the latest version of our integration add-on with Forminator Forms 1.2,
our devs added the option to add Group Fields.
You probably saw this already in the Page of our wpDataTables integration for Forminator Forms.
"New field support – Group field
Now, support for Group fields is avalible with our integration as well.
Every Group field in form will be shown as separate column and all fields that are in group will be parsed as table layout (in each cell you will have separate table as is shown on Formiantor submissions).
Each field in group will be represent in the head of that table and entries from those fileds will be in the body of that table. If Repeater is enabled then those entries will be populated in table body as well.
Additionally, there is a hook available for filtering all the formatted entries (only for forms and quizzes) :
Please note that using hooks requires certain level of programming skills and included support refers only to advice.
-
Now, in regards to specifying a Group Field from our table that is pulling data from a Form,
the field should already be specified on its own.
For example, if i have this Form example, it is a Form for a person to input information about Guests they would bring to an Event;
we added a Group Field for a person to specify how many additional people they would bring in their Group,
and the user has to input some data for each member of the group, like name, Email , phone, etc;
This field we named "Your Guest's Information".
Then, if i add some Form submissions, with groups of people's data,
when i make a new Table, and choose this Form,
then select which Form Fields I am passing to the Table,
these Group Fields are already "marked as Group" in brackets, our plugin will recognise them :
As you see in the screenshot, any Fields that are set to be a "Group Field" from the Forminator Form,
our table will recognise them automatically as "Group" type, marked in brackets after the Field label.
And here is how this looks in my Example Table :
Let me know if that makes sense, and if you have any additional questions.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Ah OK, I mis-understood the Group Field in a plain vanilla form - it is a master-detail or parent-child relationship, not count(*) group by in SQL.
For now, I will happily use the Poll type form.
Hi, Eric.
No problem at all, i am happy that we helped to clarify on this subject.
Please don't hesitate to open new tickets for any other questions, we will be happy to advise.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables