Questions sur le choix multiple (dynamique)
How the first multiple choice affects the next multiple choice.
I have uploaded the file, thanks for the reply。
5 replies
-
Here is a sample. Scroll down on the Dashboard till you see MC1. As you make a choice in MC1, MC3 will update with records that have a relationship in the field Multichoice to the selection in MC1.
-
Remember when working with multiple choice fields, as you start selecting more than 1 choice you get an array as a result. Which means you can't use the = anymore because that is telling Ninox to look for an exact match.
You can use the contains() command like this:
let xx := numbers(company); select Staff where contains(text(xx), text(company))I used numbers() because you are using records from the Company table so, to me it is easier to deal with record Id.
In the contains() command you want the larger group to be before the "," and what you want to look for after.
-
I'm currently having this issue. The Choice data I'm using is incorrect with the data returned by record ID. What should I do? I updated the file. Thank you for your reply.
said:
I used numbers() because you are using records from the Company table so, to me it is easier to deal with record Id. -
This data return is inconsistent. Where is the problem, Fred?
-
At the end, the “chosen” command was successful, thank you.
-
Content aside
- Status Answered
- 5 mths agoLast active
- 5Replies
- 64Views
-
2
Following