Release Notes April – June 2021
PDFs, spreadsheets, images, and CSV/text files can be fully customized and optionally bundled together for comprehensive reports. Then, these reports can be downloaded or emailed with attachments, utilizing mail merge capabilities. Additionally, users can upload CSV files for batch data entry, staging and processing.
For dashboard builders, this is a milestone release, allowing seamless editing and debugging of AmiScript at any number of touch points while concurrently interacting with the dashboard.
End User Features – Reporting:
• Sending emails with attachments and mail merge capabilities.
• Export/Import CSV files – Now users can download, edit and upload bulk data.
• Customized file naming for Excel, CSV and text files
• PDFS support cell-level styling in tables, providing for rich visual data formatting.
• Create zip files for bundling reports – Now complex reports with varying file types can be bundled into a single file for convenience.
• Forms can now have embedded password input fields.
Styling:
• More style options for Legend checkboxes.
• Form checkboxes can be styled with customized background color, check color and border color.
• New calendar styles to show only one month at a time with a fresh new look.
• Chart label font style (bold, italic etc).
• Table and Trees support Cell-level Horizontal Padding.
Developer Mode:
• Searching code blocks now highlights in scrollbars for quickly identifying matches
• Search box in code editor (ctrl + f).
• Search & Replace Box in code editor (ctrl + f+f).
• Support custom menus in the top menu bar.
• Custom Context Menu Editor is now non-modal – Now users can edit multiple context menus
simultaneously.
• Improved Relationships to run only if target panel is visible or bring to front is set
• Overrides for TRUE/FALSE in relationships – This handles edge conditions for specialized database adapters.
External Adapter Support:
• Updated the Mongo Adapter to support SSL.
• Better Mongo support when no credentials are provided.
• Add option for MongoDb to set the target database.
AMIScript:
• Support arbitrary types in AMI tables – For example, now tables can have columns of type Map, List or Set enabling complex data packing.
• in (…) clause supported natively throughout amiscript. For example, if(i in (1,2,3)) {…}
• Added SpreadSheetBuilder class –
Now users can build excel spreadsheets with multiple tabs representing varied sets of data.
• Added TablePanelColumn::autosize() –
Programmatically auto-size a column (based on data content).
• Added TablePanel::autosizeAllColumns() –
Programmatically auto-size all of a table’s columns.
• Added TablePanel::getVisibleRowsCount() –
Return the number of non-hidden/non-filtered rows.
• Added sendEmail() –
Kicks off a job to send emails and continue with script immediately.
• Added sendEmailSync() –
Sends an email, pausing script until the email is sent.
• Added PdfBuilder::setCellStyle and clearCellStyles –
Now cells can be individually styled when producing a PDF report.
• Added sleepMillis(…) –
Pause the running AMIscript. This should only be used for testing, etc.
AMI DB:
• Add DIAGNOSE INDEX –
Ability to investigate the amount of memory an index is using (along with the existing DIAGNOSE TABLE, DIAGNOSE COLUMN, etc).
• Added setlocal number_format and decimal_format – For a local session, determines how numbers are formatted on the terminal.
• timeout=nnn in jdbc adapter –
The AMI JDBC adapter can now be configured to timeout if the AMIDB does not respond after a specified period of time.
If you have any questions about these
new features or would like a demo,
please email info@3forge.com.