通过 Aident Loadout 使用 Gigasheet Tools 的 Gigasheet Create Dataset Formula Edit。执行前查看输入、输出、设置、价格和风险。
Tool to edit a formula column in a Gigasheet dataset. Use when you need to update an existing formula column with a new formula, rename it, or reposition it. The column must already exist and be a formula column created previously.
column必填stringColumn identifier or name of the existing formula column to edit. This can be a column letter (e.g., 'J', 'K') or column name. The column must already exist and be a formula column.
handle必填stringUnique identifier (handle) of the dataset containing the formula column to edit. This is typically returned by file upload actions or can be found in the Gigasheet web app URL. Format: lowercase letters a-f, numbers, and underscores (e.g., 'f2ce9f7d_f429_402a_b0a0_5e5587feb608').
formulastringNew formula expression using column letters (e.g., 'G * 3', 'A + B'). This is the formula that will be applied to the column. Must be a valid Gigasheet formula expression.
columnNamestringNew name for the formula column. If not provided, the column name remains unchanged.
afterColumnIdstringColumn ID after which to position the edited formula column. If not provided, the column position remains unchanged.
literalFormulastringHuman-readable formula using actual column names instead of letters (e.g., 'Price * 3', 'Quantity * Rate'). This provides better readability and documentation of the formula logic.
data必填Data from the action execution
errorstringError if any occurred during the execution of the action
successful必填booleanWhether or not the action execution was successful or not
API 密钥连接。风险等级 2/5。
免费操作
目前没有已发布技能明确引用此操作。