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?