Assigning value to an option in a multiple select menu

Question

Hello, I’ve been tinkering with this idea but I’m stuck.
I have a form with a Multiple Select field. Each option of this Multiple Select is the name of an activity. When the form is submitted, I’d like the table to add a value (I’m calling this “points”) according to the activity selected. So if Activity 1 was selected and the form submitted, 10 points are added to a field in the table. If Activity 2 was selected, it’s 8 points, and so on.
Anyone have an idea how to make this?
Many thanks in advance.

JonathanBowen · Accepted Answer

Hi @gbrl - use this formula field to find if specific activities have been selected and add up the scores:

IF(
  FIND('Activity 1', Activities), 
  10
) + 
IF(
  FIND('Activity 2', Activities), 
  8
) + 
IF(
  FIND('Activity 3', Activities), 
  6
)

JB

Excellent Jonathan, thank you!
That totally works.
Now that’s given me more ideas to go further…

gbrl · Answer

Hi @gbrl - use this formula field to find if specific activities have been selected and add up the scores:

IF(
  FIND('Activity 1', Activities), 
  10
) + 
IF(
  FIND('Activity 2', Activities), 
  8
) + 
IF(
  FIND('Activity 3', Activities), 
  6
)

JB

Excellent Jonathan, thank you!
That totally works.
Now that’s given me more ideas to go further…

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded