Introduction
Low-code and no-code platforms have transformed how developers and non-developers build applications. Instead of writing thousands of lines of code, you can use visual builders and APIs to create databases, automate workflows, and deploy custom tools in hours. But even the best platform is only as useful as the instructions you give it. That’s where prompts come in — clear, structured commands that tell your low-code tool what to do.
This article collects 30 battle-tested prompts for three popular platforms: Airtable, Bubble, and Retool. Each prompt includes a real usage example and a note on why it works. Whether you’re building a CRM, a dashboard, or an internal app, these prompts will save you time and reduce errors.
Why Prompts Matter in Low-Code Platforms
Prompts are not just for AI. In low-code environments, a prompt is a human-readable instruction that the platform interprets into actions. For example, in Airtable, a prompt might be a formula that calculates a field; in Bubble, it could be a workflow condition; in Retool, it’s often a SQL query with parameters. The quality of your prompt directly affects the quality of your output. A vague prompt leads to bugs; a precise one generates reliable logic.
Key benefits of structured prompts:
- Faster development: reuse patterns across projects
- Fewer errors: explicit conditions handle edge cases
- Easier maintenance: clear instructions help teammates understand your logic
Prompts for Airtable
Airtable is a spreadsheet-database hybrid. Its power lies in linked records, formulas, and automations. Here are 10 prompts that solve common problems.
| # | Prompt | Usage Example | Why It Works |
|---|---|---|---|
| 1 | "Calculate days between two dates, excluding weekends" | NETWORKDAYS({Start Date}, {End Date}) |
Built-in function; no manual calculation |
| 2 | "Sum values from a linked table where status is 'Active'" | SUM(Lookup(‘Transactions’, 'Amount', {Status}=‘Active’)) |
Filters before summing |
| 3 | "Automatically assign a record owner based on region" | IF({Region}=“EMEA”, “Anna”, IF({Region}=“APAC”, “Bob”, “Charlie”)) | Simple nested IF; no scripting |
| 4 | "Send an email notification when a priority field changes to 'Critical'" | Automation trigger: when {Priority} changes → send email | Low-code automation; 2 clicks |
| 5 | "Create a unique ID for every new record" | DATETIME_FORMAT(CREATED_TIME(), 'YYYYMMDDHHmmss') |
Timestamp-based; no duplicates |
| 6 | "Format a phone number into (XXX) XXX-XXXX" | REGEX_REPLACE({Phone}, '(\d{3})(\d{3})(\d{4})', '($1) $2-$3') |
Standardises input |
| 7 | "Roll up all comments from linked tasks into one field" | ARRAYJOIN(Lookup(‘Tasks’, 'Comments'), ', ') |
Concatenates multiple values |
| 8 | "Flag records older than 30 days" | IF(DATETIME_DIFF(TODAY(), {Created}, 'days') > 30, 'Old', 'Current') |
Simple date comparison |
| 9 | "Assign a category based on numeric score" | IF({Score} >= 90, 'A', IF({Score} >= 80, 'B', 'C')) |
Tiered classification |
| 10 | "Find records where the field is empty" | IF({Email} = BLANK(), 'Missing', 'Present') |
Identifies data gaps |
Real-world case: A marketing team used prompt #4 to automatically notify the sales rep when a lead status changed to “Hot”. This reduced response time from 4 hours to 2 minutes.
Prompts for Bubble
Bubble is a full-stack no-code platform. You build workflows visually, but many actions require precise conditions. Here are 10 prompts that streamline Bubble development.
| # | Prompt | Usage Example | Why It Works |
|---|---|---|---|
| 11 | "Only show the 'Delete' button if the current user is the creator of the thing" | Current User = Thing's Creator |
Simple equality check |
| 12 | "Sort a repeating group by a custom field in descending order" | In RG settings: sort by {Price} descending | Built-in sorting; no code |
| 13 | "Prevent form submission if email field is not valid" | Condition: Email field is not empty AND Email field contains '@' |
Client-side validation |
| 14 | "Update a user's profile picture after uploading" | Workflow: Upload file → save to User → update field | Sequence of actions |
| 15 | "Calculate total price with tax and discount" | Price + Price * 0.2 - Discount |
Arithmetic in expression editor |
| 16 | "Schedule a workflow to run every Monday at 9 AM" | Use Bubble's backend workflow with recurrence | No need for external cron |
| 17 | "Send a push notification to all users in a group" | Workflow: Loop through list of users → send push | Batch operation |
| 18 | "Redirect user to login page if not authenticated" | Condition on page load: Current User is empty → Go to page Login |
Security best practice |
| 19 | "Show a loading indicator while data is being fetched" | Set state Is Loading = Yes → show indicator → after fetch set No |
Improves UX |
| 20 | "Log every user action to an audit table" | Workflow: after any action → create new record in Audit log | Simple event capture |
Real-world case: A startup built an MVP for a rental marketplace. Using prompt #11, they ensured tenants could only cancel their own bookings. This saved weeks of backend development.
Prompts for Retool
Retool is a low-code platform for building internal tools. It connects to databases and APIs. Prompts here are often SQL queries or JavaScript snippets. Here are 10 prompts for common tasks.
| # | Prompt | Usage Example | Why It Works |
|---|---|---|---|
| 21 | "Fetch all orders from the last 7 days" | SELECT * FROM orders WHERE created_at >= NOW() - INTERVAL '7 days' |
Date filter; efficient |
| 22 | "Insert a new user only if email doesn't exist" | INSERT INTO users (email, name) SELECT {{email}}, {{name}} WHERE NOT EXISTS (SELECT 1 FROM users WHERE email = {{email}}) |
Prevents duplicates |
| 23 | "Update inventory after an order is placed" | UPDATE products SET stock = stock - {{quantity}} WHERE id = {{productId}} |
Atomic operation |
| 24 | "Pivot sales data by month" | SELECT DATE_TRUNC('month', order_date) AS month, SUM(amount) FROM orders GROUP BY 1 |
Built-in SQL function |
| 25 | "Call an external API with authentication" | fetch('https://api.example.com/data', { headers: { 'Authorization': 'Bearer {{token}}' } }) |
Standard JS fetch |
| 26 | "Format a date as 'Month DD, YYYY'" | {{formatDate(order_date, 'MMMM DD, YYYY')}} |
Retool's formatDate helper |
| 27 | "Show a confirmation modal before deleting" | On button click: await triggerModal('confirmDelete') → then delete |
User experience safety |
| 28 | "Apply a filter to a table based on user input" | SELECT * FROM customers WHERE name ILIKE '%{{searchText}}%' |
Case-insensitive search |
| 29 | "Export table data to CSV" | Use Retool's built-in Export button | No code needed |
| 30 | "Cache a slow query result for 5 minutes" | Retool's query cache: set TTL to 300 seconds | Reduces database load |
Real-world case: A fintech company used prompt #23 to update account balances in real-time. The atomic update prevented double-spending errors — a critical requirement for financial apps.
How to Create Your Own Prompts
Writing good prompts is a skill. Follow these guidelines:
1. Be explicit — state the condition, action, and exception
2. Use platform-specific functions — each platform has unique helpers (e.g., Airtable’s NETWORKDAYS, Bubble’s formatDate)
3. Test with sample data — run your prompt on a small dataset before deploying
4. Document your logic — add comments or descriptions for future readers
Conclusion
Low-code and no-code platforms are not magic — they’re tools that execute your instructions. The prompts you write determine whether your app is robust or fragile. The 30 prompts above cover database operations, user interactions, data validation, and automation. Copy them, adapt them, and build faster.
Remember: the best prompt is the one that works for your specific use case. Start with these examples, then iterate. Your future self — and your team — will thank you.
ASI Biont supports connecting Airtable, Bubble, and Retool to your data pipelines. For advanced integrations, check our guides on asibiont.com/courses.
Comments