
Rollbase Update: December 12th 2011
Contents:
- External Tables as Rollbase Objects
- Customize Rollbase CSS
- PDF Forms as Document Templates
- Run Scheduled Batch Jobs with Object Script Code
- Filter Views Based on SQL Expressions
- Filter Views Using Pre-defined Date Range Helpers
- Page-level Tabs in Edit and New Pages
- Workflow Action Enhancements: Trigger Invocation and Status Change Pages
- REST API Enhancement: Composite Objects
- REST API Enhancement: JSON Output
- Automated Private Cloud Installer for Windows
- Change of Address: 14435 C Big Basin Way, #211, Saratoga, CA, 95070
External Tables as Rollbase Objects [Private Cloud Only] Rollbase Private Cloud can now be used to integrate directly with other database tables and treat them as Object definitions. By pointing Rollbase to any table in your database you can create an "External" Object definition in Rollbase to represent that table. These External Objects have almost all of the same features that native Rollbase Objects have, yet the actual data remains stored in that same table, rather than in Rollbase-native tables. In this way you can integrate Rollbase will database tables used by other applications, and use this feature to quickly migrate any legacy enterprise software application to a cloud-native solution without changing your database schema or migrating your data.
Customize Rollbase CSS Ever wanted to upload your own CSS to make your Rollbase applications look completely customized? Now you can upload any CSS file as a Rollbase Hosted File and assign that CSS file in your Account Settings to make use of it throughout your account. We have also published Appendix D in Rollbase in Action: CSS Classes Used in Rollbase User Interface.
PDF Forms as Document Templates Rollbase now supports PDF forms as Document Templates. Once uploaded you can define a mapping between fields in the form and any of your Rollbase Object's fields. In this way, when this document template type is used Rollbase will generate a PDF and automatically fill in its form fields based on this mapping. [This feature uses a third party PDF generation tool from Aspose that must be licensed for use in Private Cloud environments].
Run Scheduled Batch Jobs with Object Script Code A new Batch Job type called "Data Maintenance" has been added that allows you to schedule a recurring task to run specific Rollbase Object Script code on every record of a selected Object type. This allows the creation of periodic data maintenance or other highly customized recurring activities that need to be performed on your data on a periodic basis.
Filter Views Based on SQL Expressions In addition to being able to filter Views on custom boolean expressions you can now go further and define your own SQL-style formula expressions to filter views. Create or edit any View component, scroll down to the "View Filters" section and select the "Formula" option in the "Filter Conditions" field. This will allow you to construct any SQL expression, using merge fields and other Rollbase helpers, that evaluates to true or false to determine whether each record should be included in the View.
Filter Views Using Pre-defined Date Range Helpers Rollbase Views can now be easily filtered by pre-defined date ranges such as Current Year, Previous Year, Next Year, Current Quarter, Previous Quarter, Next Quarter, Current Month, Previous Month, Next Month, This Week, Last Week, Next Week, Today, Yesterday, Tomorrow, Last 7 Days, Last 30 Days, Last 60 Days, and many more. Create or edit any View component and scroll down to the "View Filters" section. If you are filtering by ALL, OR or Expression, you can select any one of these options from the "Dates Interval" field.
Page-level Tabs in New and Edit Pages Up until recently there was no way to enable page-level tabs in Edit or New pages, only View record pages. Rollbase now allows you to enable tabs in New and Edit pages as well.
Workflow Action Enhancements: Trigger Invocation and Status Change Pages Now all Workflow Actions allow you to optionally select one or more Triggers that should be run when that action is invoked. In this way you can run custom business logic even when no record-level data changes occur. In addition, all Status Change pages are now optional when using Workflow Actions to move records from one Status to another. To access these new features, create or edit a Workflow Action.
REST API Enhancement: Composite Records Output Rollbase now supports composite object record calls via the REST API. When retrieving an individual record or group of records via REST, you can now specify how many levels deep you would like to retrieve related records as well. The returned output will be structured hierarchically. For more information see Chapter 15 of Rollbase in Action.
REST API Enhancement: JSON Output Now in addition to XML format, REST requests to retrieve an individual record or group of records can be returned in JSON format. For more information see Chapter 15 of Rollbase in Action.
Automated Private Cloud Installer for Windows We recently partnered with Install Solutions Inc to create an automated Private Cloud installer for our Windows users. This installer is now available for download in the Private Cloud Downloads area of the Rollbase website. The installer detects whether or not you have installed Rollbase Private Cloud yet. If you have a previous version of Rollbase Private Cloud installed, it will prompt you to upgrade to the latest version if one is available. If you are a Rollbase Private Cloud customer running on Windows or you are a Windows user evaluating Rollbase Private Cloud, be sure to try out this option to streamline your installation process.
Change of Address: 14435 C Big Basin Way, #211, Saratoga, CA, 95070 Rollbase has moved! Please make sure to update your contact information to:
Rollbase Inc. 14435 C Big Basin Way #211 Saratoga, CA 95070
Thank you for using Rollbase! The Rollbase Team
|