A brand new table report experience
Earlier this year, we embarked on a journey to modernize the Quick Base interface. We committed to doing this in a safe and methodical way and began discussing some of the trade-offs on this Community post. We are proud to say that the time is almost here for customers to be getting their hands on our first large slice of this – the new table report – and providing us valuable feedback. This process will be slow and methodical. At the start, we will be more restrictive about the types of apps and environments that are suitable. As we add features and address bugs, that net will continue to widen. Here is the current progress: Throughout this modernization process, your feedback will be critical for its success. To that end, we are exploring a private, invite-only, forum, right here in the Quick Base Community where engaged builders can ask questions, read about progress and even provide some unstructured feedback to our interaction designers and/or engineers. We first showed you the new table report at Empower 2019 and it was clear users were excited. So, we spent the time since then working on the foundation of the house which includes things like getting core interaction components in place and optimizing for performance. I have one test with 500,000 records that is achieving about a 10x improvement over our current report. As we start on our multi-phased early access process, we want to be transparent and open. At the onset, we are going to be looking for feedback on the framing of the house. That is the walls, electricity and plumbing. It isn't yet time to pick out the floors and the cabinets. Bringing it back to this, not every field type is completely supported yet and the implemented design is not perfectly aligned with the vision of our talented designers. We hope you are as excited as we are to try this new feature. When enabled, users will be able to toggle on and off the new report. Quick Base is used by hundreds of thousands of users across over 100,000 applications. For the most part, no two applications are the same and we regularly say to customers "You did what with Quick Base!?". That makes our job of objectively choosing what to implement (and when) somewhat challenging. We are doing our best to meet or exceed industry best practices while also keeping things somewhat familiar for those of you that have been using the platform for years. This sometimes requires us to make tough decisions, such as migrating away from dynamic filters and onto column filters. We acknowledge that some people may prefer the legacy style but are prioritizing data density and a more approachable interaction with column filters. Participating in the early access means a few things: You are going to be using a feature in early access that is not production ready. It may be unstable, do things you don't expect and not include something you are used to. Quick Base does not guarantee the stability of any feature in early access and normal SLAs and Care channels are not applicable. While in early EA, theoriginal table experience is still fully supported and maintained. You should have a close relationship with your users in the early stages of testing. This is so that you can set good expectations with them on what is and out of scope and so they can funnel feedback that you can ultimately convey to us. Updates to this feature will not go through regular release cycles. We may reach out to end users who have toggled back to the old report to gather feedback from them. This may include a brief survey. Builders in the early access program should be able to dedicate time to review the feature with Quick Base staff as needed. Feature access may be turned off at any time, without notice. It isn't a decision we take lightly, but it could happen if we notice issues! It is important to remember that the new table report component is using our modern continuous deployment model. During early access, you should expect frequent bug fixes and enhancements that will come without any notice. These could be weekly or daily. We are rigorous about quality but expect there to be hiccups along the way as we tackle such a large and critical piece of Quick Base. If you are interested in working with us to test and provide feedback, we ask that you carefully consider which of your applications make the most sense for this. For most people reading the post, the next steps are simply to get excited and talk to your user base to make sure their expectations are set. You will hear from us with directions on how to apply for EA within the next few weeks. Remember to stay tuned to our release notes, as that is our official channel for product features. ------------------------------ Harrison Hersch ------------------------------20Views9likes3CommentsMarch Table Report Update
First, I want to start off by saying thank you to everyone currently participating in the New Table Report Early Access Program and in particular, thank you to those of you who have submitted feedback or taken our survey. You all have had a ton of awesome feedback for us and I want you to know we've taken it to heart. This month we're rolling out a bunch of exciting enhancements based in large part on feedback from our EA participants! Here are the highlights: New pagination controls We heard you loud and clear that it was difficult to move from page to page with pagination controls that scroll out of view at the top of the report. This month we're introducing new controls that will stick to the bottom of your window, so they'll always be there when you need them. Click on the < or > arrows to advance one page backward or forward, on the numbers themselves to move to a page that closely neighbors the current page, or type directly in the box to skip to a specific page. Table bar/more menu functions We heard from lots of folks that items in the table or more menu that weren't yet available were preventing them from using the new table report more broadly. With that in mind, we did some research to determine which features were most heavily used and have started down the path of building these out. This release we'll be including: Grid Edit Download Report (formerly known as Save as Spreadsheet) Email Print And a “coming soon” tag to other options we’ll be working on including in future releases. Color coding Speaking of critical functionality, many of you also requested we include color coding as it plays a big role in many of your workflows. This Sunday, we'll also be introducing a new color-coding design. The strong color will be displayed in a "chiclet" on the left-hand side of the row with the rest of the row displaying 10% opacity of the same color. Deciding on a new model for color coding was such an interesting challenge. I'm going to write a post just on that. Stay tuned! Column filtering enhancements Since our last community post in January, column filters have improved by leaps and bounds. Now, you can filter almost any field on the fly in the column heading, spreadsheet style. Depending on the type of data and number of options, you may be presented with a dropdown or a text box. New in this release, multi-select fields will now offer a dropdown when the number of options present in the field is < 100. Making decisions about how to build a particular feature in Quick Base is always a constant balancing act between giving the builder the power to customize the experience while still giving end users the flexibility and power to get the information they need. Column filters are a prime example of this. Currently we're giving power to the end user by allowing them to filter almost any column they have access to. That said, we are keeping an ear out to understand how many folks would like an extra control to limit filter options. Bug fixes and performance improvements Along with all of the flashy, exciting improvements mentioned above, we've also continued, as always, fixing bugs as we go and improving performance of the report. In this release, we've fixed a sorting issue affecting long, grouped reports and improved performance when the report is grouped on a user field. Next up, we will be addressing the horizontal scroll issue a number of you mentioned in your feedback. Our developers are working on a fix for this as I'm writing this now, so we should have this resolved by the April release. If you're interested in participating in our early access program for the new table report, but are not yet involved, please make sure you have registered based on the instructions in our monthly release notes. We are inviting more and more participants every day. If you are exceptionally passionate about working with us on this topic and being part of the cutting edge in Quick Base and have not yet received an invite to the program, please reach out to your account team at Quick Base so that they get in touch with the right people on our product team to advocate for you. ------------------------------ Alice Hinshaw - Quick Base Product Manager ------------------------------8Views5likes2CommentsStop automatically adding new fields to reports.
Here's the problem. Whenever I create a new relationship and add lookup fields or summary fields, QB attaches the new fields to reports. How do I stop this from happening? Is there a universal app setting where I can set the program to "not add new fields to reports" similar to the "When new fields are created Do Nothing" option for forms?10Views4likes4CommentsConditional Dropdown - Multiple Values
I have a table named Organizations. I have some conditional dropdowns for fields detailing where these organizations are based, using two other tables: Country and City. However, our dataset is rather large, and some of the Organizations are present in multiple Countries or multiple Cities (or both). Thus, as I understand conditional dropdowns cannot use multi-select fields, a traditional conditional dropdown does not quite suit my needs. Of the solutions I can think of, all have downsides. 1) Instead of having Organizations as the child table in the dropdown relationships, I could use a join table instead,so that Organizations has a many-to-many relationship with Cities, and each organization can be listed with multiple countries and/or cities if needed. Downside I won't be able to sort and filter my Organizations table easily by city and country, as it will be the parent table of where the data is actually stored. Given the size of my dataset, easy filtering and analysis of the Countries and Cities involved is important for us. Or is there a way around this? 2) I could create a second or third conditional dropdown, in order to add these second or third locations. Downside Also difficult to filter and analyse data, and fiddly to enter data. 3) I could create a 'Multiple Locations' value option in the Countries and/or Cities,and then have a new field in my Organizations table to detail this supplementary information. Downside One set of values would be divided among different fields. Question: Does anyone have any suggested alternatives to the options above? Or solutions to the downsides identified? Any advice enormously appreciated!39Views3likes0Commentscreate a button that will trigger email notification
I show the example below in an earlier post but I can't get it to work URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "_fid_208=1"&"\n&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])34Views3likes15CommentsCreate a Summary Report from a Multi-select Dropdown Field
Suppose I have a Multi-select field with options (A, B, C) and 100 records where the field is used. Is it possible to create a report that counts each time an option is selected in each record? For example: A - 5 B - 8 C - 2 Above would indicate that the option A has been selected 5 times out of all of my records, B has been selected 8 times, and C has been selected 2 times. When I create a summary report for each I just get the count of each combination. Like A - 5 A;B - 3 A;B;C - 221Views3likes4CommentsHow to display PDF in file attachment fields
File attachment fields can show the attached files in forms and reports, but only a few file types are accepted (jpeg and such). Is there a way around this so that PDF attachments can be shown either directly in the form, or as a pop up window (I believe that is called an Iframe ?) after clicking on some button for that purpose? I now have that sort of working through a Chrome extension, which opens the PDF in another tab, but it's slow and cumbersome and has some unwanted side effects.279Views2likes62CommentsCreate formula text if multi-select text field contains a selection
I have a multi-select text field that I want to display the selections of that field in a different form field. As it stands it doesn't display all of them, just the first one that satisfies the criteria. here's what I have written: If(Contains(ToText([Equipment:]), "TENS Unit, Back Brace")= true, "TENS Unit, LSO Back Brace", Contains(ToText([Equipment:]), "TENS Unit")= true, "TENS Unit", Contains(ToText([Equipment:]), "Knee Brace")= true, "Knee Brace", Contains(ToText([Equipment:]), "Secondary Knee Brace")= true, "Secondary Knee Brace", Contains(ToText([Equipment:]), "Back Brace")= true, "LSO Back Brace","")44Views2likes4CommentsApril – New Table Report Update
Hello again, New Table Report users! I'm back with my monthly update to let you know what goodies you can look forward to on Sunday. One disclaimer before I dive in. To reiterate, this feature is still in an Early Access (aka Beta) phase which means it is still actively being developed. Part of what is exciting about being involved in an EA program like this is that you have the opportunity to give feedback on a feature that is not yet fully baked and can have an impact on its development. The flip side of that is that you should come into the experience expecting to find a few bugs and features we haven't yet built out. This is expected and OK! Onto the update: Horizontal Scroll Fix First up, we have fixed an issue where users were unable to scroll L to R anywhere but at the bottom of reports. Many of you informed us of this issue, so thank you for that feedback! With this fix we have also made a change to the way scrolling works on table reports. Now, only the actual report area will scroll rather than the current behavior where the entire screen area scrolls. This also has the added benefit of solving another problem inadvertently. Previously there was some jumpy behavior with column headers when scrolling down the page. This is no longer an issue as the headers now stay fixed in place. We recognize this will be a change that will take some getting used to and to make this switch easier, there are a few tools I'd like to highlight: Full-screen mode While full-screen mode was available in the more menu before, we've brought this out onto the table bar to make it more easily accessible. Note: The full-screen mode option will not be available on table homepages until our May release. Until then it will only be available on standalone reports. Density controls Not a new feature, but still an incredibly useful one! On the right hand side of your report you can adjust your display density if you'd like to see more or fewer records on the page. Feedback As always, we want to know what you think. Successful early access programs rely on your feedback, so please don't hesitate to submit feedback early and often by logging into the QB Early Access app and pressing the "Add Feedback" button next to the New Table Report EA program. Next up: Table bar/more menu choices displayed on standalone reports and table homepages are the same Essential, Daily Use Functionality This past month we've also continued our focus on adding in functionality users rely on every day in the current table report experience. This release we'll be including: Delete these records (formerly known as "Delete all records in this report") Find/Replace in this report (formerly Search & Replace in this report…) Column Properties – set alignment and override column headings Displaying report descriptions This is an area we'll continue to focus on in future releases, so stay tuned for more updates here. Next up: report density and chosen column widths persist between sessions Visual Design Enhancements A big part of our goals for the overall UI Refresh project we're embarking on is to, of course, modernize the look and feel of our UI. You may have noticed in my above screenshots, that this month we've included a couple of key updates: To save unnecessary space and modernize our look we'll be displaying icons + tooltips instead of both text and icons on the table bar From L to R: Grid edit, Download Report, Full Screen, More Menu, Customize Report/Page Where we previously had an icon next to your density controls to enable column filters, we've moved this next to the search box to be more intuitive and discoverable. Click it once to enable filters and twice to close them Miscellaneous Summary Date/Time fields will now be available in column filters We've resolved an issue with the display of Formula - Rich Text fields so these should now display as expected As always, we appreciate and rely on your feedback to inform our product decisions moving forward. Don't forget to submit your feedback here by pressing the "Add Feedback" button next to the New Table Report EA program. Also, something new I'm trying this month, if you'd like to schedule time with me to chat about the new table report, feel free to use this link to grab a half hour directly on my calendar here. If you're interested in participating in our early access program for the new table report, but are not yet involved, please make sure you have registered based on the instructions in our monthly release notes. We are inviting more and more participants every day. If you are exceptionally passionate about working with us on this topic and being part of the cutting edge in Quick Base and have not yet received an invite to the program, please reach out to your account team at Quick Base so that they get in touch with the right people on our product team to advocate for you. ------------------------------ Alice Hinshaw - Quick Base Product Manager ------------------------------8Views2likes0Comments