Confiform Calculation based on Field inputs

[Maximilian Herbert]

Hi there,

this is more of a "is this possible" question.

Setup is the following:
Form (F1) is creating a Subpage when a record is created (based on a space template)

Every field in the Form has different answer options (sometimes yes / no, sometimes other options). Now every answer equals a different amount of points.

E.G: Yes == 10 points, No==5 points

Now in the final Subpage I want to calc the points of the answers

Anyone has a clue if this is even possible?

[Alex Medved _ConfiForms_]

Hi @Maximilian Herbert 

Use a Formula field in ConfiForms and calculate what you need

https://wiki.vertuna.com/display/CONFIFORMS/Supported+math+operators%2C+formulas+and+functions

Alex

[Maximilian Herbert]

Hi Alex,

I tried it with the formula field which obviously works perfect.

The only thing that is not really good about this solution:

For every field I want to include in the total calc I have to make an additional field where I store the value depending on the answer.

It looks like that

Field1 (Dropdown with 3 options)

Field1Calc (If Option1 -> Value=1 | If Option2 -> Value=2 | If Option3 -> Value=3)

I have 20 fields in total that neet to be included. So with this solution I would need to make 20 More fields (FieldXXCalc) where I store the value for the corresponding field. 
This makes the record very very long and complex.

[Alex Medved _ConfiForms_]

Why not to mae the dropdown field values ALREADY be the values you WANT?

Meaning that accessing their "id" property you will get a numeric value you have defined for each option

Alternatively, an evaluateFormula virtual function can be utilized to do the calculations on the fly... in the target pages

[Maximilian Herbert]

I like the idea with the "ID" property ! I think I will try it with that one.

Questions besides that: 

If you have a field dropdown with the following options:

ID   |       Label

1              Red

2              Blue

3              Yellow

and you make an entry where you select option 3

Now you change the ID to lets say 5 - what will happen to the entry? Will it drop its value?