If you update to Joomla 3.8.10, please make sure that you either do a full GitHub update of Fabrik, or disable caching for your lists (in the Advanced settings) or turn off Joomla's System Cache setting. A change in Joomla's cache code in 3.8.10 required a fix in Fabrik, which will be rolled in to the next release, but is currently only available in GitHub.Dismiss Notice
We will be performing an update of XenForo (the forum software use on this site) this afternoon, Fri 8/17/2018. The forums will be unavailable for a (hopefully!) short time.Dismiss Notice
The Structure of Fabrik
The Function of Fabrik (top)The main function of Fabrik is to collect information from users through forms, send it to a database table, and then be able to present viewers with this information in various ways including:
- Lists - which display a list of all your records submitted through a particular form
- Visualizations - which take data from your database and visualize this through charts, maps, calendars and more
The Structure of Fabrik (top)To achieve this, Fabrik is predominantly made up of:
- Lists - which display all records collected from a form.
- Forms - which are what is used to collect these records.
- Groups - which are collections of elements present on a form.
- Elements - which are the individual fields present on a form and the column names in your database table
- Visualisations - which take data from your database and visualize this through charts, maps, calendars and more
- Packages - which allow you to create installable components from a collection of your Fabrik forms, lists and visualizations
- Connections - which allow you to connect Fabrik to the database that Joomla uses as well as other MySQL databases
- Scheduled Tasks - which allow you to define tasks that are run repeatedly at a given time and interval
Database Tables (top)As mentioned, and to gain the most out of Fabrik's feature set, you will also be working with database tables.
A database table, which contains the records collected through a form, is basically structured like a spreadsheet and is made up of rows and columns; rows representing each instance of data being submitted, and columns being the different elements being recorded.
Creating Your First List (top)The first step in creating this structure and getting Fabrik up and running is creating a list and associated database table.
To do this go to Lists > New and enter a 'Label' for your list - this can be changed later and will appear as the label at the top of your list.
When you are creating a list, you can also specify that when clicking the 'Save' icon for the first time it will also create an associated database table, ie the database table that will collect the records submitted through your form.
For organisational purposes, when creating a new list and database table, you might find it helpful to give the database table the same name as the list.
For example, you could create a new list called 'My New List' and during that process (in the 'Data' tab field 'Table name') also create a database table called 'coolprefix_mynewlist'.
It is recommended that you add a prefix to your Fabrik database tables so that you can differentiate them from other database tables in your database.
The database table should also not have any spaces in its name. If you want spaces between words or characters use underscores instead :
Incorrect: my tableCorrect: my_table
It is also recommended to use lower case characters.
Following these steps will set up:
- A list called 'My New List'
- A database called 'coolprefix_mynewlist'
- A form called 'My New List'
- A group called 'My New List'
- An 'id' element that has been added to the group 'My New List'
- A 'date' element that has been added to the group 'My New List'
mianjee likes this.