What's new in MessLess Inventory 8.0
Dec 9, 2009
- New field with support of formatting (RTF). Store and edit full-fledged text with any fonts, highlighting, colour, pictures and so on.
- Graphs. Version 8 features a new system of making up graphs and reports, allowing you to display 9 different types of graphs, combine them, make up dynamic graphs and display all of them right on the main screen of the program.
- Reports. Now you can more easily get the total and subtotal for the selection of records, group it by any field and execute any operation or a script for the selection.
- Highlighting with colour by rules. It is now possible to specify different colour schemes depending on fields’ values for tables and reports. For example, you can highlight non-paid orders with red, and paid orders – with green.
- Entirely reviewed and simplified mechanism of importing data from external sources (Internet pages, Outlook, text documents and so on). To import, for example, actual currency rates to your database, you even do not have to write scripts.
- Possibility of work with external database. Now it is very easy to work with an external Access or Excel database. You can input data to the external database, as well as read it from there.
- Managing folders. You can block standard operations for every folder – manual dragging of records, creating or deleting records when pressing the Delete key and so on. You can also link every type of records to a specific folder so that when a record created from the Add menu, it is automatically placed to a necessary folder.
- Field for working with files. Now you can store files of any type right in the record, in a specific field. In contrast to usual attachments, using one or several fields will allow you to structure files.
- Managing work over the network with scripts. Using specific commands in scripts, you can send messages over the network, break connections, make a database available over the network.
- Mask for simple fields. For example, you can define the “###-XX” mask to allow entering only three digits and two letters in the specified field.
- A possibility to specify color, picture and transparency for table background (by, default, dark grey) is added
- Execution of queries for regular users (not administrators) is optimized
- A possibility to change passwords by regular users (not administrators) is added
- A possibility to specify a variant for opening a record from the "Find Records" dialog, either in a new window or in the main program window, is added (the "View > Advanced…" menu)
- A possibility to grey out text fields blocked for editing is added (the "View > Advanced…" menu)
- Work with huge forms with many tabs is optimized
- Reliability of program work by the network is significantly increased.
- Maximum number of queries to one database is increased to 1024.
- Support for formatting numbers of the "math #00.00" type is added, for adding leading zeros to a number.
- New Find/Replace dialog with AND/OR support.
- Predefined variable [$old_value] for the “On Change” script - it stores previous value of a field.
- Mathematics – new operator: % - returns residue of division.
- Improved backup.
- Printing – possibility to print each group on a new page.
- New actions palette.
- “Real Delete” action
- New “On software close” timer – allows executing a script then user tries to close the software.
- Text Button: An entered value can be copied to the [$input] variable.
- Restoring records from the recycle bin to the source folder.
- A possibility to specify a layout separately for every folder — a list of records, a list and form, only form — is added.
- New Query and Report wizard.
- Additional actions for fields are added that can be re-assigned (pressing Enter, right-click and so on).
- A possibility to mark fields as system is added. The fields become not available to the user at search, manual sorting and so on.
- Improved Report Style Editor
- Custom Export Templates are split into more convenient Send e-mail, Create a Web Page, Copy to Ms Word, Copy to Clipboard and Export to text file templates.
- New operations for formatting text are added to the existing 20 ones: MD5 – get hash of a string, and SIZE – get the length of a string.
- A possibility to clone folders is added.
- Fast static formulas (the same for all records) are added.
- A possibility to prohibit a database user to display or hide specific columns in a table is added.