bitable-formula-generator

What This Skill Does

The bitable-formula-generator is a specialized automation skill designed to bridge the gap between Excel analytical logic and Lark (Feishu) Bitable's formula engine. It acts as an intelligent intermediary that helps users translate complex spreadsheet calculations into Bitable-compatible syntax. By leveraging a dedicated API integration script, the agent can programmatically discover your Bitable schema—mapping fields and data types—and inject optimized formulas directly into your table columns. This eliminates manual configuration errors and ensures that business logic remains consistent across your data sets.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal:

clawhub install openclaw/skills/skills/chengfen1987/bitable-formula-generator

Ensure you have configured your environmental variables FEISHU_APP_ID and FEISHU_APP_SECRET to grant the agent the necessary permissions to read and write to your Bitable structures.

Use Cases

• Automated Sales Reporting: Automatically calculate profit margins, tax, and commissions based on real-time deal data in Bitable.
• Complex Data Cleansing: Transform raw input fields using regex or string manipulation functions before storing them in cleaned-up formula columns.
• Cross-Table Logic Implementation: When you have intermediate calculation fields, the agent can verify their formulas before chaining them into a final output field.
• Migrating Excel Processes: Move legacy Excel spreadsheet logic into a centralized, collaborative Bitable environment without losing calculation integrity.

Example Prompts

1. "I need to calculate the commission for our sales team. Our table has 'Gross_Sales' and 'Target_Met' fields. If 'Target_Met' is 'Yes', the commission is 10% of 'Gross_Sales', otherwise it's 5%. Please generate and write the formula for me."
2. "Check the current field definitions in my 'Q4_Financials' table and update the 'Net_Profit' column to subtract 'Operational_Costs' from 'Revenue'. Ensure the final output is formatted to two decimal places."
3. "I have an Excel formula I use: =(A2-B2)/A2. Can you help me adapt this to my Bitable table where columns are named 'Base_Price' and 'Discounted_Price'?"

Tips & Limitations

• Pre-Validation: Always ensure that any intermediate formula fields your final formula depends on are already verified and working correctly. If an intermediate field is empty or set to 0, your final result will be skewed.
• Formula Syntax: Bitable uses specific functions. While it shares many commonalities with Excel, functions like STDEV or PERCENTRANK are currently unsupported. Use LOOKUP instead of VLOOKUP or XLOOKUP.
• Shell Safety: When using the CLI integration, be mindful of special characters like |, &, or > in your formulas. For complex formulas, the agent will prompt you to use the script-file write method to avoid command-line truncation.