Feature: Time Tracking

Are you in need of adding time tracking in your app? Receiving an error? Give the following a try:

What is time tracking?
Time tracking gives you the capability to log time spent on a project or job while quickly converting the clocked time (time value) to a decimal format.

Where do I set up time tracking?
Time tracking is a functionality of mathematical formulas but its performance is influenced by your virtual columns in your data structure and expressions. Weโ€™ll be primarily focused on the formula portion of time tracking. You can learn more about expressions by reviewing this article and virtual columns in your data structure here.

  1. To find the portion of your data where youโ€™ll need to make adjustments for time tracking, open your app editor by selecting the app youโ€™d like to work on.
  2. The navigation bar on the left side displays a tab titled โ€œData." Click this tab.
  3. Once youโ€™re in the data tab youโ€™ll find a navigation bar along the top of your editor. The second tab is the โ€œColumnsโ€ section. Click this tab.
  4. Once youโ€™re in this tab youโ€™ll see a list of tables. Select the table you would like to have associated with time tracking. App Creators typically name this table โ€œtime trackingโ€ or โ€œemployee clock-insโ€ but you can select whichever works best for your needs.
  5. From here you can add formulas and a virtual column to convert the time values into numerical values the app can understand and obtain your decimal. Please see image below.

Important notes

  • Formulas can be tough to understand, especially when youโ€™re first getting started. Donโ€™t be afraid to post questions in our community if youโ€™re having difficulty determining what type of formula you need. If you want to work with time in a different capacity, hereโ€™s a link to a few other suggestions working with time functions and formulas.
  • To see time tracking in action, hereโ€™s a sample app to review. The linked sample app also demonstrates how to better structure your data when wanting to implement time tracking.
  • For those comfortable with formulas, hereโ€™s the steps for time tracking:
    -For the Total Hours column, we subtracted the time in from the time out
    -For the Total Wages column, we multiplied the Total Hours by the hourly wage
    -Next, you need to add a virtual column so that the app will be able to make the correct calculations of the above formulas. To do this, youโ€™ll need to create a virtual column that can run calculations that arenโ€™t shown in the app and will require the conversion of all of our time values into a decimal format. For the Number of Hours column, we used the following formulas to do this:
    HOUR([Total Hours])
    ([Minutes]/60)+([Seconds]/3600)+[Hours]

Try adding this feature to your app now and let us know how time tracking works for you.

Happy app building!

5 0 1,490
0 REPLIES 0
Top Labels in this Space