LinkedIn
Twitter
Hi, please I am creating a timesheet tracker, (similar to https://www.appsheet.com/templates/Employee-timesheet-log-with-historical-calendar?appGuidString=372...).
I would like to know if it is possible on the top of the sheet, it shows me to sum of the total time (Total time= Log out - Log in) instead of only count the events.
Thank you
Solved
2 ACCEPTED SOLUTIONS
AS @Steve said, unfortunately no. The reason is...when there are lots of rows in that table, the counter has an important function as an indicator to the user that more rows exist.
HOWEVER, you can Group that Inline table and use the Group header to show an aggregated amount. So in your Case you could add a column to each row named maybe "Total Time" that computes the time for that row. Choose to group by this column (you would end up with only this one grouping) and then choose the SUM function for that column as the aggregate. See image below.
Hi @WillowMobileSys Maybe be I am unable to create the behavior or did not understand properly but it sounds as per the posts below and my brief testing that for inline view, the group by values show only when one displays the inline view independently.
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Trying-to-group-inline/m-p/274106
Just in case it helps, another workaround is something as below sample. Have created a virtual column with an expression SUM([Related Ref Rows][Total]) Where [Total] is price of each line item in the child table. Have placed this VC( as highlighted in orange ) just above the inline table in the parent detail view so that the total is readily visible.
Also tested that with display name expression containing SUM() expression, one can show the total in the reverse reference column name as highlighted in green below.
AS @Steve said, unfortunately no. The reason is...when there are lots of rows in that table, the counter has an important function as an indicator to the user that more rows exist.
HOWEVER, you can Group that Inline table and use the Group header to show an aggregated amount. So in your Case you could add a column to each row named maybe "Total Time" that computes the time for that row. Choose to group by this column (you would end up with only this one grouping) and then choose the SUM function for that column as the aggregate. See image below.
Hi @WillowMobileSys Maybe be I am unable to create the behavior or did not understand properly but it sounds as per the posts below and my brief testing that for inline view, the group by values show only when one displays the inline view independently.
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Trying-to-group-inline/m-p/274106
Just in case it helps, another workaround is something as below sample. Have created a virtual column with an expression SUM([Related Ref Rows][Total]) Where [Total] is price of each line item in the child table. Have placed this VC( as highlighted in orange ) just above the inline table in the parent detail view so that the total is readily visible.
Also tested that with display name expression containing SUM() expression, one can show the total in the reverse reference column name as highlighted in green below.
