smartsuite_create_formula_field
Validate and create a formula field in a SmartSuite application. Preview the result with a dry run first, then set confirm to true to append it to the table.
Instructions
Create a new formula field in a SmartSuite application. Requires readwrite/admin mode AND SMARTSUITE_ENABLE_SCHEMA_WRITE=true. The expression is validated first — an invalid formula is never created — and a local lint pass reports the semantic traps SmartSuite's validator accepts (see smartsuite_validate_formula); those warnings are advisory and never block. Without confirm:true returns a dry-run preview (validation result + what would be created); set confirm:true to create. The field slug is generated automatically and the field is appended to the end of the table (SmartSuite ignores field positioning on create — use smartsuite_move_layout_field to rearrange).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| label | Yes | Display label for the new field | |
| confirm | No | Must be true to actually create. Omit/false for a validate-only dry run. | |
| formula | Yes | The formula expression | |
| returnType | No | Output field type (default textfield). One of: textfield, numberfield, datefield, currencyfield, percentfield, singleselectfield, statusfield, yesnofield, emailfield, phonefield, durationfield, timefield, daterangefield, duedatefield. | |
| applicationId | Yes | The application ID |