BobbyB Posted March 16, 2021 Posted March 16, 2021 Hello, I need to pull off Timesheet entries but need to view details of any linked requests. When I tried to Join Requests with Timesheet Categories I didn't see any related fields to join. My current Timesheet report has Timesheet Categories joined with Timesheet Values but I also need info from the Requests table. Is there anyway to do this? Many thanks, Bobby @Alisha
Alberto M Posted March 16, 2021 Posted March 16, 2021 @BobbyB, I got the requests joined to categories through the timesheet values table. Joining the requests table with the timesheet values table and then joining the timesheet values with the categories. Will this be useful for you? 1
BobbyB Posted March 16, 2021 Author Posted March 16, 2021 Thanks @Alberto M, but every time I try to add in the requests table it puts in a project table....very annoying...... or If I put in Requests as the first table it won't show any 'Join' actions.... Unsure why it's doing this... Thanks, Bobby @Alisha
Alberto M Posted March 16, 2021 Posted March 16, 2021 @BobbyB, I'm not sure if this have any impact, but I've designed the reports in the Timesheet app. Are you doing the same?
BobbyB Posted March 16, 2021 Author Posted March 16, 2021 Thanks @Alberto M, I've managed now to get it working with Requests at the beginning by using your joins, thanks again for your help Bobby @Alisha 1
George Warren Posted October 12, 2023 Posted October 12, 2023 @BobbyB @Alberto M - You don't happen to know how to pull in the team of the person logging the time? I assume there would need to be a join from the accounts table to an organisation or team table, is there any documentation for table relationships? Its just where we have tickets passed between teams, we cant just use the team that the ticket ended up assigned to.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now