Help desk ticket time entry

[jmacdougall]

I am working on a "Tickets" table and would like to allow technicians to enter their time in on ticket. The ticket system we currently use (see screenshot), starts a timer once the ticket is opened and you can edit the time as well. I would like to setup fields like seen in the red outlined bottom box. If a user enters a START TIME and an END TIME, it automatically enter the total time result in the TIME WORKED field, which can also be tweaked, it rounds it up to 15 minute increments. THat then shows a final time of HOURS TO BILL. That is then saved to the record. Eventually, this needs to make it to our Quickbooks application but, I am not at that stage yet until I can get the TIcket Time Entry form figured out. Thanks for your help!

[pbottcher]

Hi Jeff,

not sure I get you question correct, but what do you have so far and what did you try that is not working. Setting up a time field in AppGini should be easy. Doing the calculation should not be that complicated.

[Marcelo Vitoria]

Hello
I like your theme and the layout of the fields. Could you tell me which theme or component you are using?

Thanks

[ppfoong]

You can calculate the time difference either using Javascript, PHP or MySQL. If you need real-time display, Javascript is the best approach. For PHP approach, you can make use of hooks. For MySQL approach, you can make use of AG calculated field.

There are ready codes in the Internet which you can search or ask ChatGPT.

[jmacdougall]

I appreciate your help. Marcelo Vitoria, I took that screenshot from the current solution we are using. i am trying to emulate that in the app I am building.

[Marcelo Vitoria]

Hi jmacdougall

With AppGini, I believe you can achieve a similar result using the plugin or components in the bizzworxx AppGini Helper JavaScript Library.

Now, calculations with dates, I believe you can execute them using hooks.

This link has some examples of calculations with dates
https://www.php.net/manual/en/datetime. ... hmetic.php

Good luck