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 multip...
Forum Discussion
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.
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.
Excellent. Thank you.