We have a form with multiple products grouped into categories. Each group of products is in a checkbox field with values that combine the product ID and the cost. We would like to get a sum of the costs for the selecteditems in each group.
We are already doing something similar on another form that uses a table instead of checkboxes. In that form, there is the Sets table with a dropdown field called AddressSets. The dropdown field has a list of choices and values:
The first three characters of the value is the Product ID, the second two are the postage and the last ones are the cost. The formula for the Price field in the row is =MID(INDEX(Sets.AddressSets,ROW()),6,100). The formula for Postage is =IF(SendTo="PickUp",0,IF(LabelsLists="Lists",0,MID(INDEX(Sets.AddressSets,ROW()),4,2))). The Total Cost formula is SUM(Sets.Total).
Can we do something similar with a checkbox field? Is there something like =MID(INDEX(Sets.AddressSets,ROW()),6,100) for getting the values for all the selected items?