Sophist
Guest
I am just starting a new Fabrik project using Joomla's new custom user fields.
So I will define some user fields.
Then I want to present a grid of input boxes where the columns are the fields and the rows are the users. Obviously some users will not have values for some fields.
Then I want to type values into the fields, and when user clicks Save to update existing values and insert new values into the prefix_fields_values table.
Let's assume that I can create a mySQL View to create the list of custom fields without having to create this using fabrik lists and joins etc, and import this view, the users table and the fields_values table into fabrik as lists.
Does fabrik then have the functionality to create the grid using the three lists as rows, columns and values?
(Hope I have explained this clearly?)
So I will define some user fields.
Then I want to present a grid of input boxes where the columns are the fields and the rows are the users. Obviously some users will not have values for some fields.
Then I want to type values into the fields, and when user clicks Save to update existing values and insert new values into the prefix_fields_values table.
Let's assume that I can create a mySQL View to create the list of custom fields without having to create this using fabrik lists and joins etc, and import this view, the users table and the fields_values table into fabrik as lists.
Does fabrik then have the functionality to create the grid using the three lists as rows, columns and values?
(Hope I have explained this clearly?)