Saltcorn 0.2.2 - calculated many-to-many popups

By Tom Nielsen

Published on 13 October 2020

Saltcorn 0.2.2 has been released with these improvements:<o:p></o:p>

Many-to-many relationships: several small tweaks to enhance support for many to many relationships. This includes the ability to clone views and to control the labels for action buttons. There is further information on support for many to many relationships two wiki pages Modelling relationships and Interfaces for many-to-many relationships and a pack “Project-employee assignment” serving as an example.<o:p></o:p>

Filtering: a new view template built with the drag-and-drop builder provides support for flexible filtering of the content shown in views, with configurable drop downs and button toggles. See the wiki page for more details: Flexible filtering<o:p></o:p>

Security: several security enhancements. Passwords are now required not to match a list of common passwords, rate-limiting for login attempts by account and IP address and password reset tokens are encrypted in the database in compliance with best practices<o:p></o:p>

Modal popups: views can now appear in a pop-up modal boxes (also known as “lightboxes” some time ago). When configured correctly, this makes a huge difference to the user experience when editing or adding new rows to a table.<o:p></o:p>

Calculated fields: fields can now be calculated on the basis of other fields, given a formula written as a JavaScript expression. Calculated fields come in two varieties, stored and not stored depending on when the calculation is made. Plug-ins can supply functions that can be used in formulas. This is already used in a geocoding plug-in which allows you to convert addresses into latitude and longitude coordinates to display with the map plug-in. For more information, see the wiki page Calculated fields<o:p></o:p>

French translation: French translation by zinkh.<o:p></o:p>

In the last post, I promised user fields for this release, but they got bumped in favor of many-to-many relationships as several user requested this. The next development cycle will contain user field, as well as some more flexibility in the layout drag and drop builder.