Show table with all submitted form to its owner
-
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?
-
I hope you are doing good today.
With this add-on https://wordpress.org/plugins/wpdatatables-forminator/ this should be possible.
Kind Regards,
KrisI’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.
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/#wpdatatablesIf you need further help with customizing this further you might need to hire a developer for custom development of your specific requirment.
Cheers,
PredragYes, 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.
- This reply was modified 3 years, 3 months ago by 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 FreitasTo find more about the code, I used the Forminator API:
https://wpmudev.com/docs/api-plugin-development/forminator-api-docs/
Best Regards
Patrick FreitasYes, 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.
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,
NithinI’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.
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,
AdamHello @ 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.
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.
- This reply was modified 3 years, 3 months ago by freelancejose.
About error on addon to show logged users what their have submitted, is:
Uncaught Error: Class ‘Forminator_Custom_Form_Model’ not found inpublic_html/wp-content/mu-plugins/wpmudev-forminator-user-submitted-forms.php
on line 167Pleae, can you help me?
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,
AdamThank 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.
- This reply was modified 3 years, 3 months ago by freelancejose.
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
- The topic ‘Show table with all submitted form to its owner’ is closed to new replies.