Slice to show another slice or table in ref column

Hi,

I currently have two tables “Timesheet” and “Work Orders” and each of these tables have a slice “My Timesheet” and “My Work Orders”.

When I am in the slice “My Work Orders” or in the table “Work Orders” it has a Ref Column that links to the “timesheet” table. However what I would like to accomplish is that when I am in the slice “My Work Orders” it shows the slice “My Timesheet” and then when I am in “Work Orders” it will show the table “Timesheet”.

I am not sure where to begin.

Thanks,
Josh

I think we need more details on what you mean by this statement.

Maybe you mean when you are viewing a Work Order record it shows the RELATED Timesheet records?

And vice-versa when viewing a Timesheet record the app shows RELATED Work Order records?

1 Like

Yes. That is correct that is what it does currently. However I use a slice to show me “My work Orders” instead of all “work orders”. What I would like to do is when I am in the “my work orders” view it shows a Ref column of “my timesheet”

In this screenshot it is showing the data of “my work orders” which is a slice. The ref column pointed to is of “timesheet”.

The problem is that it shows all timesheet records for this work order not just the slice of “my timesheet”.

However I still want the work order table to show all timesheet records of this work order when i am not in the slice of “my work orders”


This view is correct because it is of the data work order therefore i want it to show all related timesheet records for this work order

Essentially, I do NOT want to see everyones timesheet records when I am in the view of “My Work Orders” I only want to see my timesheet records. BUT when I am in the view of “Work Orders” I DO want to see everyones timesheet records.

Hopefully this helps clarify what I am looking to do.

Thanks,
Josh

I think I have it now. The last paragraph cleared it up.

I think what you need to utilize is a Security Filter on the Timesheet table - no Slice needed. I have not used them yet but from what I know it is extremely simple.

In the Security section, select the Security Filters tab, open the Timesheet table and insert an expression that will identify the rows for the logged in user. Viola! For each logged in user, they will only see Timesheet records that pertain to them.

You can be as complex as you need. For example, you may want Managers to see ALL Timesheet records so you can simply adjust your expression to identify which logged in users are Managers.

You can read more about Security Filters here: