Hiding Table Columns in a related items table when in a detailed view

[anonymous]

Hi
I’ve just created by first app with app sheet
I have a detailed view which shows a list of related items in a table and I am have trouble only displaying the relevant columns

Initially I tried using one of the prebuild app templates (timesheet) and adapting it and came across a similar issue so I created by own version from scratch.

I have a table called Timesheet from which I’ve created a slice just to show records from the current week.
This slice is referenced as a list in the Employees Table and the slice Current Employees
I have created a view called Employees

When I click on an employee say Julia Guthrie it brings up the detailed view

which lists the related timesheets in a table. Which shows all the columns. Which is frustrating as I only want to have three columns visible

• Date / Time In
• Date/ Time Out
• Total Hours

A second related question is how do I stop a detail of a table row showing if I click on a row in the table

I hope someone has a solution as I seem to be going round in circles trying to solve this

just in case it is relevant, here are the views and system views present so far

please let me know if you need any other screen shots

thanks in advance

[Tommy62]

Die UX-Ansicht, in der Sie sich befinden, wird unter der App-Vorschau (erstes Bild) im Editor angezeigt. Wenn Sie auf die Ansicht klicken, wird diese im Editor auf der linken Seite aufgerufen und Sie können sie dort nach Ihren Vorstellungen ändern.

[anonymous]

Hi Tommy

thank you for your reply

@Tommy62

The UX view you are in is displayed under the app preview (first image) in the editor. 
Clicking on the view will bring it up in the editor on the left 
and you can change it there to your liking.

I have already worked that out
what I trying to control is the data columns that are listed as a result of the look up REF field in the Employees Table which finds matching entries in the Timesheet Table (Actually This Week Slice) for each employee

Related TImesheets is column that references list of matching in the Employees Table

Which returns all columns of the Timesheet Table

and displays them in a table with in the Related Timesheets section of the view

so instead of this table showing the columns

• Name
• Log ID
• Date / Time In
• Date / Time Out
• Total Hours
• Week Num
• Year

I just want the columns

• Date / Time In
• Date / Time Out
• Total Hours

showing.

Now if I click on one of the rows I get a view called detail

which is not available in the list of views

so what have I missed to get that table within the Related Timesheets to display only the columns I want?

[anonymous]

Hi All

I managed to sort it

it was right in front of me and I missed it

All I needed to do was create a Reference View and set the appropriate columns to be displayed