December 2022 Summaries

The final installment of the 12 Days of Retool series showcases the integration of OpenAI's DALL-E and ChatGPT APIs with Retool to generate AI-driven poetry and images. This tutorial guides users on connecting REST APIs to a Retool instance, specifically focusing on using OpenAI's GPT-3 model DaVinci to create quatrains—stanzas of four lines with a rhyme scheme—and dynamically generating images to accompany them. It provides a step-by-step process, including obtaining OpenAI API keys, setting up resources within Retool, and creating queries to generate and display the AI-produced content in a Retool app. The tutorial demonstrates the use of Retool's components to input requests and visualize results, emphasizing the experimental potential of integrating AI-generated content into applications. This series highlights creative opportunities with AI tools while offering practical insights for developers interested in enhancing their apps with unique, automated content generation.

On day 11 of the 12 Days of Retool, the focus is on using Retool components to create a custom video player for showcasing highlights of the top 11 FIFA World Cup games from 2022. The process involves leveraging the Table Component for navigation, the Video Component for video playback, and integrating with custom REST APIs and YouTube’s API to fetch game data and video descriptions. By utilizing JavaScript and querying techniques, users can interact with a table to select games and view corresponding highlights, with additional metadata displayed in a sidebar. This exercise demonstrates Retool's capability to create interactive applications, encouraging users to explore new functionalities for their own projects.

Day ten of the "12 Days of Retool" series presents a curated collection of ten instructional videos designed to enhance users' knowledge and application of Retool, a platform for building custom internal tools. The videos cover a range of topics, including introductory guides, the use of Retool Modules for reusability, automation with Workflows, and the integration of new UI components like the Sidebar. Additionally, tutorials demonstrate how to quickly generate APIs from CSV files, reference data in components, and embed custom features like a Twilio dialer. Users are also shown how to build practical applications, such as an S3 file explorer or a CRM integrated with Google Sheets, PostgreSQL, and Stripe. This diverse video lineup aims to unlock new possibilities for app development within Retool, offering both newcomers and seasoned users valuable insights into maximizing the platform's capabilities.

The ninth day of the "12 Days of Retool" series focuses on a Retool application that enables users to rank and share their preferences for Star Wars Episodes 1-9. This application utilizes Retool components like the List View and Table, as well as Retool DB, to display and store user rankings. It features JavaScript and SQL queries to dynamically load and save user preferences, generate unique identifiers, and aggregate community rankings. Users interact with the application by rearranging movie rankings through a series of buttons, and these preferences are stored in a database for community analysis. The application is described as a simple yet effective demonstration of Retool's capabilities, blending interactive UI components with backend data storage and retrieval.

On the eighth day of the "12 Days of Retool" series, the focus is on creating a simple 8-bit arcade app using Retool, leveraging features such as iframes, temporary state variables, and list view components. The project involves embedding eight famous games, like Super Mario Bros and Pac-Man, using the Retool IFrame component, which allows HTML pages to be embedded within apps and requires specific permissions for emulators to function. Temporary state variables store game data, while the List View component dynamically renders this data, eliminating the need for repetitive code. The app enables users to switch between games using a Play button, which modifies the IFrame URL upon each click, offering a streamlined approach to displaying multiple games within a single interface. The post encourages further exploration of the Retool blog for additional holiday hacks in the ongoing series.

Retool has significantly expanded its Startup Program, now offering eligible startups $25,000 in Retool credits for the first year, alongside over $200,000 in credits from partners such as AWS, Brex, and Segment. Designed for early-stage companies, the program aims to streamline internal operations and automate workflows, helping startups focus on product-market fit without financial stress. The initiative reflects Retool's own experience as a startup, where automated tools reduced costs and improved efficiency. Participants can use credits to build various applications and workflows, benefiting from features like permission groups and audit logs, with an additional 25% discount available in the second year. Retool's partnership deals include significant offers from companies like Twilio, Zendesk, and others, promoting integration and synergy with other tools. The program is open to companies founded within the past 10 years, from bootstrapped to Series A stages, and does not require a credit card for participation.

Retool Workflows is a feature within Retool that allows developers to automate recurring tasks and backend processes that typically occur outside a user interface, enhancing efficiency and productivity for startups. The described use case, "Big Fish Swimming," demonstrates how Retool Workflows can be utilized to monitor new customer signups, particularly targeting larger companies by integrating with the Clearbit API to obtain company size data. When a new signup occurs, a webhook triggers a workflow that fetches information from Clearbit, and based on the company size, sends a Slack notification to the sales team for personalized outreach if the company is large. Otherwise, it triggers an automated thank you email with a promo code for smaller companies. This workflow exemplifies how startups can leverage Retool Workflows to optimize customer engagement strategies by automating decision-making processes based on market data.

Operations software, often overlooked by developers, is a crucial category of custom software designed to streamline and codify the unique business processes of teams and individuals, distinct from public-facing applications like e-commerce sites or widely-used SaaS products such as Salesforce. This type of software, exemplified by tools like LeadGenius' cost-tracking dashboard and Stripe's incident response system, focuses on enhancing productivity and managing workflows that are highly specialized to an organization's internal needs. Despite its potential to save time and yield significant financial returns by automating processes, operations software often struggles for prioritization due to the high costs and resource demands of traditional software development, which typically favors revenue-generating public applications. Developers are encouraged to leverage new technologies, like no-code tools for knowledge workers and platforms such as Retool for developers, to overcome these challenges and enable more efficient creation of operations software. Investing in operations software can transform business operations by enhancing productivity and employee satisfaction, ultimately allowing companies to address both major and minor operational problems effectively.

Retool's new unified command palette enhances the developer experience by enabling quick search and execution of app actions without privileging one experience over the other. Recognizing the need for faster workflows, Retool introduced a command palette that integrates content and action searches into a single interface, divided into sections for actions, components, and code, while featuring a "Top result" section to ensure the best matches are easily accessible. The design process focused on eliminating the complexity of separate search modalities and managing global, app-level, and component-level scopes intuitively. By allowing users to navigate seamlessly between different scopes and keeping the command palette open for power users, Retool aims to streamline the development process, facilitating a faster and more efficient way to build complex applications. The command palette is now available for all cloud customers and will be included in the upcoming on-premise release, with plans for further integration of advanced functionalities like component creation and code editing.

Retool has launched the Command Palette, a tool designed to streamline the process of running commands and locating features within the platform, enhancing speed and efficiency. Accessible via a keyboard shortcut or search icon, the Command Palette allows users to execute frequent actions, such as editing a text input nested in a tabbed container, significantly faster than before, reducing the process from 14 seconds to just 6 seconds. It supports over 90 app actions and integrates both search and command execution, enabling rapid access to components, queries, and other resources within the app editor. This innovation, now available to all cloud customers and soon to be available on-premise, is the result of extensive research and feedback from users, aimed at accelerating app development and improving user experience in Retool.

On day six of the "12 Days of Retool" series, the focus is on Retool's new Command Palette, a tool designed to enhance productivity by allowing users to quickly search for and manage components, queries, and resources within the app editor. Accessed through a simple keyboard shortcut (Cmd+K for Mac or Ctrl+K for Windows), the Command Palette enables users to efficiently locate and select components, edit their properties, and navigate across different apps and shared resources within an organization. It also provides access to app history and support from the Retool community. With over 90 available actions, this tool aims to streamline the app-building process, offering a faster way to perform various tasks without leaving the keyboard. The series continues to provide daily insights into Retool's capabilities, with upcoming posts promising further exploration of its features.

The newly released Sidebar frame in Retool offers developers a versatile tool for enhancing the functionality and usability of their applications by providing a structured layout that aids in managing complex content through vertical information display. It is particularly useful for implementing left navigation in multi-screen apps, as it supports breaking down larger applications into smaller ones for better performance and easier maintenance. The Sidebar can also be utilized as a collapsible container for search and filter functionalities, freeing up screen space, and facilitating in-page navigation with tabs and scrolling options. Additionally, it serves as a convenient location for bookmarks and user preferences, as demonstrated through a sample application that uses local storage for bookmark management. Overall, the Sidebar frame is a significant enhancement to Retool's UI toolkit, enabling developers to integrate common design patterns such as left-hand navigation and filtering, thereby increasing the usability of their apps.

In day four of the "12 Days of Retool" series, the focus is on demonstrating the use of Retool to perform basic CRUD operations (create, read, update, delete) using HTTP verbs for a REST API. The post explains how to create a resource for an API endpoint using Retool's Generate API from CSV tool and walks through testing these operations using a Books API. It outlines the process of sending GET, POST, PUT, DELETE, and PATCH requests to manipulate book records, emphasizing the ease of testing API functionality within a Retool app. The tutorial is part of a broader series aimed at showcasing Retool's capabilities, with previous posts covering topics like JavaScript operators, and upcoming ones set to explore additional features.

On the third day of the "12 Days of Retool" series, the focus is on exploring the strict equality operator in JavaScript, a topic that often causes debate among developers due to its handling of type coercion. Unlike the regular equality operator, which attempts to convert the compared values to the same type, the strict equality operator compares values without type conversion, leading to different outcomes in certain scenarios. To illustrate this, a simple Retool application is introduced, allowing users to test the behavior of both comparison operators by inputting two values that can be parsed as JSON, with JavaScript transformers used to render the results dynamically within the application's UI. These transformers, akin to computed properties in frameworks like Vue, enable the creation of complex values based on the application's current state, enhancing the user interface without embedding intricate logic directly. This exploration aims to clarify the concept of "truthiness" and "falsiness" in JavaScript, providing developers with a hands-on tool to better understand these operators while also hinting at future posts in the series that continue to delve into various programming topics.

Retool offers a comprehensive hackathon starter pack to streamline the process of developing impactful projects, emphasizing the importance of scoping ideas and leveraging pre-built components and integrations. By using Retool, teams can bypass complex setup tasks typical of traditional development environments, such as React, and focus on creating applications with clear goals and user benefits. The platform supports a wide range of integrations, making it easier to address organizational challenges quickly. Key strategies include configuring resources beforehand, establishing parallel workflows, and designing intuitive user interfaces. Retool also provides guidance for presenting projects effectively, highlighting problem-solving and the functionality of the developed solution. With Retool, hackathon participants can quickly build, test, and deploy apps, ensuring their projects are not only demos but functional tools that address real-world issues, positioning Retool as both a facilitator for hackathons and a potential staple for internal enterprise solutions.

The second day of the "12 Days of Retool" series focuses on the concept of tuples and their use in JavaScript, despite the language not having tuples as a native data type. The discussion explores how tuples, which are ordered and immutable lists of items in languages like Python, can be mimicked in JavaScript using arrays with semantically meaningful positions, especially for data consistency and performance optimization. The article highlights scenarios where using tuple-like structures in JavaScript is beneficial, such as representing naturally related data or maintaining positional significance, with practical examples provided in React, particularly with state management using hooks like useState in Retool custom components. Additionally, it contrasts this with the state management approach in Retool apps using the "model" object and "modelUpdate" function, demonstrating how to manage state both locally and globally within Retool applications.

Retool's new free plan has significantly increased usage among developers, allowing teams of up to five to build unlimited apps without cost, featuring a full UI component library and native integrations. This initiative has led to a 50% increase in the number of actively shared and used apps, as it empowers more team members, including those in support and sales, to contribute to software development. The free plan includes tools for debugging, automating workflows, and deploying mobile apps, among other features, which has enabled new users to replace manual processes with custom software quickly. Retool's approach allows even small teams, such as those in financial services, to build scalable apps that evolve as their needs change, demonstrating significant potential for transforming operations through accessible software development.

Retool's Developer Experience team is celebrating the holiday season by sharing twelve JavaScript and Retool platform hacks, with new posts released daily from December 7th to 22nd. The series, starting with a detailed exploration of abstract syntax trees (AST), demonstrates how to create and visualize ASTs using Retool and the Acorn library. This initial hack guides users through importing external JavaScript libraries into Retool, generating ASTs from code input, and displaying them using Retool's JSON visualizer. The project highlights ASTs' role in programming and showcases Retool's capabilities in building interactive applications. This initiative aims to engage and educate developers by offering innovative coding solutions, with subsequent posts featuring additional hacks like "Two Tuple Hacks."

Internal applications often suffer from complexity and dense information, leading to poor user experiences due to unclear information hierarchy and actions. To address this, a new Sidebar frame has been introduced alongside the existing Header frame, facilitating more intuitive layouts for Retool applications. The Sidebar allows for vertical navigation, making it easier to manage multi-page apps with numerous top-level menu items, and supports in-page navigation to enhance usability through progressive disclosure. This feature also includes a collapsible option to reduce interface clutter, enabling users to focus on primary tasks by hiding secondary information. Additionally, the update enhances scripting APIs and customization opportunities, allowing dynamic control over frame visibility and navigation content. These improvements aim to simplify complex app interfaces, and are available to cloud customers, with plans to extend to on-premise users in future releases.

Advent of Code is an annual coding event in December that provides daily programming challenges to help developers enhance their skills through engaging puzzles woven into a festive narrative by creator Eric Wastl. Participants can tackle these challenges using any programming language and environment they prefer, with the flexibility to download unique input data for processing. A suggested method for JavaScript developers includes using a Retool environment to manage input and output solutions. The article illustrates the process through the Day 1, 2022 challenge, where developers must calculate calorie totals for elves based on input text, with solutions provided for both individual and collective calorie sums. The event encourages creativity and efficiency in problem-solving, inviting developers to reflect on and improve their coding strategies.