Hi Steve

So you have a multi-choice field with 3 choices. Make another formula field and put this in the formula:

number(multichoicefieldname)

As you make your choice you will see different numbers (1,2,3,4,5,6,7). What is happening is that Ninox assigns a value (not the number you see when you setup the field) to each choice (1, 2, 4). Then adds up the values depending on choice selected.

So to answer your question, for 3 choices, you can do something like:

switch multichoicefieldName do
case 1:
    5
case 2:
    10
case 3:
    15
case 4:
    15
case 5:
    20
case 6:
    25
case 7:
    30
end

So we have taken all possible combination and assigned a value to display depending on the choices made in your multi choice field. This will not scale very well so if you need to handle more choices then another solution will need to be offered.

Hope this helps and let us know how it goes.

Are you part of the Ninox Webinar EN 2022 cloud team? If not then email support@ninox.com and ask to be added.

Then look at Cascading DC Fields DB for some great work by RoSoft_Steven Rooryck .

For something like this I would recommend that you use a 3rd table to track the selection.

You need a 3rd table to track the choices selected from the different multiple choice fields.

Can you let us know what your DB structure looks like, i.e. table names, table relationships, important field names?