Expand my Community achievements bar.

Calculated field with array features

Avatar

Level 3

Hello, lovely group,

 

I have two checkboxes: Checkbox A with 3 options and Checkbox B with 2 options.

 

I want to create a calculated field in a custom form that will multiply the number of selected options from Checkbox A by the number of selected options from Checkbox B. For example, if a user selects 2 options from Checkbox A and 3 options from Checkbox B, the result should be 2 * 3 = 6.

 

How can I achieve this since I don't see any functions like LENGTH() that can work with arrays?

0 Replies