cancel
Showing results for
Did you mean:
See all
##### Top groups
Explore all groups

## Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user

Level 1: Seed

25 / 150 points

Next: Root

## Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

What goes around comes around! Share the love by gifting kudos to your peers.

## Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

# Confiform Calculation based on Field inputs

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_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 26, 2023

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

Hi Alex,

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

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_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 26, 2023

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

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?