0

Text value from dynamic choice field

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

text(field_name) is not working

9replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • RoSoft_Steven
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

    Think this works:

    record(sourceTable,number(DynamicChoiceField)).YourFieldName

    Steven

    Like
  • 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.

    Like
    • UKenGB
    • UKenGB
    • 7 mths 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.

    Like
    • 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 🤔.

      Like
      • Fred
      • Fred
      • 7 mths 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.

      Like
    • UKenGB
    • UKenGB
    • 7 mths 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?

    Like
    • 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.

      Like
      • Fred
      • Fred
      • 7 mths ago
      • Reported - view

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

      Like
      • UKenGB
      • UKenGB
      • 7 mths ago
      • Reported - view

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

      Like
Like Follow
  • 7 mths agoLast active
  • 9Replies
  • 655Views
  • 3 Following