Feature Overview Video
The Time Tracking Log field allows one or many members to log time in hour / minute increments directly in a single field within a record. The field captures:
Member
Time (using natural language by typing things like 1h 30m, 1hr 30 mins, 8 hours)
Notes (up to 250 characters to specify activities or results from the work effort)
The field displays the Total Time logged as a summation across all time log entries.
Consider a use case for Client Engagements where service consultants track time spent on a particular task or project.
Adding a Time Tracking Log field
From Grid View
From Grid View
Click the + menu icon after the last column header or open the Column Menu by clicking on a column header's dropdown icon and then select "Add Field to the Right."
Select "Time Tracking Log," and a window will open to configure the field. You can search the name for a quick find.
From Record View
From Record View
The fastest way to add a field from an open Record View to is simply click the + sign next to a current field to add a new field below.
See a Time Tracking field being added in Edit Record View below:
Customizing the field
Solution Managers can choose between two display formats - pill or text (date). Pill is the default option and you can customize the pill color. Solution Managers can make entries required as needed.
Check out quick articles on Adding Help Text to fields.
Logging Time
Users have a couple of options when logging time:
They can specify a specific Date for the time log (in both Duration and Time Range entry tabs)
They can use the Time Range tab to specify start and end times
Auto-Time Tracking: Timer
The timer tab allows you to start a timer that will record the amount of time spent working on tasks and projects.
Simply click the green play button to start the timer. You also the ability to leave notes in the text box to indicate what you were working on.
A pill will display in the bottom right corner with the running time as you access other Records, Tables or Solutions.
If you click on the pill, the timer window will display. Clicking on the red button will stop the timer and log the time into the field.
After stopping the timer, the floating pill will still display.
All time will automatically display in the time tracking log field! You can then use Grouping and the Summary Footer to see totals for groups of records.
Advanced Tracking: TTL Usage in Formulas
Our time tracking log field displays the total time tracked on a record by all users, but what if you're looking to get a bit more granular? Using our formula field, you can extract and narrow down different elements of data from within the Time Tracking Log field.
The following subfields are available when using dot notation in formulas:
Reported By
Reported On
Reported Time
Notes
To show notes with multiple entries use: ARRAYUNIQUE([Time Tracking Log].[Note], " -- ")
For example, maybe a task will span several weeks and you'd like to see how long it takes, but you also want to be able to see how much time was spent so far in the current week. To do that, your formula would look like this:
SUM(
GET_LIST(
## Filter conditions - In this case using the NOW function but stripping the time to get any value for the entire week.
[Time Tracking Log].[Reported On] > DATEADD(DATE(DATE_FORMAT(TODAY(), "compact")), -WEEKDAY(TODAY(), "Monday")+1, "days")
AND
[Time Tracking Log].[Reported On] < DATEADD(DATE(DATE_FORMAT(TODAY(), "compact")), -WEEKDAY(TODAY(), "Monday")+6, "days"),
## Field to Return
[Time Tracking Log].[Reported Time]
)
## Taking the final value which is stored in seconds and dividing by 3600 to get the result in hours.
)/ 3600
