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。
無料 Action
この Action を明示的に参照する公開 Skills はまだありません。