Quickbase February 2023 release notes

Contents

• Enhancements
• Beta opportunities
• What’s fixed in Quickbase

Enhancements

Scrolling navigation in report builder

Use the new report builder panel to update your report settings while viewing your report data. Open the panel to access things like filters, sorting, color, and so on.

Based on the feedback we received, we changed from just using icons to switch sections in Kanban reports to navigation using scrolling. This makes navigating between sections easier, faster, and clearer.

Learn more about using the new report builder panel in our About Kanban reports in the help center.

We plan on releasing this report builder panel to other report types in the future. We’ll announce new releases in the release notes.

Longer runtime for performance insights 

Run performance insights for 4 hours at a time to get more information and insights about how to improve the performance of applications. Builders can select different increments, but we recommend 4 hours to collect the most information. Learn more about performance insights in the Quickbase community. 

Performance improvements for key fields 

Reports and queries with a single criteria that leverage key fields now perform better. When it is possible, Builders should ensure reports, API calls, and formula queries use the key field for filtering.

Increased user token limit per user

A single user can now create 100 user tokens instead of 20. This work supports an increase in demand for integrations. Learn more about user tokens and applications in the help center. 

Audit logs: Increased limits for data change logs 

Data change logs have a new limit of 50 apps and 100 fields per table (up from 20 apps and 50 fields). This is helpful when working with larger apps with several tables. Learn more in the help center. 

Change to embedded report links across apps 

We’re continuing our efforts to help app builders scale effectively on Quickbase by changing the behavior of email notifications when a form is sent with an embedded report originating from a different app without an explicitly-defined relationship. Now, if the form is configured to include an embedded report directly, it will always be sent with the email notification. As of March 9th, the behavior is as follows: 

• When the embedded report on the form is part of an explicitly-defined cross-application relationship, there are no changes. 
• When the report is embedded on a form within the same app, there are no changes. 
• When the report is not part of a cross-application relationship, but does come from another application, the parent form displays a link to the report.

In March, we plan to release an update to help embedded reports from different apps scale more effectively. The upcoming change will stop embedded reports from causing dependency in the Quickbase infrastructure. Apps with a defined cross-application relationship will still share resources. 

New formula functions for working with dates 

We’ve added and upgraded formula capabilities to help app builders process data that includes dates and times across time zones and systems. 

• “ToFormattedText()” now includes an input for “ISO8601”. ISO8601 is an international standard used in many systems, including our RESTful APIs. 
• “ToUnixTime()” will output the numeric unix time of a date, or date/time field, including the milliseconds. 

Note: these enhancements will be added to the in-app formula function helper in our March release.

Here’s an example of how you can leverage these new functions: 

 ToFormattedText([date], "ISO8601") 

ToFormattedText([datetime], "ISO8601")

ToTimestamp([numeric])

ToDate([numeric])

ToUnixTime([datetime])

ToUnixTime([date])

Favoriting table reports 

We enhanced the ability to add table reports to a list of favorites. Now you can create and manage a list of your favorite table reports for all versions of table reports, including default table reports.

In the More options menu, select Add to favorites. Then you can open your favorites from the top navigation menu, and open a table report from there.

Access Procore purchase orders from Quickbase 

As of February 28th, you can easily pull purchase order information from Procore into Quickbase and any other systems we have a pipeline connect for. Quickbase automatically handles this complex process, and this expands the functionality of the Financial Management Module in Procore. 

RESTful API upgrades 

We updated our infrastructure to more strictly adhere to API specifications. This improves performance by an average of ~30%, helping customers do more in less time.  

This infrastructure update included security upgrades, infrastructure changes, and minimally-disruptive maintenance. Through the work we discovered and fixed different issues including: 

• QBE017646 Accepting null for groupBy property  
• QBE017605 Rejecting unicode escape characters with Bad Request 
• QBE017601 Inconsistent results on file attachment field queries 
• QBE017585 Providing retry-after response for rate limit error 
• QBE017659 Failing to authenticate realm names with uppercase characters 
• QBE017660 Failing auth endpoint with expired ticket error 
• QBE017643 Failing API when http:// is present in the header 
• QBE017661 Allowing trailing semicolon in content type header 
• QBE017662 Rejecting null record values incorrectly 
• QBE017663 Failing requests with missing or unexpected content type 
• QBE017604 Passing JS NAN to a numeric field 

Learn more about this work, the rollout, and the impact in Quickbase RESTful API upgrades and post mortem. 

Beta opportunities

No beta opportunities this month. Read next month's release notes for more opportunities.

What’s fixed in Quickbase