Page tree
Skip to end of metadata
Go to start of metadata

Playground and DEMO space

This is a playground and demo space for ConfiForms and ConfiDoc addons developed and supported by Vertuna LLC

Most pages provide a storage format for the demo, so you can use the free add-on from Atlassian Confluence Source Editor to import this configuration into your Confluence and see it in action

Please note, all the examples here are provided without any obligation and may or may not be incomplete or may have bugs, and we provide NO SUPPORT for these examples and demos.


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
xyz 20.00
One 35
oranges 4
test1 2
test 1 34
dn 548484
Flight X 50
test1 10
test1 20
wert 123
traitao 9
x 40

 

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>
  • No labels