0

the chosen one (or not)

I'm trying to access the choices from a Multi Choice (Dynamic) field, named 'colour' in the current table. Before I try more complicated concatenations (well, I tried but they failed), if (as a table column) I try to simply use:-

chosen(colour)

I just get an error:-

"Function is not defined: chosen(dmulti)"

I can use

numbers(colour)

which correctly returns the id numbers. Or:

chosen(colour,21)

correctly returns true for rows whose colour matches that id. But I simply cannot use chosen(colour), even if I also use the text() function and/or concat(). Ninox just refuses to accept the use of chosen(colour).

The use of chosen() is all clearly explained in the manual, but this simplest of all uses fails utterly.

Would appreciate some advice on why this fails and what can be done about it as I've tried what the manual shows and many other combinations, but nothing seems to work.

5 replies

null
    • UKenGB
    • 2 yrs ago
    • Reported - view

    Seems to be a problem with Dynamic MC fields. Using numbers() can return the Ids of rows in the linked table, but chosen() currently doesn't work for these MC(Dynamic) field types.

     

    So looks like looping through the Ids to get the text values. Something of a PIA especially when the docs make NO mention of any such limitation.

    • Alain_Fontaine
    • 2 yrs ago
    • Reported - view

    The subject has been discussed here: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/vlookup-formula-between-2-tables-5e7893acd7072204e5f22704?post=5e7893acd7072204e5f22705

    • UKenGB
    • 2 yrs ago
    • Reported - view

    Thanks for that Alain. I was having further problems with Ninox summarily deleting Formula columns that would work when first entered, but then deleted after switching to a different screen/table and back. Seems Ninox can not only MISTAKENLY think it is receiving an array when it needs a single value, but it can also have a problem with numbers. Every time I tried to use numbers(MCDfield) the Formula column would be deleted when returning to that screen.

     

    This morning I used the forumla in the linked thread and not only is that a neat way to retrieve multiple values from the other table, but using text(numbers(MCDfield)) semed to stick and not cause the entire column to be deleted every time.

     

    Thanks again. I was able to use the ideas in that thread to achieve what I required.

    • Alain_Fontaine
    • 2 yrs ago
    • Reported - view

    About the issue concerning the display of arrays in column formulas, did you read my answer in the thread you initiated ("disappearing formulas")?

    • UKenGB
    • 2 yrs ago
    • Reported - view

    Yes, thank you. I replied there.

Login to reply

Content aside

  • 2 yrs agoLast active
  • 5Replies
  • 497Views