Text value from dynamic choice field
How do i extract the text value from dynamic choice field?
text(field_name) is not working
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.