Droptables: Parameters and Tricks

1. Parameters

To access the Droptables global parameters, go in Component > Droptables > Options

In the options, you can define:

 

  • The table categories accordion auto-close
  • Enable the Excel import/export
  • Choose the export format

 

droptables-paramaters

 

  • Enable the tooltip on cells
  • Enable the auto save in AJAX, otherwise you'll have a Save Modifications button
  • Enable table access: Enable table access limitation (ACL). Allows you to limit table editon permission based on Joomla user groups
  • Cell highlighting: Activate a color on cell mouse over to see on a first sight a cell content (Line Only/Column Only/Both)
  • Highlighting color: The cell highlighting hover color
  • Highlight font color: The cell highlighting font hover color
  • Highlighting opacity: The cell highlighting opacity level
  • Enable hidden right panel: Yes/No
  • Table sync periodicity: Table automatic synchronization delay for Excel file or Google Sheets
  • Enable database table: Yes/No

 

droptable-settings2

 

2. ACL permission

A Joomla ACL integration is available. You can now restrict access to action or table for table editors. This restrictions applies on all the tables.

 

access-tables

 

For example if you want an administrator user to access and edit only their own tables, set “edit” to denied and edit own to “Allowed”. You can also restrict:

  • The global configuration
  • The interface access
  • The tables creation
  • The tables deletion
  • Edition/own edition
Super admin user will always have all edition permissions for all tables and categories.

 

3. Load tables in a HTML custom module

Droptables is built to be used in every WYSIWYG editor field, you just need to have the content plugin to be called. Most of the time it’s activated by default.

If it’s not the case, like in the Joomla HTML custom module, you need to activate it like above.

 

table-in-module

 

In the option tab you need to set the option Prepare content to: Yes

 

4. Calculation

You have a basic calculation implementation in Droptables. Elements available are:

  • SUM, COUNT, CONCAT
  • MIN, MAX, AVG  
  • DATE, DAY, DAYS, DAYS360
  • OR, XOR, AND

To make a sum, type like this in a cell (UPPERCASE is mandatory): =SUM(A1;B2) or =SUM(A1:B2)

And you can configure the symbol for the cells calculation on number, money or date.

 

calculate-settings

 

  • Date formats: Set date format for date calculations
  • Symbol position: In order to make cell calculation on money, define the default position of the currency symbol
  • Currency symbol(s): In order to make cell calculation on money, define the default currency symbol
  • Decimal symbol: In order to make cell calculation, define the default decimal symbol
  • Decimal count: Number of digit after the decimal symbol
  • Thousand symbol: In order to make cell calculation, define the default thousand symbol