Fabrik User Manual 0

Robert
Bob
We've set the filter to be a search filter.
If this option is selected and the user filters on the string “Rob” then
the returned data set will contain only the record with “Rob” listed
If this option is not selected then the same filter would return “Rob”
and “Robert”
• Include in advanced search - Determine if the element is selectable as an
option in the table's advanced search feature.
• Required - If yes selected then a value has to be selected from the filter before
any data is shown in the table.
34

---

Table Column CSS
• Heading class - Specify a class name for the element's column heading e.g.
"myHeading"
• Heading CSS - Specify some css for the element's column heading e.g. "font-
color:red"
• Cell class - Specify a class name for the element's column e.g. "important"
• Cell CSS - Specify some css name for the element's column e.g. "font-color:red"
Calculations
Calculations are shown at the bottom of the table, and contain mathematical operations
performed on the element's data.
• Sum the column total - If yes select then the elements data is added up
• Sum access - Determines which user group can see the sum
• Split on - Specify an element to split the sum calculations into.
◦ E.g.
If we have a table:
Name
Surname
Age
Rob
Clayburn
29
Alice
Bird
25
Stan
Clayburn
80
And we choose to split the sum calculation on “surname” then we
would get 2 results:
sum Clayburn = 109
sum Bird = 25
• Average the column total - If yes selected then the average value of the
element's data is calculated
• Average access - Determines which user group can see the average
• Split on - Same principal as the sum split on option
• Column median -Calculate the element's data's median value
• Median access - Determines which user group can see the median
• Split on - Same principal as the sum split on option
• Count records - Count the total number of records found
• Count value - Only record's whose element data match the value entered here
will be included in the count total
• Count access - Determines which user group can see the count
• Split on - Same principal as the sum split on option
35

---

Validations
Validations ensure that the data entered by your uses match what you require from
them. In Fabrik validations are plug-ins. If you are technically included you can write a
validation plug-in to match your particular need. There is an example validation rule with
fully commented code in /components/com_fabrik/plugins/validationrule/example.
If validations fail then they raise an warning next to the element.
Is alpha-numeric
This ascertains if the submitted data is alpha-numeric.
• Error message - The message to display next to the element if the validation
fails. This text should explain why the validation failed and what steps the user
should take to remedy the error.
• Condition - A PHP expression which if returns false, means that the validation is
not run.
36

---

Is email
This ascertains if the submitted data is a valid email address.
• Error message - The message to display next to the element if the validation
fails. This text should explain why the validation failed and what steps the user
should take to remedy the error.
• Condition - A PHP expression which if returns false, means that the validation is
not run.
• Allow empty - If set to yes the validation will allow the user not to enter an
email address, if set to no then an empty value will cause the validation to fail
37

---

Is not
This ascertains if the submitted data is not a specific value.
• Error message - The message to display next to the element if the validation
fails. This text should explain why the validation failed and what steps the user
should take to remedy the error.
• Condition - A PHP expression which if returns false, means that the validation is
not run.
• Is not - value that the submitted data can not be for validation to pass.
38

---

Is Numeric
This ascertains if the submitted data is a numeric value.
• Error message - The message to display next to the element if the validation
fails. This text should explain why the validation failed and what steps the user
should take to remedy the error.
• Condition - A PHP expression which if returns false, means that the validation is
not run.
• Allow empty - If set to yes the validation will allow the user not to enter an
email address, if set to no then an empty value will cause the validation to fail
39

---

Is Unique
This ascertains if the submitted data has not previously been submitted by the form
(requires that the form is set to record in database)
• Error message - The message to display next to the element if the validation
fails. This text should explain why the validation failed and what steps the user
should take to remedy the error.
• Condition - A PHP expression which if returns false, means that the validation is
not run.
• Case insesitive search - When searching for exisiting data should the search
be case sensetive or not?
Not empty
40

---