Fabrik User Manual 0

Table settings
• Use static map -
◦ Yes - A Google static map image will be shown, indicating the marker
location
◦ No - The raw coordinates will be shown
• Map width- the static map witdth in pixels
• Map height the static map height in pixels
Cascading Drop down
Form example
In the above image the region dropdown is the cascading dropdown and the 'country'
dropdown is a database join which is used as the cascading dropdown's 'watch element'.
Selecting a country will trigger the loading icon to the right of the region dropdown and
will fire an AJAX call to populate the region list with regions belonging to the selected
country.
Administration settings
68

---

Options
• Connection - the Fabrik connection which contains the table we want to use for
the dropdown's data
• Table - the Fabrik table that we want to use for the dropdown's data
• ID - the Fabrik table element that contains the value we want to use for each
dropdown option - this is the data that is recorded in the database and should
normally be the table's primary key.
• Label - the Fabrik table element that contains the data used for the option label
- this is the text that the user sees for each of the drop down options.
Advanced
• Where query - filter the drop down options with an additional where query.
Don't include 'where' in the text you enter here - e.g "active = 1"
69

---

• Hidden - is the element hidden
• Show please select - Add a "please select" option to the top of the drop down's
options
• Eval - Do you want to evaluate the default value
• Default - The default value to use when adding a record.
Front end
• Link to joined record - If the element is read only and this option turned on
the the read only text is turned into a link which points to a detailed view of the
joined record. In the front end example above this would take you through to a
detailed view of a region record.
Calculation
The calculation element allows you to perform matematical calculations when the form is
submitted or when the table's data is shown. If you want to perform calculations that are
shown on the form as soon as users enter data (and before they submit the form) then
you will need to create a normal field and add a JavaScript action to that element.
Administration settings
• Hidden - is the element rendered as a hidden field
• Width - the field width
• Calculation - the PHP code you want to use for the calculation. It MUST return
something and MUST be valid PHP code - use placeholders to access the form's
data.
• Format string - Applies the PHP sprintf function to the calculation -
http://php.net/sprintf, when displaying teh data in the table or detailed view.
• Only Calc on Save - If set to yes the the calculation is run when the form is
submitted. If set to no then the calculation is applied each time the table or
detailed view is rendered.
70

---

Colour Picker
Form example
Click on the large coloured square to open up the colour picker window.
Use the sliders to create the colour, or click on the small palette colours to automatcially
load a colour.
Administration settings
There are no admin settings for this plug-in.
Yesno
The yes no element is a short cut to the having to manually set up a radio button with a
standard 'yes' or 'no' options. It also has the advantage of automatically showing icons
for the results in the table view
Form example
71

---

Table example
Administration settings
• Default - should the default selected option be 'yes' or 'no'.
Parent / Child elements
When creating a new Fabrik table whose database table has already been used to create
a previous Fabrik table, Fabrik applies a concept called parent/child elements.
What happens is that Fabrik will create the new table's elements with the same settings
as those of the original Fabrik table's elements.
These new elements are called child elements and are 'linked' to the original parent
element.
Upon editing and saving the parent element all of its child element's will be updated with
the same settings.
When you edit the child element, you will notice that the usual edit element form does
not appear. Instead you see a notification about the element being linked, a link to edit
the parent element, and a check box to unlink the child element:
72

---

To disable the parent/child relationship click on the "unlink" check box. The usual edit
element form will fade in and when you save the element, it will no longer be linked to
the parent element. Once unlinked the child element can not be linked back to its parent
element.
Tables
Tables allow you to display data collect by your forms, or from existing database tables.
Fabrik tables should be considered as views onto the data contained within MySQL
tables. This is because with Fabrik tables you can:
• Create joins between database tables
• Have multiple Fabrik tables pointing at the same database table.
• Each Fabrik table may then apply its own access levels and filtering to alter the
display of the underlying database table's data.
To access the tables' section select components->fabrik->tables. You will see a page
containing a list of your Fabrik tables similar to the diagram below:
Each table can be selected with the check box to the left of its name. Once selected it
can be altered by clicking on the buttons in the top right hand corner:
• Published - sets the state of the table to published (note that the table's start
and end publish dates still need to be correctly set up for the form to be visible
to your users)
• Unpublish - sets the tables' state to unpublished
• Copy - copy's the table
73

---