Hi everyone in view Related maintenance I want nothing to be displayed when the status of the “status” column is “”.
[Status]=“”
I tried this formula but inserted it in a security filter.
how can i do the same without using the filter?
thank you.
Do you want to hide the whole inline view? Is your status field in a child record or in a parent record?
I’m sorry, but I don’t know the difference between parent and child.
I can send photos of tables
The Maintenance table refers to the GSE table
Okay… then the Maintenance table contains child records. In what table you have the status field?
Table maintenance
Do you have more than one maintenance record (child) for one GSE (parent)record?
yes, I have more than one record
So… do you actually want to hide records depending on the status field’s value?
Exact!
want to make a filter that doesn’t let me see the records with status “ok” but only those with status “”
You could do that with a slice where the condition rule is like ISBLANK([Status]) and then you would need to create an additional virtual list column with Refrows expression where that slice is used as a source.
Unfortunately I don’t think I understood. I’ll try to upload images to be clearer
If you check the related amintenance virtula list column, you will see a REFROWS app formula. This virtual list is coming from the Maintenance table because of the Ref field. Now you need to create your own virtual list column but you should use your slice as a source. If you then hide the existing virtual column, you should see only the filtered list.
Thanks a lot!
You’re welcome