multiple choice equal to twice the same value!

Can you post what your formula field is?     You can get an array using the chosen function ... it will list them in the order defined on the multiple choice field. 

Hmm.. Hard to say without looking at the database.  Perhaps email support and set up a free 15 minutes with them. 

I sent them an email wtih this database.. I cannot figure out how to get the "value" of one of the multiple choice entries.. And I as well get seemingly random values just grabbing the number of the multiple choice. 

@Mconneen,

chosen(MC) returns the values of the chosen items.

numbers(MC) returns the numbers of the chosen items. Note, the function is plural and the index starts at 1 not 0.

item(chosen(MC), N) returns the value of the Nth selected item if it exists. The index starts at 0.

It would be interesting to find out what is being returned with the number() function. It appears to be garbage, but I'd still like to know :)

I think its garbage :-)

Biger

@Sean... Thanks.. I missed the "numbers()" function in the documentation.. :) 

@Mconneen, are you being facetious about missing a function that isn't there? ;). That one is missing as well as %.

@Sean... I plead the 5th.   I should have guess that.. as number(choice) gives me the number.. :) 

Yeah for some weird reason, the only way I could get my select statement to work was with chosen(field) = "A lot of Text". Where with the first 2 choices of the field, I can use 1 and 2...

Is this a faulty issue?

Scott, Difficult to say without more information. You can use the numbers() function, but you have to convert it to a string first. Something like this...

select YourTable where concat(numbers(YourMCField)) = "1, 3, 5"

Hmmm, Multiple choices.... (No easy ones)

Multiple choice fields gives back a Hex-number when using string(), see an example here:

https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/if-statement-not-running-5e055e968ffdac33e8165f3b?post=5e0850898ffdac33e8165fa1&page=1

another example here:

https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/is-it-possible-to-hide-multiple-choice-values-that-are-not-tickedselected-5dcd7aa15fce8a6e89e0d111?post=5dcd887b5fce8a6e89e0d11c&page=1

Steven

Hmmm, Multiple choices.... (No easy ones)

Multiple choice fields gives back a Hex-number when using string(), see an example here:

https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/if-statement-not-running-5e055e968ffdac33e8165f3b?post=5e0850898ffdac33e8165fa1&page=1

another example here:

https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/is-it-possible-to-hide-multiple-choice-values-that-are-not-tickedselected-5dcd7aa15fce8a6e89e0d111?post=5dcd887b5fce8a6e89e0d11c&page=1

Steven