February’s release comes with a wide range of great new features, that continues with the theme of the last few months, which is enhancing the overall look / feel / usability of Quick Base and expanding on current features in exciting new ways.
Among the highlights:
Type ahead search-picker released
Highlighted last month – the new Search Picker is here – where you can type ahead to filter your list of records similar to the type-ahead field picker currently used for reports. This feature lets you quickly filter and find records in your reference fields, so you can better associate with the proper parent. This is helpful in situations where your reference field displays several different values, and need to identify by the second or third values.
Summary field – Distinct Count
As a follow up to list-text, this new summary field type counts unique occurrences of a value in a child table. An example would be if you wanted to see how many sales-reps worked on an account over hundreds of projects, you can do a distinct count on the Sales Rep field to know just how many there actually were.
Up to 3 Calculated columns in reports
Reports now have a cleaner interface and expansion on the number of calculated columns from just 1 to 3. This is great if you set up single use case reports and don’t want to create a new field for just this report. If you’re not an admin – this is also a great way to run your own calculations and display them in a report. For me personally, I like to use formulas when I have complicated filters and then filter by one of these columns.
New formulas and syntax
There are several new formulas including a padding and search and replace formula.
-> Padding formulas ( PadLeft() / PadRight() ) will allow you to auto-insert a value to the left or right of something to make sure the number of digits meets your expectation. For example, if you generate a Project # that is always 10 digits long, but don’t want to type out 10 digits every time, you can enter a single number, and have Quick Base pad the preceding 0’s ( Project # 501 becomes 0000000501).
-> Search and Replace is like the excel Substitute() function, where you can search a string for a match and replace it with another value.
-> Additionally – AppId() has been added to represent the application ID (similar to how Dbid() will display the table ID)
-> != has been added, will work the same way that <> currently does for ‘Not Equal To.’ to be more inline with standard programming formats
More Updates to Automations
Continued updates to automations are bringing them as complete replacements to webhooks and actions. They now have the ability to log the old value of a field (like when you want to log changes to a certain field or track the prior value somewhere else), and can also write to Address fields. Note that when using address fields, the data model for them is that each part of the address is its own field (street 1, street 2, city, state, zip), to which automations are now able to write to them individually.
Hide Save as spreadsheet options
Part of the user interface control now has the ability to remove the ‘save-as-spreadsheet’ option from particular tables. This is especially useful if you have tables that are sensitive or should not be shared outside of Quick Base.
In addition to the above – the early release notes offer an early access opportunity for a drag and drop interface for application set up – as well as hinting at a much more powerful validation workflow.
For more detail, or a full list of whats packed into this release, you can find the full release notes here.
Author: Chayce Duncan (firstname.lastname@example.org)
Date Submitted: 2/17/19