Forum Discussion

JaimeStrawderma's avatar
JaimeStrawderma
Qrew Cadet
6 years ago

Calculating time based on a Task

I have a Task Name field that is a drop down with about 12 options. I have a Task Count field wherein the user inputs how many times they performed that task. I have a Task Time field that will multiply the Task Count field by a time value assigned to the Task Name. The trick is that each task in the drop down will have a different amount if time to complete. How would I be able to calculate the Task Time based on the time for each of the drop down tasks?
 
  • No Problem.

    Your task name is probably just a down and dirty multiple choice field.  You will need to convert that to being a lookup field from a relationship and then you can look up the std time per task. 

    Make a new table called Standard Tasks with two fields, Task Name and Task Time (a numeric field of the # of minutes).

    Set the Key field to be the task name

    Copy the 12 multiple choices onto your clipboard off the multiple choice field properties.

    Use import export to import them into your Standard tasks table. 

    Make a relationships where 1 Standard Task has many detail records (not sure what your current table is called), but do not initially create any lookup fields when you make the Relationship.  The go back and lookup the standard Task Time down into your details table.

    Now you can make your formula with varying Standard Task times per task Types.
    • JaimeStrawderma's avatar
      JaimeStrawderma
      Qrew Cadet
      Okay, I am up to "lookup the standard Task Time". Two things...Do I need to have the task times in the Standard Task Table somewhere? and do I use the P Task Time field as that lookup field? Thank you.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      Yes, you will need to enter the std task times into your std tasks table and look that up down to the detail records.  I don't know what P Task Time is.
  • Hi Austin, Thank you. Two questions...1. the numbers you have in the first formula 2,4,3,7, are they meant to represent the amount of time for that task? and 2. I will have 12-15 lines for tasks, do I duplicate this formula for each "Task Time" field?
  • I think that Austin withdrew his response as a Relationship is a better way to go for future sustainability of the app, less maintenance and more visibility into the std times.
    • AustinK's avatar
      AustinK
      Qrew Commander
      That was it. I saw your response was so different than mine that I am pretty sure I completely misunderstood the issue. I was looking at using a case formula for each Task to get the number of hours to do the calculation. Relationship is definitely better if there will be many changes to the tasks or really any major ones.
  • Sounds good. I'll start building this out but I may have a question or two along the way. Thanks again for the help.