Help with Calculating Average Completion Time Over Several Records
Hello, I have a table where each employee progresses through a stage with three date fields: Start Date & Scope/Role, Verify Eligibility & Funds, and Create Visa Plan. I also have a formula field that tracks the status of this stage (Not Started, In Progress, Complete) and calculates the number of days taken if the stage is complete. I need help calculating the average number of days it takes for employees to complete the stage. For example, if Employee 1 took 14 days, Employee 2 hasn't started yet, Employee 3 took 21 days, and Employee 4 is In Progress, I want to calculate the average completion time, which would be 17.5 days (it should only count those completed). Can anyone suggest the best way to achieve this? Thanks so much! Meag
A form button that will force record add on a specific form.
I have a tasks table, but I want to allow users to enter simple tasks or complex tasks. One form for simple tasks and another for complex tasks. This works for complex tasks and is the default form for all roles. URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_145=" & URLEncode ([Project Number])& "&z=" & Rurl() I am trying this one for simple tasks, but it still loads the complex tasks form (ID=11) even though the URL says form ID 16. URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Project Number])& "&z=" & Rurl() Also, this latter one is not loading the related project like the first one does. There has to be a simple way to load form 16 even though it is not the default for all roles.Time Zone change
Good morning, I am building a Transportation application for my team to use. When we request a pickup time from our transportation vendor, it is always in central time since we are based in Texas. Can QB convert the central time to local time based on my selected city? For example, I have an employee who needs to be picked up at LAX at 10 a.m. Pacific time, but we can only enter 12 p.m. Central time. How can I build a formula in QB that will convert noon central to 10 AM when I select LAX as a city? The same goes for all the cities we service. How can I make sure Daylight savings are accounted for? I have attached a spreadsheet of the cities we service regarding their summer and winter times.
QR Code to form
I am trying to Make a QR Code Using the quickchart.io formula I have made one that will take me to the inventory part. Is it possible to have it take me directly to making child record ( Inventory Usage ) form for that record??? its setup as Inventory > Inventory Usage i would like to have a binder with all the parts that can be scanned to "Check out" the part(s) and take the user directly to the form so they can deplete the inventory. Any help on this would be greatly appreciated.
