Search…
Resources
Related Links
numbers
To return the IDs of the selected choice values of a given multiple-choice field
With this function, you'll get the IDs of the selected options.
  • Multiple-choice field: You get the choice IDs
  • Dynamic multiple-choice field: You get the record IDs

numbers(multi)
numbers(dmulti)

[number]

We have a multiple-choice field "Favorite sports" with the following choice values:
Favorite sport
ID
Selection
Basketball
1
x
Climbing
2
​
Dancing
3
x
Sailing
4
x
Soccer
5
x
Basketball, Dancing, Sailing, and Soccer are selected.
​
numbers(myMultiChoice) To return the internal IDs of the selected choice values of a given multiple choice field.
numbers(Status)
Result: [1,3,4,5]
​
numbers(myDynMultiChoice) To return the record IDs of the selected choice values of a given dynamic multiple choice field.
numbers('Favorite sports')
Result: [1,3,4,5] In this example "Favorite sports" is a dynamic choice field that refers to the table "Sports".
​
You can change dynamically table views based on the selection of your dynamic choice field.
The following script is to be added to the formula field of the table view.
let dChoiceIds := numbers('My Dynamic Multi Choice');
for employee in select Employees do
for id in dChoiceIds do
if id = number(rec.Id) then employee end
end
end
Result: You see the records of the employees in the table view that are selected in the dynamic multiple choice field.

​chosen, which evaluates multiple-choice fields.
Last modified 2mo ago
Export as PDF
Copy link
On this page
Syntax
Return
Examples
See also