Introduction
Low-code and no-code platforms have revolutionized how teams build internal tools, automate workflows, and manage data without writing traditional software. As of July 2026, platforms like Airtable, Bubble, and Retool are at the forefront, each offering unique strengths: Airtable for flexible database management, Bubble for fully visual web app development, and Retool for rapid internal tool creation. However, maximizing these tools requires more than clicking around — you need to speak their language through well-structured prompts. This article presents 15 proven prompts organized by skill level (basic, advanced, expert) to help you generate formulas, debug workflows, and design logic faster than ever.
Why Prompts Matter for Low-Code/No-Code
Prompts — whether you feed them into an AI assistant (like ChatGPT or Claude) or use them as mental templates — serve as blueprints for solving specific problems. A well-crafted prompt can generate complex Airtable formulas, suggest Bubble workflow patterns, or configure Retool SQL queries. According to a 2025 survey by Gartner (cited in their Low-Code Development Technologies report), teams using structured prompt libraries saw a 40% reduction in development time for internal tools. The key is specificity: vague prompts yield generic results, while precise prompts with context produce production-ready outputs.
Basic Prompts (Beginner Level)
These prompts focus on simple formulas, basic automations, and introductory logic. They assume you know the platform's UI but need help with syntax.
| # | Task | Prompt | Example Result |
|---|---|---|---|
| 1 | Airtable: Count linked records | "Generate an Airtable formula to count how many records in a linked table called 'Tasks' are linked to the current record in 'Projects'." | COUNTA(ARRAYUNIQUE(Tasks)) — returns the number of unique linked tasks. |
| 2 | Bubble: Toggle element visibility | "Write a Bubble workflow that toggles the visibility of a group named 'AdvancedFilters' when a button is clicked. Use a custom state." | Create a custom state isVisible (boolean, initial: no). In the button's workflow, set isVisible to not isVisible. On the AdvancedFilters group, set condition: "This group is visible when isVisible is yes". |
| 3 | Retool: Display current user email | "In a Retool query, show the current user's email in a text component. Use the built-in current_user object." |
In a Text component, set the value to {{ current_user.email }}. |
| 4 | Airtable: Format date as month-year | "Write an Airtable formula to convert a date field called 'Start Date' into a 'MMM YYYY' format, e.g., 'Jul 2026'." | DATETIME_FORMAT({Start Date}, 'MMM YYYY') |
| 5 | Bubble: Validate email format | "Create a Bubble condition that checks if an input's value matches a basic email pattern before allowing form submission." | In the Input's validations, add: "This input must be a valid email" — Bubble automatically uses regex for RFC 5322. Alternatively, use a custom state and a regex check in the workflow. |
Practical Tip for Beginners
Start with Airtable formulas since they're the most forgiving — you can test each expression immediately in the formula editor. For Bubble, always test workflows using the "debug" mode to see state changes step by step. Retool's JSON preview is your friend for checking query outputs before binding to UI.
Advanced Prompts (Intermediate Level)
These prompts involve multi-step logic, API integrations, and data manipulation across platforms.
| # | Task | Prompt | Example Result |
|---|---|---|---|
| 6 | Airtable: Conditional rollup with date filter | "Create a rollup field in Airtable that sums 'Amount' from linked 'Orders' table, but only for orders where 'Order Date' is within the last 30 days." | Use a helper formula field in the Orders table: IF({Order Date} >= TODAY() - 30, {Amount}, 0). Then in the rollup, sum that helper field. |
| 7 | Bubble: Paginated API call with search | "Set up a Bubble workflow that calls an external API (e.g., GitHub search) with a search term input, and displays paginated results using Next/Previous buttons." | Create a custom state page (number, initial 1). When search button is clicked, call API with params: q = input value, page = page state, per_page = 10. Store results in a repeating group. Next button increments page, Previous decrements. |
| 8 | Retool: Dynamic SQL query with user permissions | "Write a Retool query that fetches records from a PostgreSQL table 'employees' but only returns rows where the department matches the current user's allowed departments, stored in a user attribute." | SELECT * FROM employees WHERE department = ANY({{ current_user.allowed_departments }}) — assuming allowed_departments is an array in the user object. |
| 9 | Airtable: Auto-increment ID with prefix | "Generate an auto-incrementing field in Airtable that creates IDs like 'PROJ-0001', 'PROJ-0002', etc., using an automation." | Create an automation: trigger on new record, find the max numeric part of existing IDs, increment, then update the record's ID field with 'PROJ-' & TEXT(MAX(ARRAYFLATTEN(VALUE(RIGHT({ID}, 4)))) + 1, '0000'). |
| 10 | Bubble: Multi-step form with data caching | "Build a Bubble multi-step form that saves partial inputs to a temporary data type before final submission, preventing data loss on page reload." | Create a custom data type "FormDraft" with fields for each step. On each step's "Next" button, save the current inputs to a new FormDraft record (or update if exists). On final step, create the actual data type record and delete the draft. |
Practical Tip for Intermediates
When working with APIs in Bubble, always set "Send dynamic data as JSON" to yes in the API workflow call. For Retool, use transformation queries (JavaScript) to massage API responses before binding to table components — it keeps your UI logic clean.
Expert Prompts (Advanced Level)
These prompts involve complex chaining, custom JavaScript/scripting within the platform, and architectural decisions for production systems.
| # | Task | Prompt | Example Result |
|---|---|---|---|
| 11 | Retool: Real-time collaborative editing with WebSockets | "Implement a Retool app that allows multiple users to edit a shared text field in real-time using WebSockets connected to a backend (e.g., Supabase Realtime)." | Create a resource query that subscribes to a Supabase Realtime channel on a table. Use a state variable sharedText that updates on every broadcast. Bind a Textarea to sharedText and on change, upsert the change to the database via a mutation query. |
| 12 | Airtable: Recursive parent-child hierarchy | "Write a script in Airtable Scripting Block that builds a full path (e.g., 'Parent > Child > Grandchild') for a hierarchy of categories, where each record has a self-link to its parent." | Use a recursive function: function getPath(recordId) { let record = base.getTable('Categories').selectRecordAsync(recordId); let parent = record.getCellValue('Parent'); return parent ? getPath(parent[0].id) + ' > ' + record.name : record.name; } Apply to all records and update a field. |
| 13 | Bubble: Server-side action with custom encryption | "Create a Bubble server-side action that encrypts sensitive data (e.g., SSN) using AES-256 before storing it, and a workflow to decrypt it for authorized users." | Use the "Run JavaScript" action (available in Bubble's server-side workflows) with the CryptoJS library. Encrypt: CryptoJS.AES.encrypt(data, 'secretKey').toString(). Store encrypted string. Decrypt only in a backend workflow that checks user role. |
| 14 | Retool: Multi-step approval workflow with audit log | "Build a Retool app that implements a 3-step approval process (submitted → manager review → director approve) with an audit log table tracking who acted and when." | Use a state machine with custom states: approvalStatus. Each action (submit, approve, reject) triggers a query that updates the status and inserts a row into an audit_log table with user, action, timestamp, record_id. Use Retool's current_user.id for user tracking. |
| 15 | Multi-platform: Sync Airtable with Retool via webhook | "Set up a webhook in Airtable that sends new record data to a Retool endpoint, which then inserts the data into a PostgreSQL database and updates a dashboard component in real-time." | In Airtable: create an automation with trigger "When record created" and action "Send webhook" to a Retool REST API query URL. In Retool: create a resource query that listens to incoming webhooks (via a public endpoint), validates the payload, and runs an SQL INSERT. Then trigger a refreshData event on the dashboard table. |
Practical Tip for Experts
For production systems, always implement idempotency keys in webhook receivers (e.g., use Airtable record ID as idempotency key in Retool) to prevent duplicate entries. Test script blocks in Airtable with a small sample before running on full base — the undo button is limited.
Conclusion
Mastering prompts for low-code and no-code platforms isn't just about saving keystrokes — it's about thinking systematically. The 15 prompts above cover the spectrum from simple formula generation to sophisticated multi-platform orchestration. As these platforms continue to evolve (Airtable's new scripting engine, Bubble's server-side workflows, Retool's improved state management), the ability to craft precise, context-rich prompts will become a core skill for any builder. Start with the basics, then gradually incorporate advanced patterns. In our next article, we'll explore how to build a complete inventory management system using these prompts as building blocks.
ASI Biont supports integration with Airtable, Bubble, and Retool through its comprehensive low-code API connector — detailed guidance available on asibiont.com/courses.
Comments