Introduction
Low-code and no-code platforms have democratized software development, enabling teams to build apps, automate workflows, and analyze data without deep programming knowledge. According to Gartner’s 2025 market report, over 70% of new enterprise applications will use low-code or no-code technologies by 2027. However, the real power of these tools lies in how you ask them to work—via prompts. This article curates 15 specific prompts for three leading platforms: Airtable, Bubble, and Retool. Each prompt is designed to save you hours of manual configuration and help you ship faster. Whether you’re a founder, product manager, or citizen developer, these prompts will level up your no-code game.
Category 1: Airtable Prompts (5 Prompts)
Airtable combines a spreadsheet interface with relational database capabilities. Its scripting block and automation features allow advanced data manipulation. Below are five prompts that leverage Airtable’s formula fields, scripting, and automations.
Prompt 1: Auto-Number with Prefix
Task: Generate a unique record ID with a custom prefix and zero-padded number.
Prompt: In Airtable, create a formula field that outputs PRJ-0001, PRJ-0002, etc., based on the record’s creation order.
Example Result:
Formula: "PRJ-" & REPT("0", 4 - LEN({Record ID})) & {Record ID}
This assumes you have an auto-number field named "Record ID." The formula pads the number to four digits, producing PRJ-0001.
Prompt 2: Conditional Status Color
Task: Highlight a status field (e.g., "To Do," "In Progress," "Done") with color-coded text.
Prompt: Use a formula field that returns a colored emoji or HTML tag based on status.
Example Result:
Formula: IF({Status}="Done", "✅ Complete", IF({Status}="In Progress", "🔄 Working", "⏳ Pending"))
Note: Airtable’s formula fields don’t support full HTML, but emojis work in text fields.
Prompt 3: Automated Weekly Digest Email
Task: Send a summary of new records created in the last 7 days to a team email.
Prompt: Create an automation triggered by a scheduled time (e.g., every Monday at 9 AM) that searches records where Created Date > TODAY() - 7, then sends an email via Airtable’s built-in email action.
Example Result:
- Trigger: Scheduled (weekly)
- Action: Find records (condition: Created Date is after TODAY() - 7)
- Action: Send email with body: "Here are {{count}} new records this week: {{record names}}"
Prompt 4: Cross-Table Rollup with Filter
Task: Sum a numeric field from a linked table, but only for records with a specific status.
Prompt: Use a rollup field with a filter condition. For example, from the "Tasks" table linked to a "Project," sum only tasks marked "Completed."
Example Result:
In the “Projects” table, add a rollup field pointing to “Tasks” → “Hours” and set the aggregation to SUM. Then, in the rollup’s options, set a filter: Status = "Completed".
Prompt 5: Scripting Block to Bulk Update
Task: Change a text field to lowercase for all records in a view.
Prompt: Use Airtable’s Scripting block (JavaScript) to iterate over records and update a field.
Example Result:
let table = base.getTable("Clients");
let query = await table.selectRecordsAsync();
for (let record of query.records) {
await table.updateRecordAsync(record.id, {
"Email": record.getCellValue("Email")?.toLowerCase()
});
}
This script processes all records in the table, converting the "Email" field to lowercase.
Category 2: Bubble Prompts (5 Prompts)
Bubble is a visual web app builder that uses workflows and expressions. The following prompts help you build logic without writing code manually.
Prompt 6: Dynamic Repeating Group Filter
Task: Show only products whose price is below a user-entered maximum.
Prompt: In a Repeating Group’s “Data source” expression, use a search for “Products” with a constraint: Product's Price <= Input Max Price's value.
Example Result:
Expression: Search for Products: Constraints: Product's Price <= Input Max Price's value
This dynamically filters the list based on user input.
Prompt 7: User Role-Based Navigation
Task: Show different menu items based on whether the current user is “Admin” or “Member.”
Prompt: Add conditional visibility to each navigation element. For admin-only links, set “This element is visible when” to Current User's Role = "Admin".
Example Result:
- Admin link: Visible when Current User's Role = "Admin"
- Member link: Visible when Current User's Role = "Member"
Prompt 8: Auto-Save on Input Change
Task: Save a record automatically when the user stops typing for 2 seconds.
Prompt: Use a custom event or a “Do every N seconds” workflow triggered by an input’s value change. For each input, add a workflow: “When Input’s value is changed” → “Schedule a workflow after 2 seconds” → “Update a thing.” Use a custom state to cancel previous schedules.
Example Result:
- Step 1: Create a custom state AutoSaveTimer (type: text)
- Step 2: When Input’s value changes, cancel any existing scheduled event, then schedule a new event after 2 seconds.
- Step 3: In the scheduled event, update the database record.
Prompt 9: Calculate Distance Between Two Addresses
Task: Show the driving distance from a user’s location to a store.
Prompt: Use Bubble’s built-in plugin “Mapbox” or “Google Maps” to geocode addresses, then use a formula to compute distance via API.
Example Result:
- Add “Google Maps” plugin.
- Use expression: Geocode Address User's address and Geocode Address Store's address.
- Call “Google Maps Distance Matrix” API with origins and destinations.
- Display result: Distance: 12.3 km
Prompt 10: Multi-Step Form with Progress Bar
Task: Create a form split into three steps, with a progress bar showing current step.
Prompt: Use a custom state “Step” (initial value 1). Group each step’s elements and set visibility based on Step value. For the progress bar, use a text element that shows “Step {Step} of 3” and a rectangle whose width is (Step / 3) * 100 percent.
Example Result:
- Step 1 visible when Step = 1
- Next button: “Change Step to Step + 1”
- Progress bar width: (Step / 3) * 100
Category 3: Retool Prompts (5 Prompts)
Retool is a low-code platform for building internal tools quickly with pre-built components and SQL. These prompts focus on data queries and UI logic.
Prompt 11: Dynamic SQL Query with User Input
Task: Filter an orders table by a date range selected by the user.
Prompt: Use a Date Range Picker component, then write a SQL query that uses {{ dateRangePicker1.value.start }} and {{ dateRangePicker1.value.end }} in the WHERE clause.
Example Result:
SELECT * FROM orders
WHERE order_date >= {{ dateRangePicker1.value.start }}
AND order_date <= {{ dateRangePicker1.value.end }}
Retool automatically sanitizes parameters when using this syntax.
Prompt 12: Real-Time User Activity Log
Task: Display a table of recent user actions, refreshed every 10 seconds.
Prompt: Add a Table component bound to a query that selects from an activity log. Set the query’s “Run interval” to 10 seconds (in the query editor).
Example Result:
- Query: SELECT user_name, action, timestamp FROM activity_log ORDER BY timestamp DESC LIMIT 100
- Table: bind to query1.data
- Query settings: Run interval = 10000 ms
Prompt 13: Conditional Button Color Based on Status
Task: Change a button’s background color to red if the selected order is “Cancelled,” green if “Shipped.”
Prompt: Use the Button component’s “Styles” → “Background color” and set it to a JavaScript expression: {{ selectedRow.status === 'Cancelled' ? 'red' : selectedRow.status === 'Shipped' ? 'green' : 'gray' }}
Example Result:
Button background color expression: {{ selectedRow.status === 'Cancelled' ? '#ff4d4f' : selectedRow.status === 'Shipped' ? '#52c41a' : '#d9d9d9' }}
Prompt 14: Cascading Dropdowns
Task: When a user selects a country, the second dropdown shows only cities from that country.
Prompt: Create two dropdowns: “Country” and “City.” The “City” dropdown’s “Data source” is a query that uses {{ countryDropdown.value }} in its WHERE clause.
Example Result:
- Country dropdown: query SELECT DISTINCT country FROM cities
- City dropdown: query SELECT city FROM cities WHERE country = {{ countryDropdown.value }}
- Set City dropdown’s “Depends on” to countryDropdown so it re-runs on change.
Prompt 15: Export Table Data to CSV
Task: Add a button that downloads the current table data as a CSV file.
Prompt: Use a Button component with an onClick event that runs a JavaScript query:
const data = table1.data; // array of objects
const csv = Papa.unparse(data); // using Papa Parse library
const blob = new Blob([csv], { type: 'text/csv' });
const url = URL.createObjectURL(blob);
window.open(url);
Example Result:
Papa Parse is built into Retool. The button triggers the script, and the browser downloads the CSV.
Conclusion
These 15 prompts demonstrate how to harness the full potential of Airtable, Bubble, and Retool through smart configurations and expressions. Start by copying one prompt that solves an immediate problem in your current project—whether it’s auto-numbering records, filtering data dynamically, or building a multi-step form. As you get comfortable, combine prompts to create complex workflows. For further learning, refer to the official documentation: Airtable Formulas, Bubble Expressions, and Retool Queries. Experiment, iterate, and share your own prompts with the community.
Comments