Okay
  Public Ticket #3333339
Not able to use Group Field
Closed

Comments

  • Eric started the conversation

    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?

  •  1,849
    Miloš replied

    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) :

    // 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;

    2032730928.png

    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 :

    7814520504.png

    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.

    2021767022.png
    2986857601.png

    And here is how this looks in my Example Table :

    1003532963.png

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • Eric replied

    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.

  •  1,849
    Miloš replied

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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