Confirm whether all multi-choice in the subtable are selected
![](https://s3-us-west-2.amazonaws.com/media.forumbee.com/i/f2449e64-1d52-4049-93e1-6337c348e6c4/h/547.jpg)
How can I confirm that all multiple choice in the subtable are selected?Thanks
5 replies
-
How can I confirm that all multiple choice in the subtable are selected? Thanks
-
You want a way to see that all choices in a choice field have been selected at least once in a record in the subtable?
Just to confirm:
Is the choice field a multiple choice or single choice field?
Is it a dynamic or regular choice field?
Do you want the check field to happen at the parent level?
-
HI Fred:
Just to confirm:yes ,no matter how many pieces of data there are in the subtable, as long as 1.2.3 are selected once, it will be completed
Is the choice field a multiple choice or single choice field?
multiple choiceIs it a dynamic or regular choice field?
dynamicDo you want the check field to happen at the parent level?
YES
Thanks -
Here is something that will show you which choice have not been selected.
let allChoices := (select TableA).number(Id); for loop1 in allChoices do let choiceCheck := InvoiceItem[contains(numbers(dMC1), loop1)]; if choiceCheck = 0 then loop1 end end
Replace:
TableA with the table that your dMC is based on
dMC1 with the name of your dMC field
Since we are dealing with record Ids, but need just the value and not their record reference we need to use the number() command in line 1.
Spent a few moments trying to figure out why the correct results were not showing up and that is where debugValueInfo() came in handy. I showed me that I was getting "C1" which is nid info, so Ninox doesn't like showing nid without some other command.
-
In the sample database provided with the question, the multiple choice field is indeed static, not dynamic. In this context, the following formula computes the percentage of options selected.
let a := [1, 2, 3]; let b := '數據表2'.numbers('多項選擇'); 100 * cnt(a[contains(b, this)]) / cnt(a)
Content aside
-
1
Likes
- 5 mths agoLast active
- 5Replies
- 67Views
-
3
Following