Help desk ticket time entry

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
jmacdougall
Posts: 28
Joined: 2015-11-02 01:22

Help desk ticket time entry

Post by jmacdougall » 2024-11-06 18:35

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! :D
Attachments
TicketEntrySample001_2024-11-06_13-22-52.jpg
TicketEntrySample001_2024-11-06_13-22-52.jpg (78.7 KiB) Viewed 428 times
Jeff MacDougall

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1667
Joined: 2018-04-01 10:12

Re: Help desk ticket time entry

Post by pbottcher » 2024-11-06 18:40

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.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

User avatar
Marcelo Vitoria
Veteran Member
Posts: 81
Joined: 2016-10-11 12:08

Re: Help desk ticket time entry

Post by Marcelo Vitoria » 2024-11-08 01:44

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

Thanks
Marcelo Vitoria
Coding since 1982 ! :geek:
Basic Sinclar - Clipper - Visual Foxpro - VB6 - PHP
AppGini 24.17 - AdminLTE - SPM
https://www.workspaceservices.com.br

ppfoong
Veteran Member
Posts: 52
Joined: 2021-07-13 16:46

Re: Help desk ticket time entry

Post by ppfoong » 2024-11-08 01:59

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
Posts: 28
Joined: 2015-11-02 01:22

Re: Help desk ticket time entry

Post by jmacdougall » 2024-11-08 18:55

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.
Jeff MacDougall

User avatar
Marcelo Vitoria
Veteran Member
Posts: 81
Joined: 2016-10-11 12:08

Re: Help desk ticket time entry

Post by Marcelo Vitoria » 2024-11-08 19:28

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
Marcelo Vitoria
Coding since 1982 ! :geek:
Basic Sinclar - Clipper - Visual Foxpro - VB6 - PHP
AppGini 24.17 - AdminLTE - SPM
https://www.workspaceservices.com.br

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1205
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Help desk ticket time entry

Post by onoehring » 2024-12-06 14:35

Hi,

just stumbled over this topic. I know, building is nice, but for an easy to use ticket system I always recommend HESK (free!): https://www.hesk.com

Olaf

Post Reply