Search
⌃K
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

Syntax

numbers(multi)
numbers(dmulti)

Return

[number]

Examples

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.
1
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.
1
numbers('Favorite sports')
Result: [1,3,4,5]
In this example, Favorite sports is a dynamic choice field that refers to the Sports table.
​
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.
1
let dChoiceIds := numbers('My Dynamic Multi Choice');
2
for employee in select Employees do
3
for id in dChoiceIds do
4
if id = number(rec.Id) then employee end
5
end
6
end
Result: You see the records of the employees in the table view that are selected in the dynamic multiple choice field.

See also

​chosen, which evaluates multiple-choice fields.
Last modified 5mo ago