Feed | Community Creatio

exponent

Math

Function

nocode

Studio_Creatio

8.0

How to calculate exponent in Creatio without Code (CSharp) / No Code

Dedi Sadikin

11:21 Oct 05, 2026

Hi All,

Question please, I have form that must calculating exponent function.

i = (B / 100) / 12

A, B, P, n --> all fields in form, so we can get that value exactly.

Need advice for No Code method in Business Process please, thank you.

2 comments

Oleg Drobina

12:14 Oct 05, 2026

Hi,

You can do this in a business process with no code. Process formulas in Creatio are compiled as C# expressions, so you can use Math.Pow inside a formula field even though the formula editor has no "power" button.

Process layout

[Signal: record added / modified (fields P, B, n)]
        ↓
[Read data: the record]
        ↓
[Formula: i]  →  [Formula: Pow]  →  [Formula: A]
        ↓
[Modify data: set field A]

1. Start signal

Use an Object signal on your object, triggered by "Record added" or "Record modified".
For "modified", tick only the fields P, B, n. If you leave A ticked, writing A starts the process again and it loops.
You can use a button on the page that runs the process instead.

2. Read data

Read the record by Id = Signal.Unique record Id.

3. Process parameters

Add three Decimal parameters: i, Pow, Result. Fill each one with a Formula element:

[#Read data.First item of resulting collection.B#] / 100m / 12m

Write 100m / 12m (decimal literals). If B is an Integer field, B / 100 does integer division and gives 0.

Pow = (1 + i)ⁿ

Convert.ToDecimal(Math.Pow(Convert.ToDouble(1 + [#i#]), Convert.ToDouble([#Read data.First item of resulting collection.n#])))

Math.Pow works with double and Creatio fields are decimal, so the formula converts to double and back.

Result = A

[#i#] == 0 
  ? [#Read data.First item of resulting collection.P#] / [#Read data.First item of resulting collection.n#]
  : Math.Round([#Read data.First item of resulting collection.P#] * [#i#] * [#Pow#] / ([#Pow#] - 1), 2)

The i == 0 branch covers a 0% rate (B = 0). Without it the formula divides by zero, because the payment is then just P / n.

4. Modify data

Update the same record (Id = Signal.Unique record Id) and set A = [#Result#].

Notes

One formula is possible. You can put the whole calculation into one formula inside Modify data, but three separate parameters are much easier to debug: you can see each value in the process log.
Check the result. With P = 10 000, B = 12, n = 12, you should get A ≈ 888.49.
Live value on the page. The process runs after the record is saved, so A appears only after save and refresh. If you need A to update while the user types, a business process won't do that; you'd need a page handler, which means code.

Dedi Sadikin

13:33 Oct 05, 2026

Oleg Drobina,

Thank you Oleg, appreciate it for the feedback

Show all comments

DataVisualization

SyntechPivot

PivotTables

DataAnalytics

Syntech Pivot for Creatio v1.6.0 is now available

Ivanna

14:46 Oct 02, 2026

We’ve released a new version of Syntech Pivot for Creatio.

What’s new
Features
Year-over-year comparison. Each period can now be compared with the same period a year earlier.

Fixes
Date filters no longer fail on the server.
Between works as a Between filter.
Date periods sort chronologically instead of alphabetically, in rows, columns, and lookup-based sorts.
Build and dependencies resolve on Angular 20.

Performance
Every record ceiling is now an explicit parameter, lowered to a small default (50) and exposed in the settings panel: page size, related-source page size and record ceiling, column unique-value limit, filter and condition lookup page sizes, and schema load page size.

Version: 1.6.0
Compatible with: Creatio 8.3.1

Explore Syntech Pivot for Creatio and the latest update on the Marketplace

0 comments

Show all comments

Gantt_View_Update

syntech_gantt

New_in_Syntech

syntech

Syntech Gantt View for Creatio 5.2.0 - Release Update

Ivanna

14:01 Sep 30, 2026

Syntech Gantt View for Creatio 5.2.0 is now available.

This release introduces improvements to labor forecasting, filtering, access control, real-time updates, and Gantt usability.

Base record colors
Pick default bar colors per level - projects, tasks/subtasks, and milestones - used whenever no color column is mapped. Configurable in Settings with a color picker.

Labor Forecast is now a real forecast
ETC hours are spread across the timeline by each task’s date range (start → end) instead of piling onto the start date, so the manpower chart reflects load period by period.

Global filters per schema level
Add fixed filter conditions to any connected level (parent / child / milestone / resources) on top of the record scope — e.g. show only records of a given type. Operators include equals, in-list (multi-value), contains, starts/ends-with, comparisons, and is-empty; lookup columns get a value picker.

Fixes
- Fixed a freeze when typing a date manually (invalid/extreme years are now rejected; timeline generation is capped).
- Milestones can now be deleted - from a row action and from the right-click Edit Schedule dialog.
- Parent tasks now resize both ways to match their children (shrink as well as grow).
- Much smoother dragging of a parent with its children - no more jumping while changes save.
- Milestones no longer disappear when filters are active or related tasks complete.

Access control
Restrict who can edit project (parent) dates via a role multi-select (chips) in Settings.

Real-time updates
Live refresh now updates only the record that changed (not a full reload), is gated per board, and is far lighter on the server (cached, Redis-backed - no DB hit per change).

Settings
Restored the Record column picker (host-record scoping) in the settings menu.

Syntech Gantt View for Creatio is available on Marketplace

0 comments

Show all comments

New_in_Syntech

syntech_available

todolist

Syntech To Do List for Creatio: New Update Available

Ivanna

17:12 Sep 29, 2026

We’ve released a new update for Syntech To Do List for Creatio, focused on usability, data consistency, accessibility, and performance.

The update addresses several everyday scenarios when working with tasks:
Nothing gets deleted by accident. Pressing Backspace used to delete the task you had selected, with no warning. Deleting now always asks first.
Typing works like typing. In search and other fields, the space bar, Enter and Tab used to act on the task list instead of the text box. Fixed.
Settings are for admins only. The settings panel was visible to everyone and could be overwritten by any user. It is now limited to administrators.
Sorting is correct. Sorting only applied to the tasks already on screen, so the order broke as more loaded. It now sorts the whole list.
What you see is what is saved. If a change could not be saved, the list used to keep showing it anyway. Now it reverts, and load errors are shown instead of an empty list.
Reordering sticks. Dragging tasks into a new order used to reset on refresh.

Syntech To Do List can be embedded into Freedom UI pages and connected to different Creatio entities using no-code configuration. It supports hierarchical tasks, priorities, assignees, due dates, projects, and progress tracking.

View the app on Creatio Marketplace

#Creatio #CreatioMarketplace #SYNTECH #FreedomUI #TaskManagement

0 comments

Show all comments

FreedomUI

CustomComponent

integration

json

marketplace

NCS

FreedomUI_Designer

JSON Viewer for Creatio: render your unlimited text fields as interactive JSON trees (free component)

NCS.JulioFalcon

12:35 Sep 29, 2026

Hi, Creatio community.

If you work with integrations in Creatio, you know what a REST log looks like stored in a long text field: one unbroken line, no indentation, keys and values blending together. You either copy it to a browser tab to read it, or you squint at the record and try to parse it mentally.

We ran into this constantly while building banking integrations, and at some point we decided to fix it properly.

JSON Viewer for Creatio is a free custom component for Freedom UI that renders any unlimited-length text field containing JSON as an interactive tree: expandable and collapsible nodes, real-time search by key or value, copy to clipboard, and fully configurable colors per data type (keys, strings, numbers, booleans, nulls). Dark and light theme, both configurable from the setup panel in Freedom UI Designer. No code required to drop it on a page.

Where it helps in practice:

REST API and webhook logs stored in records: instead of a wall of text, you get a navigable structure.
Audit trails saved as JSON: your team can inspect them without leaving the record.
External service responses (SAP, OnBase, validation services): readable at a glance, without copy-pasting.
Any unlimited-length text field storing JSON, whatever the use case is.

Setup takes a few minutes: install from the Marketplace, add NcsJsonViewer as a dependency in your package, drag the component from the Custom Components section in Freedom UI Designer, and point it at any unlimited-length text field that stores a JSON.

It's free and works on cloud and on-site.

Marketplace: https://marketplace.creatio.com/app/json-viewer-creatio

If you're using it and run into something, let us know here or at support@nocode-services.com. And if you find it useful, a review on the Marketplace goes a long way.

1 comments

NCS.JulioFalcon

12:40 Sep 29, 2026

Light and dark theme, colors per data type (keys, strings, numbers, booleans, nulls), and viewer size, all configurable from the setup panel in Freedom UI Designer.

Show all comments

Subscribe to Discussions