Date: Fri, 29 Mar 2024 11:11:32 +0200 (EET) Message-ID: <1625917759.1201.1711703492908@wiki.vertuna.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_1200_908252941.1711703492889" ------=_Part_1200_908252941.1711703492889 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
2 forms to demonstrate 2 approaches to score calculations - one = is online, using the field definition rules, and another is using a backend= operation with IFTTT to update the record after submission
dropdown1 |
dropdown2 |
dropdown3 |
dropdown4 |
Score |
---|---|---|---|---|
one | one | one | one | 4 |
two | three | three | four | 12 |
three | two | one | one | 7 |
one | three | one | ||
one | two | one | one | 5 |
four | two | two | five | 13 |
two | three | three | three | 11 |
five | two | one | four | 12 |
five | four | three | one | 13 |
two | one | one | one | 5 |
three | three | three | three | 12 |
two | four | four | three | 13 |
one | five | two | ||
three | ||||
one | three | |||
one | one | two | two | 6 |
one | three | |||
one | one | three | one | 6 |
one | five | two | three | 11 |
one | one | one | one | 4 |
two | two | two | two | 8 |
one | two | two | three | 8 |
two | three | four | five | 14 |
one | one | one | one | 4 |
three | two | |||
two | three | |||
five | five | four | five | 19 |
one | two | |||
four | one | three | one | 9 |
four | two | two | three | 11 |
one | one | three | four | 9 |
one | two | three | four | 10 |
one | two | three | five | 11 |
one | two | five | one | 9 |
three | three | one | two | 9 |
one | three | one | two | 7 |
one | one | two | one | 5 |
one | one | one | one | 4 |
two | two | |||
one | two | three | four | 10 |
one | two | three | five | 11 |
two | two | four | two | 10 |
one | one | two | two | 6 |
one | one | two | three | 7 |
one | one | three | com.udojava.evalex.Expression$ExpressionException: Too many oper= ators or functions at: + | |
one | one | two | four | 8 |
two | one | two | four | 9 |
one | two | three | four | 10 |
two | one | one | four | 8 |
two | two | two | four | 10 |
one | two | three | four | 10 |
three | three | five | com.udojava.evalex.Expression$ExpressionException: Unknown opera= tor '++' at position 5 | |
one | two | com.vertuna.confluence.plugins.confiforms.util.Expression$Expres= sionException: Unknown operator '+++' at position 3 | ||
one | two | three | four | 10 |
one | three | four | com.vertuna.confluence.plugins.confiforms.util.Expression$Expres= sionException: Too many operators or functions at: + | |
one | three | four | five | 13 |
one | one | one | one | 4 |
three | one | one | two | 7 |
one | two | three | com.vertuna.confluence.plugins.confiforms.util.Expression$Expres= sionException: Too many operators or functions at: + | |
one | two | com.vertuna.confluence.plugins.confiforms.util.Expression$Expres= sionException: Unknown operator '++' at position 5 | ||
one | two | one | four | 8 |
one | four | one | com.vertuna.confluence.plugins.confiforms.util.Expression$Expres= sionException: Too many operators or functions at: + | |
one | one | two | three | 7 |
two | two | two | two | 8 |
one | two | three | three | 9 |
one | two | one | two | 6 |
one | one | one | one | 4 |
dropdown1 |
dropdown2 |
dropdown3 |
dropdown4 |
Score |
---|---|---|---|---|
one | two | three | four | 10 |
one | three | four | five | |
two | two | two | two | |
one | two | four | three | |
one | two | four | three | |
one | three | one | four | |
two | three | three | one | |
two | two | two | four | |
one | three | one | three | |
one | one | three | one | |
one | one | one | one | |
three | one | two | two | |
two | two | two | two | |
two | one | two | two | |
three | two | one | five | |
one | one | one | one | |
two | two | |||
two | one | two | two | |
two | two | two | two | |
two | two | four | three | |
one | one | one | five | |
one | one | one | one | |
one | two | three | four | |
two | two | two | two | |
one | two | three | four | |
three | three | two | two | |
two | two | four | four | 12 |
three | two | one | three | |
one | one | one | one | |
two | three | one | one | |
one | one | one | one | |
one | two | three | four | |
two | two | three | four | |
one | one | one | one | |
one | one | one | one | |
one | two | three | three | |
one | one | one | one | |
five | five | five | ||
one | one | one | one | |
one | one | one | one | |
one | one | one | one | |
one | ||||
one | three | two | one | |
five | one | five | one | |
one | one | four | five | |
one | one | one | one | |
one | one | one | two | |
one | five | one | one | |
two | three | three | four | |
one | three | four | one | |
two | three | one | one | |
two | three | one | one | |
two | two | two | two | |
five | three | two | one | |
one | two | three | one | |
one | two | three | four | |
five | four | three | two | |
four | one | two | three | |
one | ||||
one | two |
Storage format
<ac:= structured-macro ac:macro-id=3D"a2d2bfea-0bba-47af-ae0a-01a323851220" ac:na= me=3D"confiform" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"formName">dynamicUpdate1</ac:parameter&= gt; <ac:rich-text-body> <ac:structured-macro ac:macro-id=3D"35fe9696-b67b-4323-bdf4-295384bd= 7e71" ac:name=3D"confiform-entry-register" ac:schema-version=3D"1"> <ac:rich-text-body> <p> </p> </ac:rich-text-body> </ac:structured-macro> <p> <ac:structured-macro ac:macro-id=3D"eeb4e365-05b2-4861-8dd8-af1995= 87d56e" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown1</ac:paramete= r> <ac:parameter ac:name=3D"fieldLabel">dropdown1</ac:paramet= er> <ac:parameter ac:name=3D"values">false[1=3Done|2=3Dtwo|3=3Dth= ree|4=3Dfour|5=3Dfive|]</ac:parameter> <ac:parameter ac:name=3D"type">select</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"70432cbc-bba8-4b07-9ac4-9c664f= edc962" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown2</ac:paramete= r> <ac:parameter ac:name=3D"fieldLabel">dropdown2</ac:paramet= er> <ac:parameter ac:name=3D"values">false[1=3Done|2=3Dtwo|3=3Dth= ree|4=3Dfour|5=3Dfive|]</ac:parameter> <ac:parameter ac:name=3D"type">select</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"59da341d-ea49-440d-a9e7-892ef4= 6e13b5" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown3</ac:paramete= r> <ac:parameter ac:name=3D"fieldLabel">dropdown3</ac:paramet= er> <ac:parameter ac:name=3D"values">false[1=3Done|2=3Dtwo|3=3Dth= ree|4=3Dfour|5=3Dfive|]</ac:parameter> <ac:parameter ac:name=3D"type">select</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"cc57a98a-db23-457a-9df5-a30fd6= 9b85fe" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown4</ac:paramete= r> <ac:parameter ac:name=3D"fieldLabel">dropdown4</ac:paramet= er> <ac:parameter ac:name=3D"values">false[1=3Done|2=3Dtwo|3=3Dth= ree|4=3Dfour|5=3Dfive|]</ac:parameter> <ac:parameter ac:name=3D"type">select</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"6926e6cd-6366-48c7-8bf8-0b2e5e= 2ac146" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">score</ac:parameter>= ; <ac:parameter ac:name=3D"fieldLabel">Score</ac:parameter&g= t; <ac:parameter ac:name=3D"type">read_only</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"06a27750-319b-47cb-ade9-a2ef8a= c391eb" ac:name=3D"confiform-field-definition-rules" ac:schema-version=3D"1= "> <ac:parameter ac:name=3D"values">score=3D([entry.dropdown1]+[= entry.dropdown2]+[entry.dropdown3]+[entry.dropdown4])</ac:parameter> <ac:parameter ac:name=3D"action">Set expression</ac:parame= ter> <ac:parameter ac:name=3D"actionFieldName">dropdown1</ac:pa= rameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"06b97051-0277-4ffd-9d0f-a0c2f4= 604548" ac:name=3D"confiform-field-definition-rules" ac:schema-version=3D"1= "> <ac:parameter ac:name=3D"values">score=3D([entry.dropdown1]+[= entry.dropdown2]+[entry.dropdown3]+[entry.dropdown4])</ac:parameter> <ac:parameter ac:name=3D"action">Set expression</ac:parame= ter> <ac:parameter ac:name=3D"actionFieldName">dropdown2</ac:pa= rameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"7e7bdfc8-9455-4829-97a8-c94d45= 2e8a16" ac:name=3D"confiform-field-definition-rules" ac:schema-version=3D"1= "> <ac:parameter ac:name=3D"values">score=3D([entry.dropdown1]+[= entry.dropdown2]+[entry.dropdown3]+[entry.dropdown4])</ac:parameter> <ac:parameter ac:name=3D"action">Set expression</ac:parame= ter> <ac:parameter ac:name=3D"actionFieldName">dropdown3</ac:pa= rameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"c6c03a20-75b6-4205-a739-adaea1= 730307" ac:name=3D"confiform-field-definition-rules" ac:schema-version=3D"1= "> <ac:parameter ac:name=3D"values">score=3D([entry.dropdown1]+[= entry.dropdown2]+[entry.dropdown3]+[entry.dropdown4])</ac:parameter> <ac:parameter ac:name=3D"action">Set expression</ac:parame= ter> <ac:parameter ac:name=3D"actionFieldName">dropdown4</ac:pa= rameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id=3D"dacc9784-712c-4e02-b6cb-0e1538397022= " ac:name=3D"confiform-table" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"formName">dynamicUpdate1</ac:parameter&= gt; <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id=3D"fd5e133c-66c6-42ce-9242-f0651a= 9a92ed" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown1</ac:paramete= r> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"487f3785-4451-4168-9ba0-53d198= 6a0342" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown2</ac:paramete= r> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"9cd7f484-bb88-41ec-a52a-990804= be0bc7" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown3</ac:paramete= r> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"8ba05865-864f-4c79-a02b-1abb5f= 4fcf01" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown4</ac:paramete= r> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"091bf6b1-9560-4cca-a7c7-640b98= f2d557" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">score</ac:parameter>= ; </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <p> </p> <p> Using IFTTT to update the record with calculation rules</p> <p> </p> <ac:structured-macro ac:macro-id=3D"16ebbaa3-dcc6-4d75-b5a3-76b9006f4d38= " ac:name=3D"confiform" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"formName">nonDynamicUpdate1</ac:paramet= er> <ac:rich-text-body> <ac:structured-macro ac:macro-id=3D"fdbb83d4-1572-4562-9284-0ddac287= c5f6" ac:name=3D"confiform-entry-register" ac:schema-version=3D"1"> <ac:rich-text-body> <p> </p> </ac:rich-text-body> </ac:structured-macro> <p> <ac:structured-macro ac:macro-id=3D"13ac46ea-a1c3-444b-ae42-a97ed0= f23827" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown1</ac:paramete= r> <ac:parameter ac:name=3D"fieldLabel">dropdown1</ac:paramet= er> <ac:parameter ac:name=3D"values">false[1=3Done|2=3Dtwo|3=3Dth= ree|4=3Dfour|5=3Dfive|]</ac:parameter> <ac:parameter ac:name=3D"type">select</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"d1f520a7-d420-42c2-99d5-65885c= 121666" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown2</ac:paramete= r> <ac:parameter ac:name=3D"fieldLabel">dropdown2</ac:paramet= er> <ac:parameter ac:name=3D"values">false[1=3Done|2=3Dtwo|3=3Dth= ree|4=3Dfour|5=3Dfive|]</ac:parameter> <ac:parameter ac:name=3D"type">select</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"36651b7d-9415-45c3-82ba-912ea1= a979d1" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown3</ac:paramete= r> <ac:parameter ac:name=3D"fieldLabel">dropdown3</ac:paramet= er> <ac:parameter ac:name=3D"values">false[1=3Done|2=3Dtwo|3=3Dth= ree|4=3Dfour|5=3Dfive|]</ac:parameter> <ac:parameter ac:name=3D"type">select</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"1b7f7173-93c1-48fc-a552-9ded75= dd20b3" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown4</ac:paramete= r> <ac:parameter ac:name=3D"fieldLabel">dropdown4</ac:paramet= er> <ac:parameter ac:name=3D"values">false[1=3Done|2=3Dtwo|3=3Dth= ree|4=3Dfour|5=3Dfive|]</ac:parameter> <ac:parameter ac:name=3D"type">select</ac:parameter> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"ccdfd75e-ca41-4743-b2a8-934439= 8f1084" ac:name=3D"confiform-field-definition" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">score</ac:parameter>= ; <ac:parameter ac:name=3D"fieldLabel">Score</ac:parameter&g= t; <ac:parameter ac:name=3D"type">read_only</ac:parameter> </ac:structured-macro> </p> <p> </p> <ac:structured-macro ac:macro-id=3D"43b024fc-277b-4ba3-81d9-84414ed3= a448" ac:name=3D"confiform-ifttt" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"action">Create ConfiForms Entry</ac= :parameter> <ac:parameter ac:name=3D"event">onCreated</ac:parameter> <ac:parameter ac:name=3D"title">entryId=3D[entry.id]&sc= ore=3D([entry.dropdown1]+[entry.dropdown2]+[entry.dropdown3]+[entry.dropdow= n4])</ac:parameter> <ac:rich-text-body> <p> </p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id=3D"24b5caff-f8fa-4693-89e9-1a0efc60fa08= " ac:name=3D"confiform-table" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"formName">nonDynamicUpdate1</ac:paramet= er> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id=3D"ccbc07f2-d36b-4635-805d-e4d695= 512886" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown1</ac:paramete= r> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"a4cb3e4d-511f-4b53-aba9-e1b893= 4dd690" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown2</ac:paramete= r> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"a3f1ef35-b230-4ca8-9f9d-4f4416= 6ec10c" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown3</ac:paramete= r> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"ee72cc45-6fe1-4fcb-8f80-c2eec5= ddd662" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">dropdown4</ac:paramete= r> </ac:structured-macro> </p> <p> <ac:structured-macro ac:macro-id=3D"e690c659-f573-4e1c-88b4-6c7178= 8dd6f2" ac:name=3D"confiform-field" ac:schema-version=3D"1"> <ac:parameter ac:name=3D"fieldName">score</ac:parameter>= ; </ac:structured-macro> </p> <p> </p> </ac:rich-text-body> </ac:structured-macro>