I've been asked to create a report (in our data warehouse) that identifies tickets that had a specific form filled out - however there are some tickets with multiple forms filled out and the specific form that they want to report on has no unique fields so I can't base the report on field values being filled in. It looks like the data that is available via API and our Domo connector includes what the currently-selected form is, as well as a list of all available forms. But is there any way to identify which forms have ANY data filled in on a ticket? I'm guessing no, but wanted to confirm.
Any way to know what forms had any data in them in a ticket?
Hey Paul,
If none of the tickets have unique fields that you can test, you can perhaps test this by checking for the presence of ticket tags that align with your ticket fields? If a ticket has any tags present that matches a field, then you know it at least has some data present.
Hey Paul -
Ticket Forms & Fields are actually not directly tied together directly - that is to say if I fill out a field on Form 1, and then switch to Form 2 where the field is not available, the data will be retained and associated with the field even though it is no longer visible.
Therefore, I believe you would need to look at tickets containing field data and then figure out which forms had those fields associated with them. As mentioned, you can also determine which form the agent resolved the ticket on.
Hope this helps!
Brandon
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.