SIGN UP

A view with dynamic column number is possible?

By: Luis De Pau | Asked: 11/23/2022
Forums › Category: General questions › A view with dynamic column number is possible?
0 Vote Up Vote Down
Luis De PauLuis De Pau asked 2 years 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
0 Vote Up Vote Down
Victor Font answered 2 years 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 2 years ago

Thanks a lot Victor!
I will explore this solution.

0 Vote Up Vote Down
Bobby Clapp answered 2 years 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