
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 25, 2019 10:59 PM
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.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 26, 2019 03:50 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 26, 2019 03:50 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 26, 2019 04:12 PM
Excellent Jonathan, thank you!
That totally works.
Now that’s given me more ideas to go further…
