Quickbase Announcements

 View Only

Table report features being retired: iCal and vCard fields, Summary Tables, New and Updated Flags, and the Report Format setting

By Brian Cafferelli posted 12-21-2020 17:30

  

Table report features being retired: iCal and vCard fields, Summary Tables, New and Updated Flags, and the Report Format setting

 

Our team has been hard at work building a new table report experience from the ground up, to give you a more modern and speedy way to get insights from your data. To streamline your report experience, we will retire the following features: iCal fields, vCard fields, summary tables, new and updated flags, and the report format setting.

 

Background

Over the next few years, we will be refreshing the entire user interface of the Quickbase platform. This will provide a more modern and consistent product experience, prepare us for future support of international characters and accessibility, and speed up our delivery of new features. The first step on this journey will be launching a brand-new table report experience.

Because of the large scale of this project, it will be more important than ever for us to keep consistent focus on delivering the highest-impact functionality that serves the most pressing needs we see in the market. Over the 20 years of Quickbase history, we’ve regularly enhanced the platform by adding new features. Providing new features is necessary to ensure Quickbase continues to be a leading platform for dynamic work management years and decades into the future. However, adding new features alone is not sufficient to reach that long-term goal. Some features are either no longer used in large numbers, have been superseded by newer features, or no longer fit our product vision. Each feature which isn’t often needed is a drag on the productivity of app builders and requires designer and developer time for us to re-build in the new UI. This is why we recently decided to begin streamlining, by retiring Quickbase features on a regular basis.

As we designed the new table report experience, we identified five features which we are retiring. Read on for details on each feature being retired and what to do if you’re using one of those features.

iCal fields

iCal fields are designed to make it easier to push meeting info from Quickbase to a calendar system such as Microsoft Outlook. An iCal field provides an icon which a user can click to download an ics file, which can then be imported into a calendar system.

Rationale for retiring: Pipelines enables meeting info to be integrated across systems, making iCal fields redundant. Pipelines also supports improved workflow over iCal because a) you can build bi-directional integrations with pipelines, and b) pipelines eliminates the manual steps of iCal fields where a user needs to click to download a file, then import it into their calendar system.

Alternatives to iCal fields: Pipelines, specifically the Outlook and Google Calendar channels. Also, you can use the Webhooks channel to integrate with other calendar systems. (Learn how to use pipelines to automatically book Outlook meetings from Quickbase)

How we are retiring iCal fields: We reached End of Sale for iCal fields in the spring of 2021, when the current table reports were released and defaulted to ON for all users. That is when we began recommending that customers stop using iCal fields, and ended product training on them.

We reached End of Support for iCal fields in November 2023, That is when technical support for iCal fields ended.

iCal fields cannot be used on current table reports, dashboards, or forms. However, they can be used on legacy table reports, dashboards, and forms for now. When we have more information about End of Life for iCal fields, we’ll let you know so you have plenty of time to prepare.

 

vCard fields

vCard fields are designed to make it easier to push contact info from Quickbase to a third-party system. A vCard field provides an icon which a user can click to download a vcard file, which can then be imported into another system.

Rationale for retiring: As is the case with iCal fields, Pipelines enables contact info to be integrated across systems, making vCard fields redundant. Pipelines also supports improved workflow over vCard because you can build two-way integrations with pipelines, and pipelines eliminates the manual steps of vCard fields where a user needs to click to download a file, then import it into another system. Finally, vCard is a very outdated piece of technology. It was originally created to make it easy for someone to save a contact on their cell phone (before smartphones become popular).

Alternatives to vCard fields: Pipelines. Many of our integration channels may be helpful here, such as Salesforce, Servicenow, Mailchimp, and Marketo. If you’ve built basic pipelines to integrate data across systems, you likely already have the knowledge you need to replace your vCard fields. If you’ve not worked much with pipelines, check out our Getting Started with Pipelines course on Quickbase University.

How we are retiring vCard fields: We reached End of Sale for vCard fields in the spring of 2021, when the current table reports were released and started defaulting to ON for all users. At that time, we began recommending that customers stop using vCard fields, and ended any product training or orientation on the feature.

We reached End of Support for vCard fields in November 2023, That is when technical support for vCard fields ended.

vCard fields cannot be used on current table reports, dashboards, or forms. However, they can be used on legacy table reports, dashboards, and forms for now. When we have more information about End of Life for vCard fields, we’ll let you know so you have plenty of time to prepare.

 

Summary tables

Summary tables are designed to display summary data alongside record data. When building a table report and selecting records to group on, you can choose to display a summary table at the bottom of the report. Summary tables count how many records in the report match each value in the grouped field.

Rationale for retiring: Any insights that can be gained from summary tables can also be gained by building a summary report. This makes summary tables redundant. We also see users getting confused when the main table is hidden, since that causes a table report to behave like a summary report. Finally, in the future we aim to give you more options for customizing the layout of pages in general.

Alternatives to summary tables: Rather than include a summary table at the bottom of a table report, you can build a summary report instead. To see the summary and record views side-by-side, you can add both a table report and a summary report to a dashboard. (Learn about creating summary reports and creating dashboards)

We are also exploring improvements to the collapsible groups so you can collapse all grounds while still seeing the subtotals. 

How we will retire summary tables: We reached both the End of Sale and End of Support for summary tables in the spring of 2021, when the current table reports were released and began defaulting to ON for all users. At that time, we began recommending customers stop using the feature, and ended any product training or orientation on summary tables. Technical support is no longer available for the feature.

When we have more information about End of Life for summary tables, we’ll let you know so you have plenty of time to prepare.

 

New and Updated Flags

New and Updated Flags are designed to focus users’ attention on the most important and timely information. They flag records which have either been added or updated since a given user last visited the table. They are hidden by default, and enabled by each individual user.

Rationale for retiring: Since it clarifies what a user should pay attention to, we see New and Updated Flags as a workflow feature. However, the feature is controlled by end users rather than app builders. This severely reduces its usefulness. App builders also have several alternatives available to focus their users’ attention on the most important info.

Alternatives to New and Updated Flags: Use report filters and formulas to dynamically filter and flag records you want your users to act on (learn more about report filters | learn more about formulas). Unlike new and updated flags, as an app builder you can rely on your reports and formulas to behave consistently for all your users.

Here’s how to use report filters to replace New and Updated Flags:

 

And here’s a text formula you can use to replace New and Updated Flags. You can then include this field on a table report to show which of the records was recently created or modified:

These alternatives do not dynamically highlight records based on the individual user. However, they do provide a unified view of which records were created or modified recently. This is a pattern we will be leveraging as we refresh and rebuild each part of the Quickbase UI. While our goal is for the new UI to enable you to solve roughly the same business problems you solve using the current UI today, we will not necessarily solve those problems the exact same way we did before. In other words, through out UI refresh we will keep consistent what business problems you can solve with Quickbase, rather than the specifics of how those problems will be solved. This is crucial for us to cultivate innovation and keep our focus on the most important issues, rather than ironing out every minor detail.

Using report filters and formulas to highlight recently created/modified records has the added benefit of allowing you to apply your own custom business logic to determine which records to highlight or include. For example, for your company "new" might mean anything that has been added in the past 72hrs, rather than 24hrs. Or, for a more complex scenario, you might want to flag tasks where either a) the priority is marked “High”, b) the task is overdue by at least 7 days, or c) it’s a compliance task that’s overdue by any length of time. Here’s a formula you could use to match that process by displaying an Attention tag for high-risk tasks:

How we will retire New and Updated Flags: We reached End of Sale and End of Support for New and Updated Flags in the spring of 2021, when the current table reports were released and began defaulting to ON for all users. At that time, we began recommending that customers stop using new and updated flags, and ended any product training or orientation on it. Technical support is no longer available for the feature.

New and Updated Flags cannot be used on current table reports, dashboards, or forms. However, they can be used on legacy table reports, dashboards, and forms for now. When we have more information about End of Life for New and Updated Flags, we’ll let you know so you have plenty of time to prepare.

So if you are an app builder, you may not need to take action. If you have already designed your apps to clearly focus your users’ attention on the data that matters most, using targeted filters and formulas similar to the above, you should be all set. 

If you are not an app builder but you use New and Updated Flags, we just want you to be aware that these flags are being retired.

 

Report format setting

The report format setting allows the user to control the visual appearance of a table report. The setting can be found by clicking Customize this Report, scrolling down near the bottom of the page, and clicking the Format dropdown menu. There are three categories of options you can select: a) Plain Text, b) Comma-separated or Tab-separated values, and c) XML (flat) or XML (structured).

  1. The Plain Text option displays the report without any color, column headings, links to view individual records, etc. It displays just the raw data for each record.


  2. The Comma-separated and Tab-separated options prevent the report from being displayed in the app altogether. Instead, when a user clicks to view a report with either of these formats selected, they will be prompted to open or save a CSV or TSV file. The file contains the record data, just as you would see if you saved the report as a spreadsheet.


  3. The XML options allow a pro developer to insert a link to an XML stylesheet. This allows full control over the appearance of the report. A developer could use this to make simple changes like customizing the fonts and colors on the report, or to build more creative visuals such as the word cloud above.

Rationale for retiring plain text, comma-separated, and tab-separated formats: These formats are redundant since raw record data can be downloaded using the Save as a Spreadsheet function.

Alternatives to the plain text, comma-separated, and tab-separated options: Simply save the report as a spreadsheet instead.

Rationale for retiring XML formats: Quickbase is designed so pro developers can extend and customize their apps using custom code, including XML code. We see this is an important capability and we will be improving on it in the future. However, it is not a design best practice to have users link such custom code inline, as you do with the report format setting. There are multiple other ways to fully design the visuals of a table report, making these XML options redundant. Finally, using XML for stylesheets is a very outdated technique, further reducing the value of these XML options.

Alternatives to the XML options: You can create a web page to display your report instead, using our APIs to populate the record data, and including the stylesheet of your choice. While most developers use CSS for this, you absolutely can use other languages such as XML if you prefer. You can host this web page on your own server if you have one, or you can host it within your Quickbase app as a code page. Developers will feel more at home doing so now that we offer a modern, JSON-based, RESTful API for Quickbase. Click here to review our guidelines for extending Quickbase using custom code.

How we are retiring the report format setting: We reached both the End of Sale and End of Support for the report format setting in the spring of 2021, when the current table reports were released and began defaulting to ON for all users. At that time, we began recommending that customers stop using the feature, and ended any related product training. Technical support is longer available for the report format setting,.

When we have more information about End of Life for the report format setting, we’ll let you know so you have plenty of time to prepare.

 

Questions and feedback

If you have any questions or concerns about the above feature retirements, please open a support case and we’ll be happy to assist you. You can open a case from Quickbase by clicking ? (Help) at the top of the page, then clicking Manage Support Cases.

If you’d like to share ideas or feedback on this topic, please let us know by clicking Give feedback on the My Apps page.

 

Learn More

  1. Quickbase’s approach to retiring features
  2. Open beta has begun for new table reports
  3. Getting Started with Pipelines and Build Powerful Pipelines using Included Features – QB University courses
  4. Learn how to use pipelines to automatically book Outlook meetings from Quickbase
  5. Creating summary reports
  6. Create an app home page
  7. Report Filters
  8. Gaining Efficiency through Formulas – QB University course
  9. Creating code pages
  10. Extending Quickbase
  11. Running log of all Quickbase feature retirements

Permalink