Ticketing System

[ManokNaPula]

Hi there,

 

I am creating a ticketing system. I have a same idea as this forum post:

 

So I have three DataPages for just one workflow. I understand that I needed to have these when using standard feature, but I'm a bit short in Number of DataPages. So as much as possible, I would like to lessen it.

I have these DataPages.

1) Submission Form - where the tickets are being submitted.

2) For Assigning ticket (This will receive a timestamp which will indicate the Start Time for the ticket)

3) For Closing Ticket (Receives timestamp for closing the ticket)

 

And I also solve the Spent time for Start Time and End Time so I can see how long the ticket was resolved. 

 

Now, my plan is - to have this DataPage, where I can assign the Ticket handler and Status in one datapage. (Details Page)

The problem is, I can't figure out how to set the Start time and end time now.

 

Any ideas?

 

Scar 

[Glitch]

Hi Scarlet,

I figured out a way to do this on trigger. The idea is, you'll prevent using two DataPages since the Timestamp is being generated from the trigger.

This is a sample trigger you can use. 

So upon update, you can update the #inserted Start time if the technician (which in your case is the ticket handler), has been changed. And update the #inserted EndTime if the #inserted Status is closed. 

The case when statement there, is to update the fields only if the respective fields has been changed. 

Works like a charm.

Hope this helps, Scar.

Glitch ();

[cheonsa]

Hi @Glitch,

 

Just to give you some information, Caspio has a video tutorial on how to create a Ticket Management App. Maybe you can get some ideas to be added to the functionalities of your app. 

 

 

Cheers! 

 

-kristina

[Flowers4Algernon]

Hello! Just wanted to share these ready-made application that you may want to look into:

1.  https://marketplace.caspio.com/details/IT-helpdesk/
2. https://marketplace.caspio.com/details/support-ticketing-system/