I'm trying to do some automated scoring based on the values of various Choice fields:
Column name is Project
Choice values are Widgets1, Widgets2 and Widgets3
The scoring is based on the choice of widgets:
- Widgets1 is 10 points
- Widgets2 is 25
- Widgets3 is 50
In the same record is a field titled Score. I want this dynamically populated based on the above choice. For example if widgets3 is selected, then our score is 50.
ALSO: I have some fields that are Y/N, and am hoping the syntax is similar.
Can someone point me in the right direction with the right syntax to make this happen?
Thanks in advance!