通过 Aident Loadout 使用 Gigasheet Tools 的 Gigasheet Create Dataset Formula。执行前查看输入、输出、设置、价格和风险。
Tool to create a new column based on a formula input in a Gigasheet dataset. Use when you need to calculate values based on existing columns. This action creates a new column with values computed from a formula. You must reference columns by letter (e.g., 'A', 'B', 'C') using th…
handle必填stringUnique identifier (handle) of the dataset to which the formula column should be added. Example: 'f2ce9f7d_f429_402a_b0a0_5e5587feb608'
formulastringFormula expression using column letters (e.g., 'G * 2', 'A + B'). Use column letters like 'A', 'B', 'C' to reference columns. This field is required if you want to create a formula column.
columnName必填stringName for the new formula column that will be created in the dataset.
afterColumnIdstringColumn identifier after which to insert the new formula column. If not specified, the column will be appended at the end.
literalFormulastringHuman-readable formula using actual column names for documentation purposes (e.g., 'Price * 2'). This should be provided alongside 'formula' for better readability. Cannot be used alone without 'formula'.
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。
免费操作
目前没有已发布技能明确引用此操作。