How to show data according to a specific status

[Hussein_Osseily]

Hello ,

I have this one simple question that i would appreciate your help

I have this table in my application it has the following:

Shipment Type. Shipment status. Shipment number

Normal. Delivered. 12345
Express. Undelivered. 123456

I wanna show in the application only the undelivered shipments

How can i achieve that ? With slices ? Incase yes would you please explain the expression that i need to use ? [Shipment status] = “Undelivered” ? What about the slice function it’s set to auto, is that right ?

Appreciate your help

Thank you

[Aurelien]

Hi @Hussein_Osseily

You are on the right track

Hussein_Osseily:

With slices ?

Hussein_Osseily:

[Shipment status] = “Undelivered”

and about that:

Hussein_Osseily:

What about the slice function it’s set to auto, is that right ?

yes, but it’s up to you

[Hussein_Osseily]

I dont know what am doing wrong
Ive created a slicer, set the expression [status]=“unreturned” (written exactly the same as in the table)

slice columns I pressed on status

slice actions its set to Auto no other options, its either auto or nothing (which is to delete it)

please see this screenshot

[Aurelien · Accepted solution]

Hi @Hussein_Osseily

That looks OK, what’s wrong with it ?
If you want to display the informations from this slice, then create a new view (UX/View/New View) and set the data source to this slice

(please identify me with “@” otherwise I won’t be notified)

[Hussein_Osseily]

@Aurelien thank you, this worked like magic, the thing i was not doing right is not creating a view for the new slicer.

I deleted the view of the old sheet, created the view of the slicer only and it is all fine, the application is only viewing the unreturned status

Thank you so much for your help

[Aurelien]

Happy to hear that worked, you are welcome !

[Hussein_Osseily]

@Aurelien sorry to bother you again, do you think below is possible ?

In my application I have 4 tabs they’re all “READ ONLY”
am wondering if i can grant access to Edit in 1 Tab for 1 specified user only

[Aurelien]

Hi @Hussein_Osseily

Yes you can.

In the Data/Tables panel, you’ll notice you can choose among 4 options: add, delete, update, and read-only.

On the potion-icon next to it, you also have the possibility to set an expression to make the update mode to depend on user email or user role.
By default, an expression will be suggested. It’s up to you to adapt it to your needs.

Let us know if it’s unclear !
Cheers

[Hussein_Osseily]

@Aurelien you are a genius, thanks a lot!
its working perfectly