July 2019 Release Notes
We continue to deliver on our core themes of trust, simplicity, and power. This month’s release includes features for builders and admins along with enhancements across all areas of the product.
Our July release, with the features and fixes listed below, will be available July 21, 2019.
Power BI enhancements
Analysts using Power BI will get more value from their Quick Base data now that the certified Quick Base connector in Power BI is no longer in Beta. The following updates have also been made to optimize the formatting of data for Power BI:
- Reports containing report formulas are now supported
- Record ID# fields are now formatted as integers
- Checkbox fields are now formatted as Boolean and will display as TRUE/FALSE within Power BI
- Durations are being converted to days versus the native API response of milliseconds
- Ask the user reports are now omitted to prevent confusion
- The certified connector will now appear in the Online Services category within the Power BI Get Data menu
Note: These updates were released in Microsoft’s June product release. You will need to download the latest updates to Power BI to see these changes.
Field dependency diagram enhancements
We have enhanced the field dependency diagram to help builders gain even clearer insight into how the fields in their apps are connected to each other. Now they will be able to see the dependencies of even more types of fields. The following fields expand to show the fields on which they are dependent:
- Composite fields used in Quick Base Sync
- Fields referenced in the filter criteria of a Summary fields
Builders will now have an even more complete view of how the fields in their app are interrelated.
Audit log enhancements
For those with access, audit logs now include:
- Calls to API_DoQueryCount, a call which counts the number of records in a table that match a set of criteria
- Searches at the app level, including the number of tables searched
- Report access or form activity through a URL redirect
- Access to home pages and rich text pages
- Access to embedded reports
Audit logs are included with Platform and above plans with 6 months of data retention. They are available as an add-on for Premier plans.
SAML configuration self-service
Today, we support SAML authentication, but it can only be configured by Quick Base Customer Care. With this release, customers can now configure SAML through the SAML Authentication page of the Admin Console.
Cross-app relationships in Visual Builder
Now you can create and view cross-app relationships in Visual Builder. Cross-app relationships display as a line going off of the Visual Builder page. This will help builders map out not only relationships among tables in an app but also among several applications.
Note: Before creating a cross-app relationship, be sure to reference our Guidelines for sharing data across Quick Base apps.
Also in this release
In order to comply with new Gmail policies from Google, on July 24th we’ll update the API we use for Quick Base Sync connections to Gmail. After this update you may notice differences with the values available in the Labels and Flags fields. If you currently use either of those fields for filtering you may need to update your filter. Specifically, the Answered flag will no longer be available.
Coming soon — Early access
The new Sandbox capability will enable customers to increase app building collaboration between their builders, admins, and end-users in a safe environment and test changes to their apps using partial or full data from their live app.
Our completely re-designed Sandbox allows builders to modify a Quick Base application in a safe environment and published those changes directly to the live app.
To participate, sign up in the QB Early Access app and select Platform Administration & App Lifecycle Management under Early Access Categories.
User role formula function
Builders can create even more powerful business logic with the new user role formula function, validating permissions and creating role-based conditions for reports, notifications, and automations. This feature allows you to have a smaller number of more adaptable forms.
User role formula functions can be used in many ways, including:
- Showing or hiding something on a form based on a user’s role, instead of needing a separate form
- Validating data based on who is entering the data
- Sending a webhook or email notification only if a user is in a specific role
- Dynamically showing instructional text based on which role is viewing the form
For consistency, you can output the User role formula function into a new Formula-Multi-select text field.
To participate in early access for this feature, please open a support case.
New field type: Formula-Multi-select text
With our new field type, Formula-Multi-select text, multiple text values are now clearly displayed in a single field so you can determine exactly which values apply to each record. The formula allows users to see all the applicable items as their own visually distinct pills, rather than having to interpret a comma separated list.
For example, you can use this new field to:
- Show the names of each office building that is served by a specific parking garage
- Tag each team in a company that needs to be invited to a scheduled all-hands meeting
To participate in early access for this feature, please open a support case.
Sign up for future early access opportunities
We have some exciting early access programs coming up. If you are interested in participating, please provide us with your information. If you are a good fit for any of the programs, we will reach out to you directly.
What’s fixed in Quick Base
We continue to focus on quality. Below are the issues we fixed this month.
Note: Platform security, billing changes, back-end tooling, and performance are all ongoing commitments. Each release may include changes in these areas.
|QBE010811||In Quick Base Sync, when you open a connected table and delete a field, the label now correctly reads “Disconnect and delete field” and the correct confirmation message appears.|
|QBE011353||In Quick Base Sync, we provided help text in product to clarify that the format needed for the Quick Base URL is https://mycompany.quickbase.com with no /db added.|
|QBE013467||We fixed an issue where field names were displaying twice when certain form rules were valid.|
|QBE013480||We fixed an issue with displaying a report in the Reports panel when the report has Column heading override selected.|
|QBE013489||Report formulas now correctly update when a field name is changed.|
|QBE013513||We fixed an issue with embedded timeline reports that have sorting and grouping.|
|QBE013557||If you have a & symbol in a field value and you create a dynamic form rule where the action is to change the value of another field to add an &, the & symbol now displays correctly.|
|QBE013560||The new Settings button now does not display on the App Settings and Table Settings page if the toggle to use the new Settings panel is set to Off.|
|QBE013570||We fixed an issue that could produce errors when connecting to Google Drive for Business for a connected table.|
|QBE013574||When you specify a date range for downloading audit logs, and immediately select Download without first choosing to Display logs, your downloaded file now correctly contains logs in your specified date range.|
|QBE013576||In Visual Builder, you can now edit the field names for Address field types.|
|QBE013579||We fixed an issue where some users were automatically logged out before the 30-minute inactive session timeout.|
|QBE013581||When viewing or editing records in apps that you manage, the Settings button now consistently displays.|
|QBE013588||Drilldown reports now work correctly when the chart series is a report formula.|
|QBE013597||Edit app home settings, such as app icon, color, name, and description, is now available through the navigational Settings panel.|
|QBE013603||We significantly reduced the chances of losing a parent connection when the Save & new option for adding child records is used repeatedly.|
|QBE013605||The Search and replace in schema feature now supports report formulas.|
|QBE013607||We fixed an issue with how Formula—Rich text fields work in charts when you use a report formula.|
|QBE013610||Quick Base Sync refreshes can now result in a partial refresh if the table size would become too large. We updated and clarified the error message; it now reads “The refresh stopped before completion because the connected table reached the maximum table size.”|
|QBE013668||Field names with double curly brackets are now handled properly when you customize or create charts.|
© 1999-2019 QuickBase, Inc. All rights reserved. Legal Notices.