ExtraList

The ExtraList module allows you to add fields to the native lists of dolibarr, from custom attributes or other fields not initially provided for in the list: selection of additional attributes available for the list addition of additional fields available in the native tables of the list or added in a joined table for the field highlighting of lines according to a selection criterion Displaying the categories associated with an element The fields thus added are then displayed in the field selector of the list and can be used like any other native field

Main page

From the main menu of the patas-monkey tools, the left menu extralist presents the list of customizable lists of the tool

Each block represents a customizable list containing: The management of additional attributes available The management of additional fields already added to the list The management of the criteria for highlighting the list The number at the end of the line indicates if there is already a setting made

Custom Attribute Management

After pressing the additional attribute selection icon, a screen displays the available fields

Pressing the first orange icon allows you to select the attributes available for the list you want to display Just click on the selector at the end of the line to activate or not the field in the list

Managing additional fields

After pressing the additional attribute selection icon, a screen displays the fields already configured and allows you to add new ones.

Pressing the second gray icon allows you to access the list of additional fields that have already been defined From the list, it is possible to modify an existing field (icon at the beginning of the line) or to delete it (icon at the end of the line)

Adding a new field

Pressing the (+) icon at the end of the title allows you to create a new custom field, it will then be possible to enter The label of the field you want to add The name of the field in the database with its prefix (such as s. for company, p. for project, ...), it is possible to use an alias (if you use a calculated field parameter). The type of fields in order to better manage the presentation format on the list

Editing an existing field

Pressing the style icon at the beginning of the line allows you to display the custom field settings.

Table join management

It is possible to add a SQL join to one or more tables if the field is not present in the tables used by the list.

Please note that this functionality requires knowledge of both SQL and the structuring of Dolibarr tables.

We offer paid support on our site https://www.patas-monkey.com/boutique to assist you with this functionality

How the new fields work

Once the configuration is done, it is possible to access the new fields from the native field selector of the list.

If there are fields added by ExtraList in the list, the field selection icon changes color Fields from additional attributes show the element from which they come Added fields are prefixed with "EL"

Management of highlighted lines

Pressing the (+) icon at the end of the title allows you to create a new highlight selection selection of fields that can be used for filtering the color used for highlighting the type of filtering (equal, different, less than, ...) the value associated with the filtering It is possible for the filter value to use predefined values ​​like #NOW# for today's date or #USERID# for the current user It is also possible to have several filters for the same list

Pressing the pen icon changes the highlighting

Managing the display of categories

It is possible to display the categories of the elements on the list by activating the check mark at the element setting level on the module index page.

A column displaying the category(ies) (in a tooltip then) associated with the item is selectable.