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>