Jump to content
  • 0
Sign in to follow this  
Scarlet

Ticketing System

Question

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 

Share this post


Link to post
Share on other sites

1 answer 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. 

Screenshot_1.png.a4f5e1fb6f86c4c88b54c56ba6e3389a.png

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

Share this post


Link to post
Share on other sites
  • 0

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! :D

 

-kristina

Share this post


Link to post
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.

Guest
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.

Loading...
Sign in to follow this  

×
×
  • Create New...