Support » Plugin: Forminator - Contact Form, Payment Form & Custom Form Builder » Show table with all submitted form to its owner

  • Resolved freelancejose

    (@freelancejose)


    Hello!

    I want to know how can I make a database query to show some fields of all the subbmitted forms form a user. I mean this:

    User A has sent four forms and I want to show some of the data fields in his dashboard, but only the data he owners.

    Same with user B, C… Each user can see only his data in a private dashboard.

    Please, can you help me?

Viewing 15 replies - 1 through 15 (of 17 total)
  • Plugin Support Kris – WPMU DEV Support

    (@wpmudevsupport13)

    Hi @freelancejose

    I hope you are doing good today.

    With this add-on https://wordpress.org/plugins/wpdatatables-forminator/ this should be possible.

    Kind Regards,
    Kris

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudevsupport13

    I’m testing it but I can’t make it works like I need. Looked in Google, but there’s not answer.

    Do you know how to configure it?

    Thank you.

    Plugin Support Predrag – WPMU DEV Support

    (@wpmudev-support1)

    Hi @freelancejose,

    Have you checked the Description page of the wpDataTables plugin, it has some instructions on how to use it?
    We also have some additional info on our Docs page that you can find here:
    https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#wpdatatables

    If you need further help with customizing this further you might need to hire a developer for custom development of your specific requirment.

    Cheers,
    Predrag

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudev-support1

    Yes, I have checked. Still the problem tahta I don’t know how to show only data to its owner.

    Also, can you tell me how can I make a single SQL query to select only forms submitted by a logged user and see the data sent. Is it possible?

    Thank you very much.

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @freelancejose

    You can use a similar workaround to this:

    https://gist.github.com/patrickfreitasdev/3ad0d0f4e13d3618cf8be210e8a48ac5

    We don’t store by default the user ID that submitted the form, but if you add a hidden field it has an option to collect the user ID, so you just need to check the current user ID and the hidden field.

    The shared code creates a shortcode so you just need to enter [my_test_page]

    But you still need to manage your custom fields and code.

    Best Regards
    Patrick Freitas

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @freelancejose

    To find more about the code, I used the Forminator API:

    https://wpmudev.com/docs/api-plugin-development/forminator-api-docs/

    Best Regards
    Patrick Freitas

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudevsupport12

    Yes, I have a hidden file to save in database the user ID. Only registered users can send a forms.

    The option with php is ok, I’ll check and work with it.

    What about query directly in database? I mean using these code:

    {“formId”:15,”formType”:”forminator_forms”,”formHasLeads”:null,”formChartType”:””,”fieldIds”:[“name-2″,”name-1″,”text-1″,”select-1″,”textarea-1″,”hidden-9″,”calculation-1″,”date_created_sql”]}

    Is it possible to filter any field with a determinated value? For example, name-1 = “x”. Which is the correct sintaxis if is possible?

    Thank you very much for your help.

    Plugin Support Nithin – WPMU DEV Support

    (@wpmudevsupport11)

    Hi @freelancejose,

    What about query directly in database? I mean using these code:

    You should be able to use the default wpdb global object regarding this as mentioned here:
    https://developer.wordpress.org/reference/classes/wpdb/

    The docs have examples using get_results, get_var which you could check and see whether it helps.

    Kind Regards,
    Nithin

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudevsupport11,

    I’m not a developer so is a little difficult for me some programming questions.

    I have found this https://wpmudev.com/forums/topic/forminator-shows-the-user-their-submission/

    I have installed it but it show me an error.

    Please, can you help me?

    Thank you.

    Plugin Support Adam – WPMU DEV Support

    (@wpmudev-support8)

    Hi @freelancejose

    The solution that you linked to is for a bit different purpose – it’s meant to allow logged-in users of specific user-role other than admin to go to “Formiantor -> Submissions” page and see their (and only their) submissions there.

    It shouldn’t give errors if the form ID is properly set in the code but if you are getting some error, we’d need to know what the error is specifically.

    You may need to turn WordPress debugging on first by setting following lines in “wp-config.php” file (above “/* That’s all, stop editing */” line):

    define( 'WP_DEBUG', true );
    define( 'WP_DEBUG_LOG', true );
    define( 'WP_DEBUG_DISPLAY', false );

    Once they are set, add your code again to the site to trigger the error. After you see the error on site, check the file “/wp-content/debug.log” and inside that file you should see more detailed error messages. Could you please let us know about those?

    Kind regards,
    Adam

    Thread Starter freelancejose

    (@freelancejose)

    Hello @ wpmudev-support8:

    Maybe I did not explain well what I need. I want users (registered) users to see all the data from the forms they submitted, so theyI can check when they has been submitted and what you have typed.

    The best look is like a WPDataTables but that plugin doesn’t have the option to filter by a certain field, hidden or not.

    See capture

    I would like to show only (LATIENDA), in the case that user is logged, only his data and not dat afrom other users (mensajero-web).

    I’m going to check your plugin again and what happen.

    Thank you so much.

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudev-support8,

    About error on addon to show logged users what their have submitted, is:

    Uncaught Error: Class ‘Forminator_Custom_Form_Model’ not found in

    public_html/wp-content/mu-plugins/wpmudev-forminator-user-submitted-forms.php
    on line 167

    Pleae, can you help me?

    Plugin Support Adam – WPMU DEV Support

    (@wpmudev-support8)

    Hi @freelancejose

    Thanks for response and additional explanation.

    Given the requirement to not only show “own data” to submitting user but also show it filtered, I’m afraid that “our code” that you found will not help either, even if we can fix the error that you are getting.

    Forminator itself doesn’t have such filtering bult-in and, in fact, what you see in “filters” on submissions page would only let these users – after they gain access to submissions – to decide whether to see or not some field and to do a search on them. I mean: it’s not persistent/permanent/pre-defined – you can’t upfront decide that they could only see certain fields and of certain values.

    There are some improvements for such filtering planned for future but I don’t have an ETA. For now, I’m afraid it would require more additional coding and it goes way into “custom development” area. If you need it urgently, you may need to consider hiring a developer that will create a custom add-on plugin for Forminator for you, based on Forminator’s API.

    Kind regards,
    Adam

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudev-support8,

    Thank you for your anwser.

    For the moment, is helpfull to show only data to logged user (his own data).

    Is it possible with that addon, after reolving the error, true?

    How can I resolve that error?

    Thank you.

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudev-support8,

    I found the file I need! Is this one and only need to adjust to show entries if the user logged in is the same that value in a hidden field.

    https://gist.github.com/patrickfreitasdev/9c8cab2e3309210fc83ba41dde63c075

    Thank you

Viewing 15 replies - 1 through 15 (of 17 total)
  • You must be logged in to reply to this topic.