Okay
  Public Ticket #3542298
Show form submissions to logged in users (user id, user email) that submitted them in forminator plugin
Closed

Comments

  • Haroon Mustafa started the conversation

    Hi,

    I hope your health is good.
    I'm using the Forminator plugin for ordering, quizzes, and contact can you tell me how to show her form submission details to the login, not all user details?

    Kindly help me

    Thanks

  •  1,819
    Miloš replied


    Hi Haroon,

    Thanks for showing interest in our Plugin and add-on.

    This will not be possible with our Free version of WpDataTables, because in the Lite Version you don't have any advanced filtering options.

    But if you wish to try with the full/premium wpDatatables, i will show you an example how you can filter the data using our Dynamic Placeholders, such as "current user ID" ,  "current user Email" and others.

    -

    You can do a custom workaround to show only the rows/submissions made by the currently logged user ID.

    ( This will be an example for "user ID", but you can use the same principle/logic for any other filter placeholder)

    Here is my 'test example' with just a very basic Form and one Text field.

    First you have to add a hidden field of type "user ID" to your Forminator Form.

    9710349866.png

    Now, any new submission any user makes, this field will store their user ID.

    Then, i just added a couple of submissions , the first one by my Admin user, which has user ID of 1;

    then i log as another user, with user ID of 11, and add another submission.

    By default, i have just left the field name without setting it up at the Form, and the table picks up this field as origin header of "hidden1".

    6733523157.png
    6107479450.png

    We can change the Displayed Header name to anything, i name it "user ID",

    and of course, you can hide that column from front-end users if needed, i just left it for demonstration purpose.

    -

    Now, how you can use this user ID field to pre-filter the table for front-end users,

    and also you can hide the filter with CSS - to prevent any user to "clear the filter" in order to see everyone's subbmisions.

    -

    This is a detailed example of using an Excel table - but you can use absolutely the same principle/logic for table linked with your Forminator Form.

    - On this Excel, we added a custom "user_id" column on the source Excel side, which you can hide if needed in our plugin from the front-end.   ( On your Form, you will already have that hidden user ID field as mentioned above);

    We will add a predefined filter value to that column, using a PlaceHolder "Current User ID";

    - Check that the filter type is set as "Text", as shown on this screenshot.

    8249361981.png

    - Here is how an example table linked to a source file looks before we make any changes, with visible filters above the table.

    7932387639.png

    And now, when we set the pre-filter, with Administrator logged in ( In our case, the user ID is 1), we only see rows matching that user ID.

    3633379684.png

    - (If you need more detailed information about using Place Holders in wpDataTables, here is our documentation about that https://wpdatatables.com/documentation/table-features/using-placeholders/);

    - The user_ID filter is still visible, which means, if someone changes/deletes this value on that Column Filter, they could see the whole table.

    We will hide it from the front-end with some custom CSS added in the "Customize" section of the main table settings.

    - It should be easy to do, depending on your knowledge of HTML and CSS.

    You have to find the correct selector using the browser inspector tool, add the style "display:none" property to it, and it will disappear from the front-end.

    On our example table, the custom CSS is :

    #table_1_5_filter_sections  {  
      display:none; }
    5537273103.png

    You can inspect your Table's HTML and check what is the selector;

    They always start as 

    #table_1_1_filter_sections

    #table_1_2_filter_sections

    #table_1_3_filter_sections And so on, so you just need to find the right selector filter ID, depending on how many column filters you will enable on that Table.

    2476319772.png

    - Now, the user_ID filter is gone from the front-end.

    8120839900.png

    You will also need to disable the "Clear Filters" option, so that the User can not clear all filters.

    2591876398.png

    - Optionally, you can hide the user_id column from the front-end, if needed, either using the column settings tab or the "column list" button from the back end Admin area.

    1618300341.png

    - If you need more details about this, don't hesitate to contact us further.


    And i just wanted to point out that you can try wpDataTables before purchasing

     on our sandbox Demo sites ( you can find links for the main plugin Demo,  

    as well as add-on Demos, in my signature),

    and there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

    Let me know if you have any additional questions. smile.png


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    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

  • Haroon Mustafa replied

    Hi Milos,

    Thanks for the help,

    How to hide this text  (filtered from 6 total entries)

    1750203312.png

    Thanks

  •  2,572
    Aleksandar replied

    Hello Mustafa.

    Milos is out of the office so I'll jump in.

    In order to hide that, please navigate to the Display tab above the table and disable this checkbox:

    5622867519.png

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    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