A view with dynamic column number is possible?

By: Luis De Pau | Asked: 11/23/2022
ForumsCategory: General questionsA view with dynamic column number is possible?
Luis De PauLuis De Pau asked 1 year ago

Hello!
I have a form that needs to be filled on regular basis. I need to create a vew that shows the answers in columns like this:
Example So the question is if something of sorts can be made. 
 

Thanks for any idea on how to do this!

2 Answers
Victor Font answered 1 year ago

Showing multiple entries for a single user in a tabular format is possible with custom SQL or with a SQL VIEW but it can be complicated. You first have to create a functional SQL SELECT statement to return the data you need. When the SQL Statement works as expected, you use it with the frm_view_order hook. This hook allows you to completely abandon Formidable's generated SQL in favor of your own. You can even get the results of a SQL view.

Luis De PauLuis De Pau replied 1 year ago

Thanks a lot Victor!
I will explore this solution.

Bobby Clapp answered 1 year ago
You could create a table view, convert it to classic, then wrap the specific <td>'s with [if x equals="value][/if x]

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right