TEST : Using ConfiForms Rule for Field Definition to calculate the sums online

Using ConfiForms Rule and the formula like 

total=([entry.p.transform(price).join(+)])

to calculate the sum for the order

See more about transform function on Virtual functions page

 

Rows in prices form

product

price

test 1 34
screen 89
x 123
Apple 1
ABC 10
ab 22
aa 22
wedew 11
hurra 19
ABC
test 10
123 123
test 42
test4 4
1 5
123 234
Komet 10
hi 100
test 1 5
k 1
h 1
testing0101 567
test 1
gjfgj 65
1 1
567890 1234567890
e 4
5 2
Arun 10
Boat 100000
myself 5
hdh 45
test1 10
TEST 10.00
ree 45
Apple 1000
SCB 22
4 33
test 45
123 123
nein 17
20181030 1030
aa 66
test 1 123
fs 12
tes 34
productX 34
adfd 123
asdcfa 12
screen 22
test 4
1 1
New item 22
Test1234 15.00
wewed 123
3 5
Test1 4
Test2 3
My Produkt 1 50
test2 3
item001 1234
123 2
test 12
ABC 100
test1 34
apples 3.5
1 3.5
1 1
weed 420
test 1 2
New Product 500
1 1
Rice 1223
g 10
p1 2222
te 32
15 12
3 3
Test 13.50
orange 25
3231213 4
test4 123123
toto 999
hello 10
asdfdas 1
s 3
test6666666 10
ABC
4 5
tester12 45
hfhsdf 5
zorro 129
nhk 1200
x 10
sad
jkhkjhkjjh 100000
aaaaaaa 1000000
123456 5
crap 99
56 45
1 12
raaap 187
fdgdfgdfg 456456
test 1 8488484848
test 1
2 2
apple 3.50
df 10
Joint 5
oranges 5
4 4
ding 5
test 1000000000000
jhkuhj 1
meinprodudukt 112
JBBJ 1.5
JBBJ2 1,5
1235 123
tomato 3.50
3 4
10 10
100 300
2 4
test 1
tuy 666
tuy 123
wedew 1
444 4444
ProductXYZ 125
New 1
1 2
testproduct 77
12 35
screen 20
1 1
plums 23
test 1 1
TEST 4102 3456
screen 1
1 2
ab 2000
xx 1
Testme 15
aaaa 5
ABC 1
ABC 1
Testing1 34.56
cheese 3.5
a 1

 

Try checking the "p" field - the amount is recalculated.

"p" is the smart field taking values from "prices" form

Storage format for calculation rule

      <ac:structured-macro ac:macro-id="e9724371-0213-48a9-8e1c-6184f4b4e439" ac:name="confiform-field-definition-rules" ac:schema-version="1">
        <ac:parameter ac:name="values">total=([entry.p.transform(price).join(+)])</ac:parameter>
        <ac:parameter ac:name="action">Set expression</ac:parameter>
        <ac:parameter ac:name="actionFieldName">p</ac:parameter>
      </ac:structured-macro>