Forum Discussion

felix571's avatar
felix571
New Member
3 years ago
Solved

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...
Need Help
Tutorial Requests
  • felix571's avatar
    felix571
    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!

felix571's avatar
felix571
New Member
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!