What’s New

Curious about great external services like Airtable? Well see how easy it is to connect to its API in Wappler! You can even use the now the improved Bootstrap Table Generator to create nice tabular data from your Airtable API! See Connecting to Airtable API for more info.

We have also improved the Database Manager to handle better Microsoft SQL Server and SQLite as well solved many issues reported by you.

The Image Processor is also extended with a new Cover Fit image resizing method to do smart image resize and even objects detection (nodeJS only)

Further more we have greatly improved our Server Connect and App Connect Data pickers and Formatters to handle better array notations and also field names with spaces in them!

Database Manager

• Improved renaming of the primary key field in MySQL, MS SQL Server
• Added new type bigIncrementals to allow creation of big incremental keys
• Allow conversion in MySQL from incrementals to bigIncrementals
• Improved SQLite and MS SQL Server support, now fetching full schema with primary and foreign keys
• Improved the automatic Server Connect Database connection creation under the PHP Server Model of MS SQL Server and SQLite connections

Server Image Processor 1.5

• Added brand new Cover fit action to the smart image resizing for both NodeJS and PHP! Now even with smart object detection with Entropy Attention algorithms in NodeJS Only
  The cover for resizes and crop an image smartly to make an image fit a bounding box and crop positioning algorithm.
  Also works in PHP - just without the object detection algorithms, put just a crop position

Bootstrap 4 Table Generator

• Added support for nested fields data structures, so you can easily use API services like AirTable
• Auto generate needed prefix fpr nested data structures
• Improved working with field names with spaces in them

Bootstrap 5

• Use the right badge classes for background and rounded pill
• Bootstrap 5 Tooltips - improved the data properties to use the new Bootstrap 5 syntax
• Use w-100 instead of the old .btn-block

App Connect

• Improved rendering of repeat regions and resetting values to null
• Changed behavior when having a null value with dmx-text and dmx-html attributes (will make element empty when value is null, previous it left the content unchanged)

App Connect Data Formatter

• Greatly improved working with arrays
• Added support for variables with spaces in their names that are well escaped as [‘long variable name’]

Server Connect

• Improved Data Bindings to show also nested data within arrays. When you pick a nested data automatic first array item of [0] is selected, just like in App Connect
• Improved document root detection for PHP in on some server configurations like using multiple document roots in Apache, with aliasses

Server Data Formatter

• Greatly improved working of formatters on array elements, those display now nicely in the dialog as a single line
• Improved selection of scoped fields like in Group By functions
• Fixed double global data display in Formatter dialog
• Improved escaping of the property values for collections

General

• Improved global shortcut key handling.

Bug Fixes

• Renaming an increment field fails
• No uploaded image name in DB yet there was an overwrite
• Page goes blank on save
• Ctrl+s on code view randomly deletes all content of the page
• Ctrl+Tab Not Working As Expected 3.7.3
• Error on saving file in code view
• Ctrl+z doesn't work on css files after saving
• BS5: Badge - Use background utility classes
• BS5: Tooltip settings have no effect
• Problems with NodeJS in Database Manager
• Unable to select Truncate String Formatter: Bug Report from transcoderm #2020-11-3_9-47-40
• BS5: Replace .btn-block with .w-100
• Data bindings from Paged Query not shown
• Error when setting value with "where"
• How Do I Use .where() in a Server Side Action to Return a Single Value?
• Server connect dynamic formatter with array index