Quickbase December 2022 release notes

Contents

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

New

Smart builder table and field recommendations

App builders can now use intelligent recommendations when creating tables and fields. Smart builder table and field recommendations are generated by an AI/ML algorithm trained on the millions of apps built on the Quickbase platform over the last 20 years.

Recommendations are included in updated Add Fields and New Table dialogs. You can see recommendations by selecting Recommendations or by typing to search for specific suggestions.

Smart builder table and field recommendations only include information that is common across at least 30 different customers. This helps keep recommendations relevant and anonymous.

Pipelines: Snowflake channel now available

Update December 12, 2022: Snowflake channel will be available as part of our Public Beta program.

Snowflake is a modern data warehouse that lets you easily store, transform, and analyze large datasets with unlimited computing. With the new Snowflake channel in Pipelines, you can now easily integrate Snowflake to send data to and from Quickbase apps and other systems in your ecosystem.

Since the Snowflake beta program, we've also added the ability to export records to CSV. This allows you to easily transfer a large set of records (up to 300MB) from Snowflake to Quickbase. For example you can generate a CSV with the Export Record to CSV step from Snowflake and then Import with CSV in Quickbase. For more details see the Snowflake help article.

GetRecordByUniqueField() formula function

Formula queries make it much easier to build calculations based on data from other records and data from other tables. The GetRecordbyUniqueField() function expands what's possible with formula queries. You can use GetRecordbyUniqueField()instead of GetRecord() to allow users to search for a record using any unique field, rather than being limited to the Record ID#. 

To use the new function, provide a field ID and a value to search for. The field must be marked both unique and required. Use this function within the GetFieldValues(), SumValues(), or Size() functions— all of which can use a list of records as input.

The GetRecordbyUniqueField() function is ideal to use with tables that have custom key fields, but you can use it with any field that is both unique and required.

You can also replace performance-intensive GetRecords() queries in situations where a unique, required field is available with GetRecordbyUniqueField() which offers easier set up and will give your queries a performance boost.

Learn more in our Formula Queries help article.  

Restrict Pipelines connections outside of a realm

Available December 13, 2022: Security-sensitive realm admins on Enterprise plans can more effectively control access to their data by restricting Pipelines to connect only to their own realm. To restrict pipeline connections, go to the Policies page in the Admin Console. Restrictions will apply to any pipelines that include the Quickbase channel. When this restriction is turned on, any pipelines that use the Quickbase channel to connect two different realms will stop working. Learn more in our Security Policies help article.

Enhancements

Pipeline activity log date/time filter

We’re making activity log filtering by date easier and more powerful. You can now zoom in on activities by the hour, minute, and second.

The activity log now includes a From and To field. By clicking the clock icon, you can also select an optional 15-minute time increment. After you’ve made your selection, you can type in a more specific time increment.

New tooltip on the Permissions page

We’ve added a new tool tip to the Permitted users and groups table on the Permissions page.When you hover over a specific group or email domain group, you will see how many users are in the group. When you hover over a user, you will see the username and email.

Improvements to Performance Insights

We’ve added new insights that cover:

• Clusters of tables
• Reports that would benefit from caching
• Complex triggers (labor-intensive triggers generated by Webhooks or email notifications)

We also made a few other updates:

• Design changes that make the insight title more obvious and add a category so you can easily see what type of action will be required
• More details about specific pipelines referenced in insights
• Better links that go to a specific spot on a help page rather than the top of the article

Pipelines: JWT authentication now used in JSON Handler, CSV Handler and Webhooks channels

You can now use JWT (JSON Web Token) authentication in the Pipeline JSON Handler, CSV Handler and Webhooks channels. For more details see JSON Handler details. For example, the Incoming JSON step supports authentication through a JWT token:

When you select the JWT Token option, you’ll need to provide a public key and select a signing algorithm:

Beta opportunities

What’s fixed in Quickbase