Jump to content
  • 0

Ticketing System



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?



Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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 ();

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...