Help desk ticket time entry
-
- Posts: 28
- Joined: 2015-11-02 01:22
Help desk ticket time entry
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!
- Attachments
-
- TicketEntrySample001_2024-11-06_13-22-52.jpg (78.7 KiB) Viewed 428 times
Jeff MacDougall
Re: Help desk ticket time entry
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.
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.
- Marcelo Vitoria
- Veteran Member
- Posts: 81
- Joined: 2016-10-11 12:08
Re: Help desk ticket time entry
Hello
I like your theme and the layout of the fields. Could you tell me which theme or component you are using?
Thanks
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 !
Basic Sinclar - Clipper - Visual Foxpro - VB6 - PHP
AppGini 24.17 - AdminLTE - SPM
https://www.workspaceservices.com.br
Coding since 1982 !
Basic Sinclar - Clipper - Visual Foxpro - VB6 - PHP
AppGini 24.17 - AdminLTE - SPM
https://www.workspaceservices.com.br
Re: Help desk ticket time entry
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.
There are ready codes in the Internet which you can search or ask ChatGPT.
-
- Posts: 28
- Joined: 2015-11-02 01:22
Re: Help desk ticket time entry
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
- Marcelo Vitoria
- Veteran Member
- Posts: 81
- Joined: 2016-10-11 12:08
Re: Help desk ticket time entry
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
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 !
Basic Sinclar - Clipper - Visual Foxpro - VB6 - PHP
AppGini 24.17 - AdminLTE - SPM
https://www.workspaceservices.com.br
Coding since 1982 !
Basic Sinclar - Clipper - Visual Foxpro - VB6 - PHP
AppGini 24.17 - AdminLTE - SPM
https://www.workspaceservices.com.br
Re: Help desk ticket time entry
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
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
Some postings I was involved, you might find useful:
Multi Path Upload (MPU) / dynamic upload folder; SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button
Multi Path Upload (MPU) / dynamic upload folder; SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button