Recent Content
The Discord Qrew - What's It All About?
4 MIN READ TLDR: There's a Discord server for Quickbase Qrew members. It's run by Quickbase Qrew Members, not by Quickbase. It is a true Community-owned space. Quickbase employees participate as members of this community. Members of this space are online daily interacting with each other, helping with formulas, pipelines, and other product related questions. Quickbase Qrew Members can join here. As Community Manager here at Quickbase, I want to make every effort to actually be in the Community as much as I can be. That's not easy. There are a lot of you. There is only one of me. Part of the way we want to build more ways to engage with each other is to allow for more in person events via Qrew Groups. I'm excited to see efforts in Portland, Raleigh/Durham, and Boston coming along, and would expect to see a few more cities starting up soon as well. But what about the rest of the time when there are no in person gatherings to attend? That's a lot of time. How can the Qrew connect in other ways beyond Qrew Groups and this Qrew Discussions website? Our Community Slack was created in 2020 to allow for a virtual space to connect during our first virtual Empower, but it's been missing a true community feeling for some time. There had to be something else out there. I can't remember the first time I met @Rosson Long. I want to say it was former Quickbase Community Manager@Evan Martinez who introduced us on a call sometime in late 2022/early 2023. I arrived on the call without much in the way of an agenda, and Rosson immediately launches into this platform called "Discord" to show us the community he's built in this space. I'm googling "Discord" because I'd never used it. I'm not a gamer, clearly, otherwise I'd be very familiar with this platform. And Rosson is going from channel to channel talking about all the ways Quickbase community members could benefit. Rosson's passion for both Quickbase and this Discord space he's created are obvious. There's clearly value here, but I'm hesitant. My interest was piqued, so I asked for an invite. As an experiment, I decided I'd be a member of this small community inside the much larger capital C Community, and participate in Discord discussions when it made sense to. I've been doing so for the past six months, and here are my observations... If you love building in Quickbase and want to be around others like you, the Discord Qrew is where you want to be. It's not all work, it's some play. There's a #random channel where we recently went through our favorite lines from the movie "This is Spinal Tap". #thisgoestoeleven I witnessed someone share they had been let go from their employer and within days have a job interview and offer lined up. There's a #jobboard channel now as a result of this, members share openings in their org or post that they're looking for work opportunities. I was blown away watching this group come together to help one of their own find work. The knowledge is next level Quickbase. Some of the formulas, Pipelines jinja, tips and tricks being shared in this space are incredible. There are close to 200 members as of today, and there's always a group of frequent flyers in there daily helping each other out. I'd expect this number to climb steadily. Messages do not expire in Discord as they do in free Community Slack, which is a huge value add. It's very easy to pop into a room and demo a workflow or watch someone else demo a workflow. It's a very welcoming, extremely engaged, passionate group of Quickbase experts, and if you aspire to be a Quickbase SME one day, this is a good group for you to get to know. Don't take my word for it...here are some quotes from Quickbase Qrew members on their experience in the Discord Qrew... @Amanda Thomas wrote "This community helped me solve a problem yesterday without even realizing it. I was typing up my question and all the things I'd tried and just thinking about how to explain what I needed made me realize I had another option!" @Rosson Longwrote "The Discord community gives me an outlet to connect and talk with other Quickbase developers in real time about common problems and solutions. It also creates fun opportunities for humor and brings a light hearted mood to what can otherwise be a stressful and demanding job experience." @Allan Heaps wrote "The Discord community has been a key element in my comfort with and ability to move from a long career of educational technology and instructional design to database development and data analysis. I am the only one of my kind at the extended studies unit where I work. This Discord community gives me a group of capable mentors and peers who like to interact and learn together. I love that the conversations here cover archived questions and tips, opportunities to meet and show problems, and occasional conversations and demonstrations about who we are as humans in our lives beyond what we do at work." For those looking to join the Discord Qrew, here's a link to join.25Views9likes1CommentCustomer Events in May
4 MIN READ The below is a blog authored by CSM Esther Lavielle. 🌹🌺🌼🌞Spring weather is in full bloom and so are our Quickbase customer events. The month of May features Empower 2024 - our biggest virtual customer event of the year! In addition to our annual conference, there are many upcoming events for everyone – new or experienced to Quickbase - to participate in. The more you tend to your garden of Quickbase knowledge, the more it will grow and blossom! 📢📢📢Below is a list of our upcoming events with registration links and agendas. For an up-to-date list of events check out www.quickbase.com/events 🧑🏻🤝🧑🏿Manufacturing Customer Network Meeting – May 1st - Customer Network Anthony Offredi, Director of Customer Advisory, will present and walk through the Computerized Maintenance Management System (CMMS) app which is now live in the Quickbase app exchange. 🗣️Large Scale Solar – May 1st & 2nd In-person Conference We will be at Large Scale Solar in Dallas! If you plan to attend, be sure to stop by our booth to learn more about the features and how your peers are leveraging Quickbase to power all their solar projects in one platform. 🗣️Advancing Pre-Construction – May 2nd & 3rd In-person Conference We are headed to Advancing Pre-construction in Denver! If you plan to be there, stop by our Quickbase booth #26 to learn more about the most-requested features industry innovators are leveraging to manage complex buildout projects. 🎒Galactic Appventures - App Building for Beginners - May 1st & 2nd Training Launch your app-building skills to infinity and beyond with our Quickbase Fundamentals course! Join our crew of cadets as we navigate the universe of app creation. 🧑🏻🤝🧑🏿Realm Admin Customer Network Meeting – May 7th - Customer Network Josh Miller, Innovation Strategy Manager, will walk through our new suite of Quickbase Governance applications, the Governance Starter Kit, and will host a question-and-answer session on how you can use these applications to help govern your Quickbase platform. ⚡⚡⚡⚡⚡Empower 2024 – May 8th - Virtual Customer Conference Interested in saving 20+ hours of admin work per week? Join Us at Empower 2024 and learn how Daifuku Intralogistics America, Lithko Contracting, Unipress, Valmet, and others are finding better ways to uncomplicate how they get work done. 🧑🏻🤝🧑🏿App Builder Customer Network Meeting – May 14th - Customer Network Sam Trachy, Quickbase Solution Consultant, will be hosting a 'Relationship Therapy' session to go over the most common table-to-table relationship fails folks need help with during office hours. Don’t miss out on an opportunity to learn ways to improve relationships within your apps. 🧑🏻🤝🧑🏿Mobile Workflow Customer Network Meeting – May 15th Customer Network Josh Martin from Gulf Coast Underground will share a FastField mobile customer use case. Polina Georgieva will update the audience with new feature timelines to get excited about. 🕸️From App Inheritance to App Ownership – May 16th - Webinar Inherited an app but don’t know where to start? Join Manny De La Cruz and Esther LaVielle where they will offer solutions to get started on understanding your inherited app and where to start making updates that will increase efficiency and delight your users. 🧑🏻🤝🧑🏿Introduction to Pipelines – May 16th - Customer Network Embark on a journey of discovery with us as we delve into the world of Pipelines! This course will equip you to automate workflows and integrate systems, guide you through the process of creating and managing Pipelines. 🧑🏻🤝🧑🏿AEC Customer Network Meeting – May 21st - Customer Network Kaity Strong, Solutions Consultant, will walk through the Contracts Management app available on the Exchange and share tips and tricks she's gathered while working with customers in the Architecture, Engineering, and Construction industriesy. 🎒Galactic Appventures - App Building for Beginners - May 23rd, 24th - Training Launch your app-building skills to infinity and beyond with our Quickbase Fundamentals course! Join our crew of cadets as we navigate the universe of app creation. 🧑🏻🤝🧑🏿Pipelines Customer Network Meeting – May 29th - Customer Networks Dwight Munson from Sigma Technologies We will also do a Pipeline product keynote recap what was shared at Empower 2024 and give you an opportunity to ask questions and share feedback to the product team. 🎒Sweet Connections - The Scoop on Relationships – May 29th - Training Indulge in our build-along workshop focused on the power of relationships. You’ll learn how to build the structural components of relationships and how to optimize them for enhanced app performance, data management, and user experience. 🕸️Optimize Your Applications with Performance Tools – May 30th - Webinars Looking to improve your app’s performance? Join Manny De la Cruz and Simon Lindquist as they share how you can improve your apps performance and the user experience by leveraging Quickbase’s Performance tools: Performance Analyzer, Performance Insights, and Performance Optimizer. 🎒Spy Analytics - Data Visualization with Reports & Dashboards – May 30th- Training Join us on this mission to create dynamic dashboards, integrate cross-app reports, and enable role-based data visibility. You’ll learn to manage and share reports, and create dynamic, interactive dashboards to make data-driven decisions. We look forward to seeing you at these events and sharing tips and tricks with you along the way. Let's make this spring one to remember! 👷♂️👷♀️🏗️🏢Keep building amazing things! Esther LaVielle, Customer Success PS: Interested in sharing your story or demoing your application(s) at an upcoming Customer Event? Let me know and I’d love to connect with you, email me at elavielle@quickbase.com !21Views0likes0CommentsUpgrading Qrew Discussions
2 MIN READ Welcome to the new Qrew Discussions! Here's a tour of the recent changes to our community platform. The goal is to make this as smooth a transition as possible, and by the end of this blog, you'll know what's changed, what's stayed the same, and how to make the most of your experience on this site. What's Stayed the Same? A lot. This is still designed to be a place where people can ask questions and receive answers. "Quickbase Discussions" remains the main Forum, go there for all Quickbase questions. Every thread from before should be searchable, we copied over all posts, all file attachments. Your login process should be the exact same. Only those with an email address tied to a Quickbase account can login to this website. Since we use Single Sign-On, the fastest way to access Qrew Discussions is to already be signed into your Quickbase account first. What Changed? We have a new Ranking system. Every member of this community has a Rank in their Profile. Users can increase their rank through contributions. Liking content, or having users like your content, will influence your rank, along with quality contributions that are marked as best solutions by your peers. Our ranking system is also designed to be tied to our statuses in the Qrew Champions program, with Qrew Champion as the top rank. The more you climb, the more permissions you can unlock within this experience. You will also notice new badges in your profile. The more you contribute, the more badges we'll reward you with to show off on your profile. Search should feel different, and it should feel better. You can search with increased filters, and should be able to find your answers faster. We'll be building up a Knowledge Base called Q Tips, allowing both commonly asked questions and general "this is how I Quickbase" Q Tips to be shared with The Qrew. All Discussion Topics must have a Tag. It is required. Your question has a category, we will want to capture this category so that it makes for an easier way to find your answer in the future. Additionally, these tags allow for reporting on the Quickbase side so we can see which features are demanding the most questions. I've listed "Other" as an option, please only use this option if none of the other Tags apply. Is there anything I need to do? The settings you had in your profile were wiped clean. If you had set up your email to get daily subscriptions, you'll need to redo this in "My Settings" page. Important Resources: Here's a guided tour of My Settings and what these settings do Here's a recap of our new ranking system and what you need to do to climb the ranks. Here's an example of how you can use search differently in this experience. I'll update this post with other new changes if any new videos are needed.201Views0likes1CommentUnlocking more Quickbase Power with QBL and Solution APIs
4 MIN READ NOTE: THIS BLOG WAS WRITTEN byBrianCafferelli, BUT TECHNICAL CHALLENGES ARE PREVENTING BRIAN FROM PUBLISHING. Quickbase is built for enterprise scale. That’s why a majority of the Fortune 100 leverages our platform to manage their complex processes and eliminateGray Work. Success using a no-code platform like ours requires an approach to governance that enables business and IT to collaborate. Business users need to be able to innovate fast enough to stay ahead of competitors, while IT needs visibility and control to ensure compliance with corporate policies. That’s why one vital part of Quickbase isour Application Lifecycle Management (ALM) capability. This is a set of tools that helps you to plan, build, test, deploy, and update your apps.Our sandbox featureis one example of this. However, we have heard feedback from many of you that you need more control over how your apps are managed, as well as your pipelines. That’s why we are excited to announce general availability of our Solutions APIs, along with the all-new Quickbase Language (QBL). Introducing Quickbase Language (QBL) The cornerstone of Quickbase ALM is Quickbase Language (QBL), a domain-specific language designed to describe the schema of Quickbase apps. This human-readable, text-based language allows users to obtain textual descriptions of Quickbase apps and pipelines schema in the form of a YAML file. QBL's simple and intuitive syntax makes it easy to read and review changes to Quickbase apps, facilitating collaboration among development teams. You can findmore details about QBL in our help center. Solutions APIs Solutions APIs are an extension of our existinglibrary of RESTful APIs. This provides three endpoints that empower you to interact with QBL and manage Quickbase solutions easily: Export: Obtain the QBL definition for the supported schema of all apps in the Solution in YAML format. Create: Apply a YAML file with a valid QBL definition to create a new solution and its contained apps. Update: Apply a YAML file with a valid QBL definition to an existing Solution to update all schema in the solution to match the one in the YAML. These endpoints enable users to streamline the application development lifecycle, from creation to deployment, while ensuring consistency and accuracy across environments. The power of QBL + Solutions APIs Version Control: QBL describes your Quickbase Solutions using a text-based format. Solution APIs enable the export and import of these descriptions, facilitating version control. This solves the problem of tracking changes to Quickbase applications over time, providing a clear audit trail of modifications and ensuring consistency across environments. Change Management: By leveraging QBL and Solutions APIs, you can implement structured change management processes for Quickbase solutions. Changes made to schema can be described in QBL format and tracked through different methods. This enables teams to review, approve, and deploy changes systematically, reducing the risk of errors and regressions. Environment Management: Solutions APIs enable you to programmatically create and manage multiple virtual environments for your Quickbase solutions, such as development, testing, and production environments. This solves the problem of manual environment setup and configuration, streamlining the process of deploying and testing applications across different stages of the development lifecycle. Deployment Automation: You can automate the deployment of Quickbase Solutions, depending on your business needs. Approved changes can be automatically deployed from source control repositories to designated Quickbase environments, reducing manual effort and ensuring consistency in deployment processes. Scaling Solutions: Solutions APIs empower you to scale the distribution of Quickbase Solutions across multiple customers or organizations. By automating the creation and deployment of solutions using the APIs, you can efficiently onboard new users and deploy standardized solutions to different clients or departments. This solves the problem of manual solution distribution and customization, enabling customers to deliver value faster and more consistently. This allows you to build once, and deploy as many times as you need to, seamlessly maintaining many separate instances of the same solution. Applying these new capabilities To tap into the power of QBL and Solutions APIs, you need 2 main things. Step 1 Define the ALM goals of your team/organization. Figure out what is the best process for your setup. Do you need all ALM areas or just some of them? Will your team and users benefit from a strictly-controlled approval and deployment process, tight version control, or both? Is there some IT policy or regulation to follow? Once you have a good process defined, you can move on to step 2. Step 2 Decide what is the best way to manage and/or automate the designed process. Option 1: One powerful way to leverage Quickbase's ALM capabilities is by integrating the Solution APIs with source control tools like GitHub. By doing so, your can establish robust approval and deployment processes, enhancing collaboration, version control, and reliability throughout the application development lifecycle. Source control tools offer a wide range of features to support all that and if your organization is looking for optimal control and governance, we recommend looking into that option. Option 2: A different option, if your team needs a more familiar experience, is through managing the virtual environments, approvals, and deployments using a Quickbase app. Solutions APIs can be executed through a set of pipelines and the workflows can be managed in a Quickbase app dedicated for that purpose, as seen below: We are dedicated to making ALM easy for your teams. While QBL doesn’t support all Quickbase schema yet, we will keep improving the experience and adding schema coverage throughout the rest of 2024. To check which schema objects are supported by QBL today, please checkthe article in our help center. We are also here to help you on your ALM journey. Contact your account team for more information on the features and help in implementing them. Your feedback is precious to us! If you have anything to share about the ALM features, the experience using them, or you need more/different features, please leave your feedback in the side panel in the Quickbase platform!221Views0likes0CommentsDashboard Enhancements
2 MIN READ NOTE: THIS BLOG WAS WRITTEN by BrianCafferelli , BUT TECHNICAL CHALLENGES ARE PREVENTING BRIAN FROM PUBLISHING. 🚀🚀🚀Quickbase makes it easy to surface the right data, to the right people, at the right time. When you set up dashboards for each role in your application, you are enabling informed decision-making across your business. Quickbase dashboards allow you to display reports and charts from multiple tables or even multiple apps. And in just a few clicks, you can apply filters to all reports on the page. All of this is supported by our drag-and-drop dashboard designer, giving you a quick and easy tool for delivering important business insights. We’re excited to announce a series of improvements that will allow you to display more data and more reports on your dashboards, and make it easier to build those dashboards. These new improvements will be released in April 2024. 🚀Infinitely-scrollable tabs More space, more reports, more data - all on one dashboard! Tabs will also display at the top of the page instead of the bottom, with this new design. Infinite dashboard with multiple reports 🚀Seamless building experience Experience a smoother, more intuitive way to arrange your widgets now that widgets will automatically move out of the way. We also added a quick option to add a new widget below an existing one. Widgets intuitively moving 🚀Add below widget menu option 🚀Meet the spacer widget Create cleaner, more organized layouts by effortlessly adding either space between widgets or stylish dividers. Spacer widget magic 🚀Missing button groups? A familiar Quickbase experience allows you to style your button widgets easily. Button groups 🚀 Less clicks and less back-and-forth when working with tabs Rearranging tabs easily 🚀Update filters titles inline 🚀Excited about all of these upgrades? You can update your dashboards without having to rebuild them!534Views1like5CommentsIntroducing New Quickbase Navigation (beta)
3 MIN READ Quickbase is the world’s first platform for dynamic work management. And that means we wake up every day asking ourselves how we can make our customers more efficient and help them grow. We are continually improving the platform and adding new capabilities, so it is easier than ever for you to see, connect, and control your most complex processes. To do that, we want to make sure we continue to focus on providing an intuitive, clean user experience, which is the foundation on which the rest of Quickbase relies. That’s why we’re excited to announce the beta version of our new navigation. Here’s what to expect from our new navigation, and how you can try it out today. What’s changing? We rebuilt Quickbase’s navigation from the ground up to provide a more modern and intuitive experience for both you and your users. And, while we have future plans to add new functionality and concepts to our navigation, we’re not adding any new elements just yet. Instead, this initial release of our new navigation will re-arrange the components you use to navigate around your apps today. This approach will ease you and your users into this experience and make it easier to manage this change. Tables have moved to the left side Some may call it clunky; others call it dated, but we heard loud and clear from many of you that the Quickbase menus at the top of the page take up too much room. That’s why we’re moving app-level links to a new sidebar which you can find at the left edge of the page. Here, you can navigate to each table in your app. And if you are an app admin, you will find links to app settings and the user management page. We’re also providing centralized access to all your table settings with Settings for each table directly in the content menu are designed to save you time and clicks. It’s important to note that your existing table order and permissions will translate 1:1 from legacy navigation to the new style, so you’ll be able to hit the ground running without the need to re-calibrate your settings. With more room to breathe, you can see – and understand - more of your own data on your screen at once. There are several ways you can choose to interact with this menu, depending on how you like to get work done. You can open the sidebar by clicking the arrow to push content and maintain your open/closed state as you navigate across pages or simply hover anywhere over the closed sidebar to open temporarily and close automatically as you navigate. Switch between apps using the new global nav menu We’re cleaning up the experience of having to switch between apps with the app bar, by moving these controls to the top-left corner of the page. In this new waffle menu, you’ll be able to switch between apps. This is also where you will access other parts of Quickbase outside of apps, such as Pipelines and Exchange, enabling one-click access to key areas of the platform. Getting involved in the beta program Want to be one of the first to get your hands on the new nav? Your valuable feedback is pivotal to shaping our platform. Register here! Next steps The new navigation will be available for all users starting on May 8, 2024, with the ability to try it defaulted on. Each account admin can choose to disable the new navigation for their users under the Admin Console-> Permissions menu. If a user’s ability to turn the new navigation is not disabled, they can visit their user preferences and select sidebar navigation to try out the new experience. Happy navigating!871Views1like1CommentNew email notification beta has arrived
5 MIN READ NOTE: THIS BLOG WAS AUTHORED BY BrianCafferelli , BUT DUE TO TECHNICAL CHALLENGES, BRIAN WAS NOT ABLE TO PUBLISH. Companies around the world run time-sensitive, business-critical processes on Quickbase. And one of the ways this streamlines how you manage critical information is through our built-in email notifications. The ability to send alerts to the right people at the right time ensures that your team stays productive. We’ve upgraded much of the user interface across the Quickbase platform recently, such as reports and forms. And the next step in this journey is simplifying emails and making them more flexible. We’re proud to announce that we have re-built emails from the ground up. We are providing a new and modernized experience that supports new forms, allows you to pick the time of day an email is sent, and more. Read on to learn more what’s possible using new email notifications. Using new forms and notifications together We recently rolled out a new version of forms, providing a drag-and-drop building experience and giving you more control over the layout and appearance. However, using these new forms requires a separate legacy form to be built for emails as well. We are now making this build experience easier and more consistent, now that you can display a new form in a new email notification. This helps make your notifications more professional-looking and engaging. Embedding reports and charts Legacy emails in Quickbase allow you to send a single report to a group of users periodically. New email notifications will also allow you to send a chart, and even multiple reports or charts in the same email. This puts a lot of power into the hands of the app builder since you build these user interface elements such as reports, and can use them in many places such as dashboards and emails. Expanded options for the From field Being mindful of who appears in the From field of your email can help clarify who is driving the process at hand and help an email recipient to respond quickly. Quickbase enables you to set your From field to the generic “notify@quickbase.com”, or the user set in a User-type field. For example, an email on a compliance requests table could appear as coming from the user who placed the request. Our new email notification feature adds a few options for setting your “From” field. You can have your emails appear as coming from the owner of the email notification. Or you can even have emails appear as coming from the user who triggered the email in the first place. This gives you a great amount of flexibility to set up email notifications to match your exact process needs. Setting CC and BCC fields With the legacy emails, you can dynamically set the recipient based on data in Quickbase. For example, based on the Assigned To field in your table. This maps to the To field in the email message. However, it’s not possible to populate the CC or BCC fields today. New email notifications enable you to CC and BCC people. (This ability must first be enabled at the realm level) Attach files to your emails Using legacy emails, you could include a file attachment as part of the form or report being sent. New email notifications will let you go a step further and take a file from a File Attachment field in Quickbase and attach it directly to the email. Better bulk options We have also added more flexibility for managing bulk emails. For example, imagine that you have created an email notification which is sent when a record is edited. If a user clicks to edit a single record, then saves it, the email sent will reflect the changes made to that individual record. But what would you like to happen when a user enters grid edit mode, and updates many records at once? Legacy email notifications allow you to choose whether you want to send the email if many records were changed at once. Our new email notifications go one step further and make it easy to send individual emails (up to 10 at once), or to send a combined email that covers all the triggering records. Audit Logs We get support cases from builders asking to verify whether an email notification was sent, when it was sent, etc. The Quickbase Tech Support Team has access to that information today, but customers are not able to see it directly. When you leverage our new email notifications, account admins will be able to track usage of those emails in their Audit Logs. A streamlined builder experience We’ve also made it easier to build email notifications. We have combined the functionality of legacy notifications and legacy subscriptions together, allowing you to set up either a triggered email or a scheduled email. Need to change the trigger type later? No problem! Using the new email notifications, you will be able to go back afterwards and switch the trigger type without needing to create a new email from scratch. This also provides a more intuitive and streamlined experience, similar to how trigger behavior can be modified for a pipeline. For scheduled emails, you will also be able to specify the time of day the message will be sent. This is a long-time customer request which makes it easier to plan out your workflows. Our updated rich-text editor helps you to create impactful and professional messages, with new features like inserting report widgets into your emails. And you can still modify the HTML markup directly if you’d prefer. Tips for new builders To create notifications that are impactful, here are a few things to keep in mind: Leverage the conditions in the trigger to ensure the email is sent precisely when you need it to be Write out your email in a way that makes it clear why the recipient is receiving it, and what they should be doing upon receiving it Use rich text and images like your company’s logo to create a more engaging message. The future of legacy email notifications and subscriptions In order to make all the powerful improvements above to email notifications, we needed to re-build the feature from the ground up. That means that you will need to create new emails to take advantage of these new capabilities. However, we realize that most of you rely heavily on legacy notifications and subscriptions. So those legacy emails will continue to be available and operate exactly like they do today, and we do not currently have plans to change that behavior. Try it out today! We opened up our beta program for new email notifications to all users in March 2024. Simply navigate to table settings, and when you click the New button for emails you will see the new “Build your own” option. To learn more about new email notifications, please see the article in our help center.106Views0likes0CommentsWhat Will You Find in The Qrew?
3 MIN READ Hi there! I'm Ben. I'm the Community Manager for The Qrew. In March 2023, having no previous experience inCommunity Management,I changed roles here at Quickbase, moving from Customer Success. Why did I do this? I had no direct passion for Community Management overall. It wasn't some calling. What I did have was passion forthiscommunity, which since Empower 2023 we have called The Qrew. This community is different. It's unique. It's full of talented Quickbase Subject Matter Experts who come from all different types of backgrounds. Men and women. From full stack developers all the way down to people who google how to do things in Excel (me). We're all in The Qrew. Here's what you'll find. What you will find in The Qrew is connection. You are not on an island as a Quickbase builder/admin, even if you are the only person at your company who uses Quickbase. The Qrew is where you can connect with others, where you can see how others are using this platform to cut out gray work from our everyday lives. Our Qrew Groups program allows for members to meet either virtually or in person and share their Quickbase use cases. Check ourevents pagefor the next meetup. What you will find in The Qrew is information. There are so many ways you can Quickbase, which should make it very easy for you to feel comfortable asking ANY question here in Qrew Discussions. You will get an answer. You'll probably get ten answers. You can then choose the one you think is best. There are thousands of discussions in Qrew Discussions, all full of helpful information. Jump intoQuickbase Discussionsand see for yourself. What you will find in The Qrew is expertise. The best Quickbase subject matter experts in the world are all here. They're all answering each other's questions. When you're in The Qrew, people have your back. They've been where you are. They've been stuck, and The Qrew helped them get unstuck. Our Q Tips are designed to create knowledge articles that would be helpful to everyone in The Qrew. I'd encourage you tocheck this out, and then when the time comes, submit your own. What you will find in The Qrew are people who love this product, Quickbase. It changed their careers. But make no mistake, that love also means a desire to make Quickbase better. In The Qrew, we want Product Feedback. We want Quickbase to continue to add value in more ways. OurQrew Champions programis designed to reward customers for their acts of advocacy. I took this job in March 2023 because I saw the connections happening. I was blown away at both the amount and the quality of information being shared in our community. The expertise was off the charts. And I was struck at the passion and enthusiasm around this product from this customer base. Quickbase is different. So I'm proud to be in The Qrew. I know others are as well. If today's your first day as a Quickbase customer, welcome! Check out ourGetting Startedpage, designed to help you do just that with our product. Also, congratulations on making the best decision of your career! Welcome to The Qrew. You're in. Now what? That's up to you. But The Qrew has your back along the way. -Ben79Views0likes0CommentsUpcoming Changes to JavaScript in Quickbase
13 MIN READ If you’ve ever used JavaScript to modify UI or enable a non-native workflow in a Quickbaseapp, thispostis for you.We know thataddingcustom codeto an applicationcanbea valuable wayto extend Quickbase.However,weneed to providethis capability in a secure andsupportable way.To that end,Quickbaseprovides the ability touse custom codeincode pages.On the other hand, wealsoseebuildersinserting custom codeinto places it was never intended to beused. To improve the security and stability of the platform,weare changing the wayQuickbasehandlescustom code. Specifically, we are changing how the platform handlesJavaScript and unsupported HTML tags in places other than code pages.Code pages are wherecustom code has always been supported, and we encourage app buildersto insert itthere. We will roll out these changes throughout 2021. This post will cover the background on where custom code is supportedinQuickbase, and why it’s important for us to make a change. You can also find details about our plan below, and how that impacts you. Table of Contents Background Upcoming Changes Product Alternatives Next Steps FAQ Background For years, Quickbase builders have inserted JavaScript outside of code pages. This has been done to customize the UI or to automate workflow (such as reloading the current page). Yet custom code such as JavaScript was never intended to be used in a Quickbase app, except in code pages. Builders have shared many solutions like this on our community forum. You might see them called "Image OnLoad" or "Branding OnLoad". Because the added JavaScript codecannotbesanitized byQuickbase,it could openasecurityvulnerability thata sophisticated,malicious,builder couldtake advantage of.“Sanitizing” is simply making sure that an input into a field is what the software intended. For example,to sanitizea field thatsays“Image URL”, we would ensure itonly accepts a format likehttps://mywebsite.com/images/banner.pngand that it only contains secure content. None of the code within a code page can access the native Quickbase document object model (DOM). When you write custom code such as JavaScript in a code page, you are creating a new web page from scratch. This is why it is more secure to restrict JavaScript to being used only in a code page TheQuickbase platform includes many security measures which protect you against the risks mentioned above. For example, when you create a new app, any API call pointed at that app must include an application token. We have put in place policies to control cross-origin resource sharing (CORS). And we allow realm admins to restrict what type of content may be embedded as an iFramewithin their apps. But the work of building a platform withworld-class, enterprise grade securitynever stops.Our software engineers and system architects are always searching for opportunities to improve. Changing how JavaScript is handled inQuickbaseapps is the next step in that journey. Besides this security issue, it's impossible for us to test inserted JavaScript as we make changes to theQuickbaseplatform.A routine upgrade to anopen sourcelibrary,a change to styling, or to the DOM maycause these custom solutions to break without warning.As we progress with projects like the UI Refresh in 2021 and beyond, these kinds of changes will become more frequent. Inorder to move the platform forwardin a safe, secure, and sustainable way, we must close the loopholes that allow builders to insert unsanitized custom code into their apps. Upcoming Changes There arethreeareas of the product that need to have the loophole closed. We will close one area at a time, every two months starting in April 2021. Rich Text Fields, where customers could unintentionally allow end users to insert JavaScript. This area was closedin theApril 2021 release. Note: This does not include Formula-Rich Text fields. Custom Branding, where customers typically insert JavaScript to modify the UI in non-native ways. This area was closedin theJune2021 release. Formula Fields, where customers can write scripts to automate workflows.Examples of these includecascading deletes and executing multiple actions when a user presses a button. This area will beclosedin theAugust2021 release. This includes Formula-Rich Text fields. When an area is closed, builders will no longer be able to insert new JavaScript or editthe JavaScript that has been inserted intothe area.With these series of changes, wewill notremove or modify any existing custom code.Wewill notintentionallybreak any existing solutions that leverage these techniques.Buta change to styling, a change to the DOM, or an update toatechnical librarycould cause a solution tounintentionallybreak without warning. And, if a solution breaks for one of these reasons after the area has been closed, builders will not be able to edit the JavaScript to fix it. After we close each loophole,builderswill no longer be able to insert or update JavaScript in that part oftheirapps. For example, imagine you have a formula that contains JavaScript. You need to update the formula, so you open the field properties. In that case,we would pop up a message warning that the field contains unsupported content.Ifyou click Save without removing the JavaScript, youwillsee an error message preventing the save. Youmayhit cancel at that point, to back out and keep the previous configuration of your field. We encourage you to continue extending your ecosystem of apps using custom code. You can use custom code such as JavaScript incode pages, even after we close all the loopholes above. NOTE: The vast majority of custom code that's inserted into Quickbase apps outside of code pages is JavaScript code. However, the product changes above will not just restrict where JavaScript can be used. Those restrictions will apply to all custom code that is unsupported outside of code pages. The only custom code that may be used outside of code pages is: Simple HTML tags such as "a", "div", and "img". (See a complete list of supported HTML tags) Any native HTML attributes for those tags. (Such as the "width" and "height" attributes of the img tag) CSS style code which is included in-line, as part of one of the supported HTML tags above As a reminder, iFrame HTML tags are not supported outside of code pages and they will be affected by the product changes above. Product Alternatives Many agile companies extend their Quickbase apps today using custom code. This is a crucial tool for flexing and adapting to a fast-paced business environment. The intended workflow for Quickbase to interact with custom code is by having a formula-url or formula-rich text field as a button or link. Clicking on one of these would open a new browser tab, or redirect the current tab, to the code page. Custom HTML, CSS and JavaScript can be included in this code page. If desired, the page can close itself and redirect to the original page. For example, see the animation below: We will also work to make this even easier in the future. Overtime, we will address the majority of extensibility needs ina fewways: Our ongoing product initiatives have an increased focus on customization and powernatively. We know will not be able to build a native setting, switch or toggle for every possibility.Yet we conduct research and make data-informed decisions on where more flexibility makes sense. We will continueto absorbsmall items intofuture productiterationsthat customers need so custom code isn’t needed.Examples of this include, but are not limited to: Ability to useNowto get the live time a formula-urlwas pressed, rather than when the first pageloaded New formula functions likeUserRoles()andNameOfMonth() More control over the behavior of formula-urls Allow app builders to use JavaScript in certain areas outside of Code Pages. These would not allow arbitrary code to be inserted.Instead, they would support specific methods of extending aQuickbaseapp with custom code. For example, let's consider the new dashboards in beta as of February 2021.These new dashboards allow app builders to create filters which apply to all reports and charts on the page. We could allow a developer to create a custom chart type, which connects to the dashboard filter.Sowhen an app user clicks that filter, all the reports and charts on the dashboard would update - including the custom-coded charts.Thiswouldallow builders to create their own chart, and have itbehavenativelyand seamlessly for their users.We have many plans in this area. While this is not an overnightdeliverable, we are confident in the research we have done and our roadmapto deliver on this promise. Programming languages like JavaScript are powerful because they are open-ended. You can use JavaScript to solve virtually any problem if you have the time and technical know-how. ButQuickbaseis a no-code platform.Quickbaseis powerful because of how fast it allows you to build and update apps, deliver value and unlock insights within your data. So we will always focus on accelerating that speed and ease of use. We do not intend for Quickbase to become a full-fledged integrated development environment (IDE). Next Steps First, we want to be as transparentas possible,so app builders are aware of any risks in their applications. To that end, builders will begin seeing a warning in areas that have unsupported content in the near future. This will not prohibitchanges to these areas of the platform. Are you already thinking about some of your apps which use these JavaScript techniques? If so, please start planning how you can migrate to supported solutions.We have been loggingQuickbase apps that contain unsupported custom code. Those logs areonlyable to cover apps where you've updated theapp’s structurerecently.Soif you have anapp you're unsure about, you can update the properties of any field or table to get it added to the logs. That way, if that app does contain JavaScript or other types of unsupported custom code, it will appear in the logs the following day. On February 11th, we'll send an email inviting account admins to a Quickbaseapp so you can see where inserted JavaScript is being used. Ifyour account admindoesnot receive that email, it means that our logs do not show any inserted JavaScript in your account. Review the list of FAQs below.If youstillhave questions or need help, don’t hesitate to reach out to our Care team by submitting a ticket.We're happy to help identify alternative solutions.However, please note that we will not be able to interpret or troubleshoot custom code.If you find yourself in need of more hands-on assistance, we recommend engaging with one of ourQSPs, whom we can help you connect with. FAQ What is JavaScript Insertion? JavaScript Insertion occurs when custom JavaScript codeis addedto any part of aQuickbaseapp other than a code page. Some examples include formula fields, rich text fields, and custom branding.While officially not supported, these techniques are used to more deeply customize an app’s UI or workflow. While this has never been officially supported, the platform was not explicitly blocking this as it should have been.As we have added features to the platform over the years, many of the reasons why these techniqueswere usedhave become obsolete. What is changing with regards to JavaScript Insertion? We will begin restricting app builders from inserting JavaScript in formula fields, app branding, and rich text fields. Builders will no longer be able to insert new JavaScript code in those areas. We will also block edits to any existing JavaScript in those same places.These areas were never intended to allow for JavaScript insertion. You can still insert JavaScript in a Code Page, which is the appropriate place in a Quickbase application. Will these changes only affect inserted JavaScript code? The vast majority of custom code that's inserted into Quickbase apps outside of code pages is JavaScript code. However, the product changes above will not just restrict where JavaScript can be used. Those restrictions will apply to all custom code that is unsupported outside of code pages. The only custom code that may be used outside of code pages is: Simple HTML tags such as "a", "div", and "img". (See a complete list of supported HTML tags) Any native HTML attributes for those tags. (Such as the "width" and "height" attributes of the img tag) CSS style code which is included in-line, as part of one of the supported HTML tags above As a reminder, iFrame HTML tags are not supported outside of code pages and they will be affected by the product changes above. When will these changes take place? Throughout a series of releases in 2021. After the April 2021 release, users will no longer be able to insert JavaScript into Rich text fields. After the June 2021 release, users will no longer be able to insert JavaScript into Custom Branding. After the August 2021 release, users will no longer be able to insert JavaScript into Formula Fields. Why do we need to make these changes? Custom JavaScript inserted into these areas is not sanitized byQuickbase. This opens the platform up to potential attacks from malicious users, to modify pages or gain access to protected data. Such custom code is also impossible forQuickbaseto test. This means routine changes to the platform could(and do)cause a solution to break without warning.Closing these loopholes allows us to provide a more supportable, enterprise-grade platform. It also enables our support resources to triage and troubleshoot moreeffectively. How are we informing customers of this change? On February 11, 2021, we will emailAccountAdminswho will be affected by this change. The email will include a link to aQuickbaseapp which will help you locate inserted JavaScript in your apps. We will email thoseAccountAdmins beforewe make each of the product changes above. Those changes will take affect with our product releases in April 2021, June 2021, and August 2021. Application Managers will also see warnings in apps that include inserted JavaScript. For example, a message will appear if you edit the properties of a formula that includes inserted JavaScript. What will happen with existing JavaScript solutions? We will not be making any changes to existing objects that contain inserted JavaScript at this time, or during any of the releases mentioned above. That means that solutions that leverage inserted JavaScript should continue to work as they were designed. However, builderswill not be able to save changes to these objects after their respective release. After the April 2021 release, you will not be able to make changes to JavaScript within Rich Text fields. After the June 2021 release, you will not be able to make changes to JavaScript within Branding. After the August 2021 release you will not be able to make changes to JavaScript within Formula fields. As always, these solutions might break as a result of a routinechangewe make to theQuickbaseplatform.For example, upgrading a technical library, or changing either our styling or our Document Object Model (DOM) could cause inserted JavaScript to stop working. What will happen if a builder attempts to save changes to an object with inserted JavaScript? After we close each loophole, builders will no longer be able to insert or update JavaScript in that part of their apps. For example, imagine you have a formula that contains JavaScript. You need to update the formula, so you open the field properties. In that case, we would pop up a message warning that the field contains unsupported content. If you click Save without removing the JavaScript, you will see an error message preventing the save. You may hit cancel at that point, to back out and keep the previous configuration of your field. What will happen if I copy an app with inserted JavaScript? Customers should be able to copy applications with unsupported JavaScript. The inserted JavaScript will carry over to the copied app. As with any inserted JavaScript, after weclose downthe area it is inserted in, builders will not be able to edit it. Should I remove all inserted JavaScript from myQuickbaseapps? We are not removing or modifying any existing inserted JavaScript. You can continue to use your apps that contain inserted JavaScript. But, while we are not intentionally breaking any solutions that rely on inserted JavaScript, these solutions could break as a result of a routine change to the platform, like a change to styling, an upgrade to technical libraries, or a change to the Document Object Model (DOM). As we progress with the UI Refresh Initiative, these changes will become more frequent, increasing the chances that your apps could break. If you want to avoid that risk, you should explore alternative, supported solutions to the problems you’re solving with inserted JavaScript. What if I need help? If you’re still not clear on exactly what is changing, or have a specific question about your account, you can always submit a support case to our Care team. Also, ourQuickbaseSolution Providers(QSPs)area network of professional services firms that you can contract withtohelp you plan for and execute any changes to your apps that you might deem necessary as a result of this announcement. They can help you identify and implement alternative, supported solutions to the problems you currently solve with inserted JavaScript. If you are working with aQSP already, you can follow up with that partneror find a potential partnerhere. Wealsohave a list of partners whoare providing services offeringstospecificallyhandleJavaScriptissues.If you wouldlikea referralto a partner or potential partners, submit a support case, and a support representative canprovidethis for you. Canbuildersstill insert JavaScript into code pages? Yes, users are encouraged to use code pages to leverage custom code for theirQuickbaseapplications. These code pages should be used standalone, rather than attempted to be “injected” into aQuickbasepage. What ifIneedhelp identifyingmyinsertedJavaScript? The first place to look is the Inserted JavaScript Usage app. This is a Quickbase app that lists where inserted JavaScript is used in your apps. It includes details such as Field ID for formulas that include inserted JavaScript. On February 11, 2021, we will email a link to this app to Account Administrators. We will send this email only to accounts we've detected are using inserted JavaScript. Not sure whether a specific app includes inserted Javascript? You can check this by opening the app in question, then making any schema change. For instance, you could add a new field or update the properties of an existing field. Then, you can check the Usage app one day later. We update the Usage app daily. So if the app in question still does not appear in the Usage app then you do not need to take further action. Will Copy Master and Details buttons be affected? No, as long as you are using your Copy Master and Details button as it was originally generated (i.e. no changes were made to the formula) it should not be affected by these changes. If you have Copy Master and Details buttons, you may have received a warning in your application about the presence of unsupported content. To be clear, after the August release, you will not be able to edit these formulas. However, unlike other formulas that contain JavaScript, these buttons will continue to work as designed and do not need to be replaced with alternative solutions.70Views5likes63Comments