Server-side formulas

Server-side formulas are submitted to the server for execution while a user interacts with the platform; the formula program directly operates on and is reflected in the database data. Their characteristics are direct database access, high speed and high efficiency.

Server-side formulas

Data-source interfaces inside a formula come in multi-record and single-record types: multi-record returns the whole set of matching records and drives the formula in a loop, single-record returns just one matching record and drives the formula once; data-source definitions can be nested, so that combined-condition queries can drive the formula.

Server-side formulas

With server-side formulas, complex data logic can be processed efficiently.

Business formulas: concepts and examples Designing action buttons and business formulas Extending the platform with Python Business formula design example Conditional assignment in business formulas Button formula design in business form layouts How buttons invoke formulas Defining custom system variables Using multiple data interfaces to run business formulas in batches Publishing and subscribing to smart IoT lamp messages Case study: instant-messaging service in the platform message center