smartsuite_validate_formula
Check a SmartSuite formula before creating or updating a field: validate syntax, functions, and [slug] references, and get lint warnings for common traps—without changing any data.
Instructions
Validate a SmartSuite formula expression against an application WITHOUT writing anything (safe in any mode). Returns {valid, safe, warnings} when valid, or a descriptive error message when not (syntax errors, unknown functions, missing field references). Field references use [slug] and chain across linked/compound fields as [slug].[slug]. Use this to check a formula before creating or updating a field. Also runs a local lint pass for the traps SmartSuite accepts as valid (reversed DATEDIFF, FIND(...)>0, percent fields divided by 100, 1-based MID, unwrapped array functions, LOG/CEILING argument confusion) and returns them as advisory lint warnings.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| formula | Yes | The formula expression, e.g. COUNT([sf1ac24c84]) or CONCAT([title], " - ", [status]) | |
| returnType | No | Optional declared output field type (e.g. textfield, numberfield, datefield, currencyfield, yesnofield). Validation works without it. | |
| applicationId | Yes | The application ID the formula will run in (field references are resolved against its schema) |