Fabrik User Manual 0

• Allow user to add drop down option - Allow your form's users to add in
additional options to your form.
• Only add label - If no selected then the user has to enter both a value and a
label for the checkbox option they are adding. If yes selected then only a label
field is presented to the user the value of which is then used for the value and
label.
• Save new additions - If yes selected then the newly submitted option is stored
by the element, meaning subsequent users of the form will be able to select the
same value.
Advanced
• Separator - String separator to be used when formatting the data contained
within the form email plug-in. Leave blank to default to a new line.
Database join
The database join element is an extremely powerful element. It allows you to look up
data in another database table and to pre-populate a radio list or drop down list with the
46

---

data returned from the look up. E.g you could easily make a drop-down list containing all
of your Joomla articles, or a list of countries.
• Hidden - is the element shown on the form as a hidden field.
• Render join as - If not hidden do we render the element as a radio list or as a
drop-down?
• Connection - The Fabrik connection that contains the database table whose
data we want to look up to create the list
• Table - The database table that contains the look up data (populated once a
connection has been selected)
• Key - The database table field to use as the value for each of the list options
• Label - The database table field to use as the label for each of the list options
• Or Concat label - Alternatively you can select multiple fields from the database
table by supplying a mySQL concat stringhttp://dev.mysql.com/doc/refman/5.0/
en/string-functions.html#function_concat)
E.g.
lastname, ' ', firstname
• Joins where statement (sql) - A where statement which filters the returned
data.
E.g.
where 'published' = 1
• Apply where beneath - Select which user group AND BELOW will have the join
where statement applied to them
E.g.
If set to 'Administrator' then administrators and users below administrators
would only see published articles in the drop down list. Super administrators,
however, would see all articles regardless of their published state.
• Value of please select option - The text to record in the database if no option
selected from the element. Defaults to ''.
• Label of please select option - The label to show for the 'Please select' option
- if none entered this defaults to 'Please select'
• Eval - Should the default value be evaluated as a PHP expression
• Default - the default value to select when showing a new form
Add option in front end
The form is shown in an AJAX window, when it is submitted it posts the data to the
server via AJAX and then updates the initial drop-down element
• Add option in front end - If you have created a Fabrik table pointing to the
database table you selected for this database join element then you can decide if
you want your users to be able to add records into that form. The element will
then appear with an "add" button like this:
47

---

• Clicking on "Add" will open an AJAX Fabrik form as such:
Entering Holland and pressing "Save" will post the form via AJAX to the Fabrik
form processing code. Once processed the pop-up window will close and your
database join element will be updated to contain the new value:
• Popup window Y offset - The offset value in pixels from the top of the page
where the popup form should appear - use to nudge your popup form beneath
any JS menus at the top of your site template which might intefer with the
rendering of the popup window.
• Popup window width - the popup window width in pixels
• Link to joined record - Applies when in a detailed view, or if the element's
access levels mean that it is set to read only when in a form.
If this option is selected, then the read only value is encased in a link. This link
48

---

points to a detailed view of the record referenced by the database join element's
data.
• Front end select - a work in progress - please ignore for the time being
• Popup form - Select the form that corresponds to the database table the join is
connected to. This is the form that is loaded in the popup window when the
"add" button is pressed.
Date
Shows a date picker element:
• Width - The width of the date field - the value represents the number of
characters that can be displayed
• Hidden - sets the date to be rendered as a hidden field
• Eval - If set to yes then the value entered in the default field is taken to be a
PHP expression and is evaluated as such.
• Default - The default value to populate the element with. If the eval option is
selected then this should contain a PHP statement
E.g.
return 'default';
• Table date format - The formatting string to use when rendering the element's
data in the table view, see http://php.net/strftime for the full list of formatting
options
• Form date format - The formatting string to use when rendering the element's
data in the form view, see http://php.net/strftime for the full list of formatting
options
•
49

---