0

Text value from dynamic choice field

How do i extract the text value from dynamic choice field?

text(field_name) is not working

9 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 2 yrs ago
    • Reported - view

    Think this works:

    record(sourceTable,number(DynamicChoiceField)).YourFieldName

    Steven

    • Piotr_Wareciak
    • 2 yrs ago
    • Reported - view

    It looks like its returning everything , not only selected values. 

    Ill describe what im trying to do , maybe this would help.

    I have 2 tables:

    1. T.Period - list of historical Periods with columns: Period, Def, Sequence

    2. Artists - List of people where i have dynamic multiple choice field with select: (select 'T.Period') order by Sequence and dynamic value name Period

    In table 1 i want to make view in each period tab that shows where in table 2 this period was used.

    • UKenGB
    • 1 yr ago
    • Reported - view

    Waking up this thread, but it's pertinent to what I'm seeing.

    When trying to use text(DynamicChoiceField) in 'Trigger after update', it doesn't work. A simple test of when the DCF is updated, write its value to a text field shows that nothing happens.

    If instead I use record() to get the text value from the source table, then I can write that to the text field.

    So pretty much as stated above. But…

    If I create a formula field whose value is text(DCF), then that formula field correctly shows the text value of the DCF's choice.

    So we have a huge inconsistency in how Ninox implements text(DCF). In one case it does what you expect, but not in the other.

      • Ninox developper
      • Jacques_TUR
      • 1 yr ago
      • Reported - view

      UKenGB 

      When I type : Text := text('Choice (dynamic)') 

      In the Trigger after update of 'Choice (dynamic)', it works fine. I can't reproduce the problem 🤔.

      • Fred
      • 1 yr ago
      • Reported - view

      I'm able to duplicate it. I'm on v3.6.8 of the MacOS app and v3.6.10 on the iPad.

    • UKenGB
    • 1 yr ago
    • Reported - view

    I'm also using MacOS app. So perhaps this is a platform implementation issue? Jacques, on what platform are you using Ninox?

      • Ninox developper
      • Jacques_TUR
      • 1 yr ago
      • Reported - view

      UKenGB Usually I use the web and everything works fine.  This is what I did my first test with.  But here I just did a test on my iPhone and I confirm that it does not work on this platform.

      • Fred
      • 1 yr ago
      • Reported - view

      UKenGB I would recommend that you submit a ticket with Ninox. Hopefully they will fix it.

      • UKenGB
      • 1 yr ago
      • Reported - view

      Fred We probably all should, then maybe they might take more notice.

Content aside

  • 1 yr agoLast active
  • 9Replies
  • 757Views
  • 3 Following