conditional unique() in column
my view should select all records in elements where the column "text" is unique for one label (being a linked record).
So text "a" might appear both for label1 and label2, thus should appear for each label, but all rows with text "a" for label1 should become one single row...
It shouldn't be hard but I fail.
16 replies
-
Are you asking for a column filter that can look at two different columns (label1 and label2)?
To the best of my knowledge the column filter only looks in the field that it represents. You might have to create a new field that combines the two field data that you can then filter that new field/column.
-
Is it not similar to this: https://forum.ninox.com/t/m1y3v59?r=y4yxqwa
-
This Formula for a view, e.g., will try to find a match between text_c in two tables. It works, but prompts the one record that should be returned 94 times (as often as the match occurs in myIO.elements)
if preview then let myIO := this; let all_elements := (select elements where 'Information Object' = null and 'has label' = first(myIO.elements.'has label')); for i in myIO.elements do for f in all_elements do if f.text_c = i.text_c then first(f) end end end end
I still have issues to fully understand how Ninox is using for and if statements in queries...
Your help is most appreciated, especially by our PhD students!
-
I managed!
Content aside
- Status Answered
- 10 mths agoLast active
- 16Replies
- 190Views
-
3
Following