The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group
Show entries through Query MYSQL
Hi all. I ask the experts for help to build a query in MYSQL that allows to show the fields of a form that I select in a view but that each column is a field. I have tried but it has been impossible for me.
Example:
Select
Field 1,
Field 2,
Field N
From Form
Where form = N
View
Column 1 = Field 1
Column 2 = Field 2
Column N = Field N
Thank you very much for your help.
December 26, 2018 at 10:55 am
This is a very complicated request that can days to implement correctly. You want to build a dynamic display/view that doesn't exist until the fields are selected by a user, is that correct?
This requires a lot of custom coding to build a SQL statement dynamically, execute that statement through Ajax, then display the results. This is way beyond the scope of any help we can provide as unpaid community volunteers. If you have the budget, I suggest you hire a developer.
December 28, 2018 at 2:54 pm
Check this out it might help you understanding the dB structure
http://community.formidableforms.com/help-desk/wpdatatables-integration-with-formidablepro/
Discussion closed.