Forum Discussion
felix571
3 years agoNew Member
Assign column field to custom filter
Hey guys, I created a custom table as you can see here: I am sorting the column "Status" using the column "Preset order". After that, I created a filter and connected it to my custom tabl...
- 3 years ago
Thank you for your answers!
It turned out, that it was a lot easier to just "translate" the data model field with the original status (e.g. "MIAR OFMA") to the desired status (e.g. "Notification closed").
I did this with the CONTAINSSTRING-function in a new column, which is giving me a TRUE or FALSE.
This TRUE or FALSE is translated to "Notification closed" or "Notification in progess" with a simple if-function in a seperate new column.
The first four letters of the original status are containing enough information for me to distinguish between "Notification closed" or "Notification in progess".
I don´t know if thats a super clean solution, but it works for me.
Thanks again!
lbendlin
Super User
3 years agoLearn about Column Groups. You may not even need the custom table.