You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
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.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
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.
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
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?