0

multiple choice equal to twice the same value!

I have a multiple choice with 6 different choices... I had an issue to use the result in a formula so I made a number field and I put a formula when it s been updated. The formula set the vale of this field = to the multiple choice ...

when I select the first item, it give me 1, the second item = 2...etc but when I select the 5th item, it give me 1 and the 6th gives me 2...

How is it possible to gives me twice the same number value?

12 replies

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    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. 

    • plafontaine44
    • 4 yrs ago
    • Reported - view

    I tried field := multiplechoice in on update and also concat...text...etc and nothing works! I have a similar multiplechoice field and it works well with the same formula... pretty weird.. :)

    • Mconneen
    • 4 yrs ago
    • Reported - view

    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. 

    multipleChoice

    • Sean
    • 4 yrs ago
    • Reported - view

    @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 :)

    • Birger_H
    • 4 yrs ago
    • Reported - view

    I think its garbage :-)

    Biger

    • Mconneen
    • 4 yrs ago
    • Reported - view

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

    • Sean
    • 4 yrs ago
    • Reported - view

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

    • Mconneen
    • 4 yrs ago
    • Reported - view

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

    • Thorn_Creative
    • 3 yrs ago
    • Reported - view

    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?

    • Sean
    • 3 yrs ago
    • Reported - view

    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"

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

Content aside

  • 3 yrs agoLast active
  • 12Replies
  • 3307Views