Text value from dynamic choice field
How do i extract the text value from dynamic choice field?
text(field_name) is not working
-
Think this works:
record(sourceTable,number(DynamicChoiceField)).YourFieldName
Steven
-
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.
-
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.
-
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
. -
I'm able to duplicate it. I'm on v3.6.8 of the MacOS app and v3.6.10 on the iPad.
-
-
I'm also using MacOS app. So perhaps this is a platform implementation issue? Jacques, on what platform are you using Ninox?
-
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.
-
UKenGB I would recommend that you submit a ticket with Ninox. Hopefully they will fix it.
-
Fred We probably all should, then maybe they might take more notice.
-