Change excel locale

This tutorial is going to provide a small code tweak in order to have your XSL Price Calculator working with formulas in different languages. You may be working at your localhost with your excel... Continue reading

Using product attributes and configuration for calculation

We have already shown you how to use your product custom fields to use the selected values at your calculator. In some cases, you may also want to use some other data regarding the actual product,... Continue reading

Code tip: Change datepicker translation for your calendar fields.

Calcbuidler uses the JQuery datepicker to attach calendar to your date fields. This datepicker shows by default in English, but you can easily change the texts adding your own translation. As... Continue reading

Creating new / editing database table

ListManager will handle any of your database tables. If your list doesn't have a database table created yet, then you will have to create a new one as a first step of the configuration. You can... Continue reading

Create a new list : Table configuration / Header

Once you have a database table able to store your data, the list manager creation is quite straightforward, you only need to click 'Add' at the main menu and introduce these... Continue reading

Table Configuration / Fields

From the Fields configuration page you will set up your fields/columns to be displayed. At the left bar you will see all the database columns, you can navigate through all of them in order to... Continue reading

Table Configuration / Display settings

Main options At this initial display configuration you can set general options for your list front-view: Default Order: you can add several columns and their default order... Continue reading

Table Configuration / Register action logs / Advanced

You may want to know the actions your users have performed with your list (records added, data modified, etc), or the searches that are launched. For this purpose you can enable at the advanced... Continue reading

History logs

History access This section will show action logs stored (as configured at the previous 'register action logs' section). Select one of the lists from the main page and click 'history... Continue reading

Export Data

The first section of this configuration page refers to the global pdf export users can export from your whole (or filtered) list from the front-end. Here you can choose if you prefer a portrait or... Continue reading

Publishing the front end manager

Once the table has been configured, it's time to publish at the front-end in order to give access to your users. They will be able to view, search, filter, or even add records and modify data... Continue reading

Removing tables

If you need to fully remove any table from your database (table structure together with all table data stored), you can select it from the main configuration page and click 'delete database table'.... Continue reading

Backend data view and options

Administrator can view stored data from the backend as well. Select one of your lists from the main view and click 'Manage data'. You will see the records already stored, with... Continue reading

TableManager migration Joomla3->Joomla4

No specific action is needed related to your database. As the table is already created, you only need to configure one ListManager list attached to this table. Configure its columns, the layout and... Continue reading

ListManager migration Joomla3->Joomla4

If you have a working installation of ListManager for Joomla3, the database structure needs to migrate in order to adapt to this new version. Select 'import data from Joomla 3' button in order... Continue reading

Main component page

This initial page shows the list of calculators you have created. You will find here options to search, order and paginate the list The top menu allows to create a new calculator, delete any... Continue reading

Import/Export calculators

With these options you can save a copy of any calculator and upload a previously exported Calcbuilder calculator, either from a Joomla 3 or a Joomla 4 site. Select any calculator from the list and... Continue reading

Calcbuilder migration Joomla3->Joomla4

In case you upgrade your Joomla 3 site to Joomla 4, you will also need to upgrade the Calcbuilder extension to its J4 latest version. Before making changes on your site, it's highly recommended to... Continue reading

Calculator configuration: Main settings

Header info This section only contains the Calculator name, and a description text you can introduce to clearly identify this calculator at the main... Continue reading

Calculator configuration: Form fields

The form fields will be the user inputs you will show at your front-end form. Type a name for your new field and click 'Add new field' button to add a new field to your calculator. It will show at... Continue reading

Calculator configuration: PHP Code

Inside this code area you will be able to specify the operations of your calculator in a manual way, using php valid syntax. This code area will be executed everytime frontend users click 'Calculate'... Continue reading

Calculator configuration: Javascript code

If you need to include any kind of script at your form, to perform additional dynamic actions, you can enter your script at javascript events tab. There you can place any javascript code needed, with... Continue reading

Calculator configuration: Spreadsheet

Creating Spreadsheet file You can use an excel with all your formulas of your calculator and to convert it to a working form on your site, you only need to configure a working spreadsheet that... Continue reading

Calculator configuration: Input form (Form Layout)

The form layout is set using the 'Form layout' option from the top toolbar. You will find an html editor for you to configure your preferred input view. You can freely add any html here, and you... Continue reading

Calculator configuration: Result (Exit Layout)

Once you have ready all your results, you only need to show them at the output section. If you go to 'exit layout' you will find again a html editor where you can introduce your output content. ... Continue reading

Calculator configuration: Print Preferences

PDF With these pdf settings you will set up the pdf export file that can be created with the calculator. Users will have available the download pdf link below the results once they have launched... Continue reading

Our clients' feedback