Which code section in the field settings calculates the field value?
Section code.
How do I take the value of a field from the current table?
Very simple — #name_field. Replace name_field with the name of the field you need. As soon as you type the hash symbol and start typing either the name or the field's title, it will suggest options for you.
You can also get the name of a field by clicking on it — it will be copied to the clipboard. The same goes for the name of a table.
How do I take a parameter calculated by another line?
For this, $code_row_name is used. The row is denoted as code_row_name:
For example, the code for calculating VAT from the total amount:
=: #summ / $calc * #bid
calc: 100 + #bid
The code will start executing from =: and
take the values of the fields summ and bid
see the reference to the row calc
calculate calc and substitute the resulting value into the formula
finish the calculation and write the resulting value into the field
How are lines of code named?
The line of code is denoted as code_row_name:.
If you double-click on it, all its usages in the code will be highlighted — all the places where it is called by $code_row_name.
Which line of code is the starting one?
For codes, it is always =:
How do I put comments in the codes?
Very simple — // comment text. For example:
=: #summ / $calc * #bid
// calculate the divisor depending on the bid
calc: 100 + #bid
Can the code be structured with indentation?
Yes, using tab and space. We recommend using only tab.
In what order are mathematical operations performed?
In the one in which they are written. That is:
=: $A + $B / $C
A: 10
B: 2
C: 3
When this code is executed, A will be added to B and then divided by C — the result will be 4.
Can brackets be used without further reference to a mathematical operation?
Brackets cannot be used just like that. The fact is that they denote functions, not mathematical operations.
But there is such a possibility:
=: math`($A + $B) / $C`
A: 10
B: 2
C: 3
When this code is executed, A will be added to B and then divided by C — the result will be 4.
And if like this:
=: math`$A + $B / $C`
A: 10
B: 2
C: 3
Then in the special math tag + highlighting with backticks, the operations will be performed as in mathematics. When this code is executed, B will be divided by C and then added to A — the result will be 10.6666666666.
Are indents between code elements significant?
No. Whether there are spaces or not does not matter. However, it is good practice to format code with spaces:
= : #f_order_summ - $pay_summ
pay_summ: listSum(list: $list)
list: selectList(table: 'paylist'; field: 'summ'; where: 'order' = $#nci)