Feature Requests

We value your feedback! You can vote for existing posts, add comments or add your own.
Materialized” Formula/Lookup Fields for Use in Other Formulas
Hi SmartSuite team, I’d love a way to create a duplicate of an existing Formula or Lookup field as a “plain” field (Text or Number) that I can then safely use in subsequent formulas. The problem, Right now, when we try to build formulas on top of other formulas or lookups, we run into issues such as: Formula dependencies getting messy or unstable, Unexpected errors or recalculation problems when formulas reference other formulas, Difficulty chaining multiple calculation steps in a clean, reliable way For more complex setups (e.g. costing, pricing, production calculations), we often need a multi-step calculation where each step feeds into the next. Doing this with only formula-on-formula quickly becomes fragile. Proposed solution - Add an option on Formula and Lookup fields like: “Create static copy as…” – Text – Number – Currency (if applicable) This new field would: Store the resolved value of the original formula/lookup field, as a normal text/number field, Update automatically whenever the source value changes, Be treated by SmartSuite as a regular non-formula field, so it can be safely used in other formulas without circular reference problems or calculation errors Essentially, it’s a “materialized” version of the field we can chain off. Example use case We calculate a unit cost in a Formula field (involving lookups, conditionals, etc) We then want to: Apply tiered pricing, Add margins, Do rounding logic, Use it again in other apps via lookups If we could convert that formula result into a static Number field that stays in sync, we could build further formulas on it cleanly, without hitting the current limitations of formula-on-formula references.
0
·
Field Types
Enable [Current User] in Button Formulas via "Just-in-Time" Calculation
The [Current User] system variable should be accessible within the formula editor of the Button field. The variable would be resolved "just-in-time" when the button is clicked, avoiding the performance issues that might prevent its use in a standard, always-on Formula field. The Problem It is currently impossible to build a dynamic URL for a button that incorporates the details of the person clicking it. This prevents the creation of personalized, context-aware actions triggered by a button click, such as pre-filling a form with the current user's name or email. An attempt to build a dynamic URL like the one below fails because [Current User] is not recognized in the button's formula context: CONCAT(" https://form.smartsuite.com/xyz?Prefill_Requester= ", [Current User].Email) Proposed Solution & Implementation Enable the [Current User] object (and its properties like .Name and .Email) within the formula configuration of the Button field. Crucially, this would not require a constant, real-time recalculation of the field's value for every user viewing the record. Instead, the [Current User] variable would only be resolved at the moment the user actually clicks the button. This "just-in-time" calculation model avoids potential performance overhead while delivering the full dynamic functionality at the critical moment of user interaction. Business Impact This feature would unlock powerful, user-specific workflows directly from a button click, such as one-click approvals or task claiming. By making buttons context-aware, it would streamline processes, reduce manual entry, and significantly enhance the efficiency and automation capabilities of the SmartSuite platform.
0
·
Field Types
Load More